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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Managerial Accounting
Authors: Karen W. Braun, Wendy M. Tietz
4th edition
978-0133428469, 013342846X, 133428370, 978-0133428377
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App