CS506 Assignment No 2 Solution Fall 2017

CS506 Assignment No 2 Fall 2017

Dear Students, CS506 Assignment Solution has been added. Here you can read or Download CS506 - web design and development Assignment No 2 Solution and Discussion of Semester Fall 2017. Assignment Due Date is 24 November, 2017. Total Marks are 20. We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions. Previously we shared All CS Subjects Mid Term Past Papers Collection.

CS506 Assignment Uploading instructions:

Your assignment should be in .zip /.rar format.

Save your assignment with your ID (e.g. bc000000000.rar).

No assignment will be accepted through email.

CS506 Assignment Rules for Marking:

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, execute or file is corrupted.

Your assignment is copied from internet, handouts or from any other student

(Strict disciplinary action will be taken in this case).

CS506 Assignment Question

Create a new database in MS Access and add a table in the database. The name of database should be same as your own VU ID (like BC0000000) and the name of table should be Student. Student table will have four attributes i.e. ID, NAME, ADDRESS and PROGRAM.

Now, design a graphical user interface in java as given below (You must have to mention your own VU ID in title as shown in screenshot).

CS506 Assignment Question

Assignment Tasks

Add new record in database

Whenever user enters some new data in text fields and clicks “Add Record in Database” button, all the text fields’ data should be stored in Student Table.

Search a record from database on the basis of ID and display it on screen

Whenever user enters any ID in text field and clicks “Search Record from Database” button, your program should fetch this record from database. If this ID is available in database then display the record of this ID in the mentioned text fields otherwise show an error message that no such record is available.

Instructions Regarding Development

If you are using JDK1.8 or above then you’ll have to use u can access driver to connect to MS Access database. In this case, I'll suggest you to view the following tutorial.

https://vulms.vu.edu.pk/Courses/CS506/Downloads/UCanAccess.mp4

Following links will be helpful in creating new database in MS Access.

Instructions Regarding Submission

After completing your code, execute your java file(s) and take the screenshot of the output/result. Now, compress your code, database file and screenshot of the output using winzip or winrar and upload it on VULMS.

Please Note :
Do not put any query on MDB about this assignment, if you have any query then email at CS506@vu.edu.pk. Furthermore, if any student found cheating from any other student or from online forums then he/she will be awarded ZERO right away and strict disciplinary action will be taken against the student.