Question: Create a list of functional dependencies from the diagram. The functional dependencies for each entity or relationship type must be listed together before listing those

Consider the following ERD of the company database: Fname Minit Bdate Sen Supervisor Lname Name Address 

Create a list of functional dependencies from the diagram. The functional dependencies for each entity or relationship type must be listed together before listing those for another entity or relationship type. Do not list transitive dependencies e.g., if A -> B and B -> C, then do not show A -> C Do not list trivial dependencies e.g., if A -> B then do not show A, D -> B.

PLease write out each functional dependency separately, combining them implies they are related.

Must list the tables that each FDs fall under

Consider the following ERD of the company database: Fname Minit Bdate Sen Supervisor Lname Name Address EMPLOYEE 1 SUPERVISION Name Salary Sex N Supervisee Start_date N Sex WORKS FOR MANAGES M Number of employees> DEPENDENTS OF DEPENDENT 1 WORKS ON Birth_date Hours N Name Number Relationship Locations Name DEPARTMENT Number CONTROLS N PROJECT Location

Step by Step Solution

3.37 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Functional dependencies for the company database ER diagram EMPLOYEE ... View full answer

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 Databases Questions!