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
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
Functional dependencies for the company database ER diagram EMPLOYEE ... View full answer
Get step-by-step solutions from verified subject matter experts
