We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

Assignment No. 2 Fall spring 2015 CS506- Web Design and Development Total Marks: 25 Due Date: 8 june, 2015

Dear Students,

Assignment No. 2 has been uploaded last date for submission of Assignment No. 2 is Monday, June 08, 2015.
 
Note: No Assignment will be accepted through e-mail. 
See attach file

Assignment No. 02

 Spring 2015

CS506- Web Design and Development

Total Marks: 25

Due Date: 08/06/15

Instructions

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit  if:

  • The assignment is submitted after due date.
  • The submitted assignment does not open or file corrupt.
  • The assignment is fully or partially copied from (other student or ditto copy from handouts or internet).
  • Student ID is not mentioned in the assignment File or name of file is other than student ID.

Uploading instructions

You are required to submit your solution in Power Point File (.ppt or .pptx) with audio narration. Assignment submitted in any other format will get zero marks. Assignment sent through email will not be accepted in any case. 

Note: Use JDK for compiling/running of java program (A video tutorial of installation and configuration of JDK is given in course download section). 

Visit the following link for installing and configuring of JDK.

Tutorial for installing JDK for windows 7

Tutorial for installing JDK for Windows XP

Guidelines for installing JDK

Following is link for downloading JDK 7

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downlo...

Objective

The objective of this assignment is

  • Understanding the Java Database Connectivity (JDBC)
  • Compiling/running of java program

 

Problem Statement:

You are required to write a java program which display Student information from a database. For that, you will require to perform three steps.

Step 1: firstly perform the following steps for creation of database and table in MS Access.

  • Create a database in MS Access with any name
  • Create a table named as “StudentInfo”, having three fields (VUID, Studentname, Coursename).
  • Insert one row in table StudentInfo i.e. containing your own VUID, your name and course name. 

( procedure to create a database in MS Access is given in handouts)

Following is screen shot of sample MS Access Database

You have to create the table and insert one record in table Studentinfo contains your own VUID, name and course code as explained in above screen shot.

Step 2: write a java program in notepad that will perform Java Data base Connectivity with MS Access database, (show all database connectivity steps).

(A tutorial to create a DSN connection is given in course download section)

http://vulms.vu.edu.pk/Courses/CS506/Downloads/How%20to%20create%20...

 Tutorial for creating DSN for windows 7

Step3: Compile and run the program in JDK (on command prompt) and display Student Information from database on command prompt

Note:  You are required to compile/run the java program in JDK. Don’t use NetBeans, Eclipse or any other IDE for creating Assignment No. 2 .

You can download the JDK 7 from the following link.

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downlo...

Sample Output:

Insert the one record in table Studentinfo, contains your VUID, name and course code.  Compile and run your program as described above

Submission:

You are required to submit your solution as a presentation in PowerPoint File (.ppt or .pptx) with audio narration through LMS. Assignment submitted in any other format will get zero marks.

Prepare presentation slides in following way.

a)      In first slide give a brief introduction of your program and show a snapshot of MS Access database table “Student Info” and very briefly describe it.

b)      In second slide show your solution (java code) and record audio narration which will explain all database connectivity steps. You need to give very brief explanation for each line of code. While recording audio narration, don’t forget to speak your name and VU-ID in the beginning. 

c)      Take screen shot of compiling/running of your java program in command prompt and paste that screen shot in third slide. In this slide you have to explain the procedure of compiling and running of your program with audio narration.

Steps for Recording the Presentation

Recording of Presentation (PowerPoint 2010/13)

  1. Record a narration before or during a slide show.
  2. When you record a narration, you run through the presentation and record each slide. You can pause and resume recording any time.
  3. Ensure your microphone is set up and working properly prior to recording your slide show.
  4. On the Slide Show tab, in the Set Up group, click Record Slide Show .
  5. Select one of the following:In the Record Slide Show dialog box, select the Narrations and laser pointer check box, and if appropriate, select or deselect the Slide and animation timings check box.
    • Start Recording from Beginning
    • Start Recording from Current Slide
  6. Click Start Recording.
  7. To end your slide show recording, right click the slide, and then click End Show.
  8. The recorded slide show timings are automatically saved and the slide show appears in Slide Sorter view with timings beneath each slide.
  1. A sound icon  appears on the slide.

