Question: This question relates to SQL databases normalisation A table consisting of the employees, projects and managers is given below. Assumptions and constraints: The EMP _

This question relates to SQL databases normalisation
A table consisting of the employees, projects and managers is given below. Assumptions and constraints: The EMP_(I)D, PROJ_(I)D and MGR_(I)D are unique. A project can have more than one worker. The employees first name is not unique. The hourly rate for a particular job type is fixed. A worker can work on more than one project but has only one job type. A manager can take more than one project.
1. Identify the composite primary key in the 1NF table.
2. List and name all the dependencies in the 1NF table. Use the notation xy to present the dependency.
- Please state which dependencies are full, partial or transitive dependencies
Thank you very much
This question relates to SQL databases

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!