Question: Given the following is a relation with no known repeating groups: PROJECT-TEAMS(pCode, pName, pStart, pEnd, empID, eFName, eLName, jobTitle, empClass, consultRate, projPosition, projHour, projStart, projEnd,

Given the following is a relation with no known repeating groups:

PROJECT-TEAMS(pCode, pName, pStart, pEnd, empID, eFName, eLName, jobTitle, empClass, consultRate, projPosition, projHour, projStart, projEnd, projRate)

Dependencies:

pCode --> pName, pStart, pEnd

empID --> eFName, eLName, jobTitle, empClass, consultRate

pCode, empID --> projPosition, projHour, projStart, projEnd, projRate

jobTitle, empClass --> consultRate

NOTE: Primary keys must be solid underline. Since dashed underline cannot be drawn -- foreign keys must be clearly designated with (FK) next to attribute.

Copy-paste below part into your answer and fill in your answer following each question

A) Provide 1NF solutions below using relational notation. [1]

B) Provide 2NF solution below using relational notation. [2]

C)Provide 3NF solution below using relational notation. [2]

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!