Preview the Recorded Presentation

  1. In Normal view, on the slide, click the sound icon .
    1. a.      OR
    2. On the ribbon, under Audio Tools, on the Playback tab, in the Preview group, click Play.

To record a sound for a PowerPoint 2003/2007 presentation, you can follow the steps below:

  1. Open the PowerPoint presentation you are going to record a sound in, and go to Insert -> Movies and Sounds -> Record Sound
  2. In the Record Sound dialog, Name field, enter a name for the recording.
  3. Next, at the bottom of the dialog, click the red dot (the Record button) to start recording a sound.
  4. When finished, click the blue square (the Stop button) on the left of the Record button.
  5. To test the recorded sound, click the blue triangle (the Play button).
  6. Record another sound if the existing one is not satisfying. To confirm the recorded sound, click OK. The sound icon is displayed on the current slide.

Deadline: Your assignment must be uploaded/submitted at or before.08/06/15. No assignment would be accepted through email. For any query about the assignment, contact at cs506@vu.edu.pk

 

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 17963

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Attachments:

Replies to This Discussion

Problem Statement:

You are required to write a java program which display Student information from a database. For that, you will require to perform three steps.

Step 1: firstly perform the following steps for creation of database and table in MS Access.

  • Create adatabase in MS Access with any name
  • Create a table named as “StudentInfo”, having three fields (VUID, Studentname, Coursename).
  • Insert one row in table StudentInfo i.e. containing your own VUID, your name and course name.

( procedure to create a database in MS Access is given in handouts)

Following is screen shot of sample MS Access Database

You have to create the table and insert one record in table Studentinfo contains your own VUID, name and course code as explained in above screen shot.

---------

Step 2: write a java program in notepadthat will perform Java Data base Connectivity with MS Access database, (show all database connectivity steps).

(A tutorial to create a DSN connection is given in course download section)

http://vulms.vu.edu.pk/Courses/CS506/Downloads/How%20to%20create%20...

Tutorial for creating DSN for windows 7

-------

Step3: Compile and run the program in JDK (on command prompt) and display Student Information from database on command prompt

Note: You arerequired to compile/run the java program in JDK.Don’t use NetBeans, Eclipse or any other IDE for creating Assignment No. 2 .

You can download the JDK 7 from the following link.

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downlo...

---

Submission:

You are required to submit your solution as a presentation inPowerPoint File(.ppt or .pptx) with audio narrationthrough LMS.Assignment submitted in any other format will get zero marks.

Prepare presentation slides in following way.

a)      In first slide give a brief introduction of your program and show a snapshot of MS Access database table “Student Info” and very briefly describe it.

b)      In second slide show your solution(java code) and record audio narration which will explain all database connectivity steps. You need to give very brief explanation for each line of code. While recording audio narration, don’t forget to speak your name and VU-ID in the beginning. 

c)      Take screen shot of compiling/running ofyour java program in command prompt and paste that screen shot in third slide. In this slide you have to explain the procedure of compiling and running of your program with audio narration. 

Facing Problem when Run the complied file 

have you installed Microsoft Access ?

u need to install same bits softwares,, like msoffice should be 32 bit if window and netbeans and java is 32 bit,, all should be 32 bits, otherwise all should be 64 bits

best suggestion: get a vm on your system with 32 bits and all the softwares is also 32 bits and netbeans also,.

ye to page open hi nai ho raha

Dear Friends
i am using windows 8.1 and java sdk version 8 and i am also facing the same problem but it is recommended to get rid from this is
Instructor's Reply:

JDBC-ODBC Bridge is removed in JDK 8. So it is recommended to download and install JDK 7 from the following link to perform database connectivity.
Visit the following link for downloading the JDK 7.
http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downlo...

Few Video Tutorials to solve Assignment No. 2:

How To Install ODBC Driver on Windows 7/8/8.1: http://goo.gl/wz5i8p

How to Create Fresh Database in MS Access: http://goo.gl/n7xWvc 

plz koi ODBC driver for window xp k lea bi bta dy 

plz plz plz uska enviroment kesy set krna he 

?????

same procedure he 

 interestng assignment. 

i face ths prblm plz slv it

RSS

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.