Course Code : CS-67

Assignment Number : BCA(4)-67/Project/06

Maximum Marks: 15

Last Date of Submission : 30^th April, 2006

This is a project assignment. Answer the following question.

Question 1: Study the following situation in detail and design an E-R diagram and implement the database scheme for them.

A Neworking Solution Company has three different types of groups, each headed by a Technical Manager: (i) The Network Installation Group (ii) The Network Management Solution provider Group and (iii) The Market Research Group. Each Group has about 8-10 members. The company has about 30 employees. Eight of them have specialised in Network Installation, and can be put for network installation only. The remaining employees can be made part of any of the other two groups depending on the work experience/ expertise of the person and the size of the networking project. The projects are acquired by the market research group who submits the proposals with different clients. Once a project is obtained, the Network Installation Group sets up the network and then hands over to Network Management Solution provider group which maintains and updates the networks as per the needs of the client for a period of one year. This servicing contract is renewed every year at a cost (if client desires so). Design the suitable database system that keeps track of various projects of the company and their states (proposal, installation, maintenance, yearly contract etc.), the business generated by the company, salaries of the employees, financial health of company, present assignments of the employees and details of the clients. Implement the system using MS-Access.

Include the following details in your project report:

• A brief account (1-2 pages) about system requirements.

• Details of Normalised tables.

• Constraints on data values.

• Referential Integrity constraints.

• Design minimum two forms and two reports.

• Views and SQL queries for various users.

• SQL commands for users and their access rights.

• Prepare the system catalog/data dictionary.