Question: Given the ERD below, determine the Third Normal Form for the resulting relational database. Include all attributes and indicate all Primary keys and Foreign Keys.

 Given the ERD below, determine the Third Normal Form for the

Given the ERD below, determine the Third Normal Form for the resulting relational database. Include all attributes and indicate all Primary keys and Foreign Keys. Please use the following format: RELATION-NAME (Primary Key, Attribute, Attribute, Attribute, Foreign Key (FK]) PERSON Person-ID LastName FUNCTION Firstname Title Function Code Birthdate FunctionName PersonType Has EMPLOYEE Z CLIENT Z Owns Emp-WorkPhone Client-WorkPhone Leads TEAMMEMBER StartDate PROJECT TEAMMEMBER Job Title Responsibility TEAM TeamCode TeamName Works On Leads PROJECT Project-ID ProjectName Project Description MEMBERTASK Has TASK Task-ID TaskName TaskDescription TaskCosts TaskDueDate TaskCreateDate

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