Fundamentals of Database Management Project Final Report

BCIS 5420 PROJECT PART-1

DB-TEAM 14 Rachana Baddula- 11516477 Akhil Reddy Kotha- 11521532 Ashritha Bagati- 11507716 Divya Thailam-11504522 There are 2 assumptions that are made in this project: 1. The hired consultants are assigned to projected based on their skillset by the project manager. One of the new hired consultants may end up as a project manager and the rest would be associates. 2. Project manager evaluates the consultants by their performance and the consultants evaluate the manager. We have 3 main tables: Consultant, client and project. 1. Because of a consultant can work on multiple projects and each consultant should be assigned with one project there is a one-to-many relationship with the consultant and the project. To connect the project and the consultant we create a Consultant Details_has_Project, which is an association table to store the information. 2. Each client is assigned with multiple projects and each project stores multiple client information. The association table called Project_has_ClientInformation is used to connect both the entities. 3. Each consultant is evaluated based on the performance on the project they worked on. In the same way all the consultants will evaluate the project manager so, the relation between them should be one to many. 4. Each consultant should have atleast one skill so, there is a one to. Many relation between them.

BCIS 5420 PROJECT PART-1

ER DIAGRAM: