case file

Case Study.docx

Company X wanted to hire someone to create a database to store information about its projects and employees.

After discussing with the business analyst, I have decided that The database will contain 4 main entities:

• Department
• Employee
• Project
• Dependant (weak)

So I have started with the ER Diagram decided the attributes for each entity:

First entity employee:

• SSN is a simple attribute and unique because it is ID and it will be the primary key
• Birth Date is a simple attribute
• Gender is a simple attribute
• Name is a composite attribute that has Fname and Lname.

Second entity departments:

• DName is a simple attribute
• DNUM (unique) is a simple attribute and unique and it will be the primary key