Pages

Tuesday 5 June 2012

CS506- Web Design and Development Assignment SEMESTER Spring 2012 idea solution No. 03

Assignment No. 03
SEMESTER Spring 2012
CS506- Web Design and Development

Total Marks: 20

Due Date: 7/06/2012
Instructions
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit (zero marks) if:
The assignment is submitted after due date.
The submitted assignment does not open or file corrupt.
The assignment is full 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.
The assignment is not submitted .java format.

Uploading instructions
Your Submission must include:

All the Source Code (.java files) and other if necessary files to compile and run your program.
If and only if there are multiple files to submit place all the files in a Zip file and Upload it on VULMS else only source code files and depending files are required to be submitted.
In case of difficulty in attempting this assignment you are welcome to discuss with us. But don’t copy from any other resource.
Use studentDSN name for DSN connection. Otherwise your database will not work.
Find attached database file and use it for your assignment database. Don’t change columns or table name. Otherwise our assignment will not work here. It is compulsory to use given database file.
Find an attached rs2xml.jar file this library will help you to populate JTable easily. If you don’t want to use this library you can code in your own way. Using this jar file is not compulsory.

Note: You can use any NetBeans, Eclipse for development of this assignment. Send instruction file, which will contain information about compilation and running process of assignment.

You can use assignment solution file for interface. Remember in this assignment you will get marks if your assignment will give all required functionalities. Graphical User Interface doesn’t have any mark in this assignment.
Objective
The objective of this assignment is

To give you some practice exercise of developing GUI application with the help of database and already developed libraries.

For any query about the assignment, contact at cs506@vu.edu.pk
GOOD LUCK
Question: 
Develop a simple GUI application with the help of MS Access database.

Administrator login interface. 

Check if username and password both are admin then show student information management window.

Student information management window.




Follow the same instruction that already given above, for student project information. The difference is before adding project record admin must select student from drop down combo box. For update information automatically select student on selecting record from above table (JTable to manage project detail) .

Hints:
To manage student information use Student class.
To manage student projects use Project class.
To store multiple students record use ArrayList.
To store multiple projects record use ArrayList.
To associate mutiple projects with a student create object of Project class in Student class.

Note: Your code must justify enough for 20 marks.
Lectures Covered: This assignment covers Lecture # 1-8
Deadline
Your assignment must be uploaded/submitted at or before 7/06/2012.