CS506 Web Design and Development Assignment No.3 Solution Spring Semester 2013

Assignment No. 03
SEMESTER Spring 2013
CS506- Web Design and Development
Total Marks: 20
Due Date: 20/05/2013

HRM is the management of employees within an organization. At present stage all the Human Resource (HR) work for JS Group of Industries is managing manually. Each time to change employee information, the manager needs to update the record manually in different locations/ places, which is a tedious job for the HR manager and prone to errors.

As in the second assignment we had designed different GUIs for HR Manager of JS Group of Industries. So in this assignment we are going to connect the GUI’s with database and perform different event handling.

Solution Guidelines:

First you have to create a database in MS Access named as “Employee”.

There should be a table in “Employee” database named as “Personal Information”

Set Data source name (DSN) for your database.

You can also get help from the 2nd assignment solution for GUI’s creation.

Note:

Submit the complete working project in zip format
Event handling and database connection must be work; otherwise you will get zero marks.
Your code must be enough for 20 marks
Sample Output:
When you run the program:
User fill the form and click on “Save” button, then all the information will be saved in “Personal Information” table of “Employee”database
When User click “Search Personal Information” tab, then:
User provides the ID that he/she wants to search. As a result all the data that is stored in the database will be display.
When user click “Delete Personal Information” tab, then:
The user provides ID and all the records of that ID will be deleted from the database “Personal Information” table.