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
Get step-by-step solutions from verified subject matter experts
