B. C. D. What is the primary key of PROJECT? Are all the nonkey attributes (if any) dependent on the primary key? In what normal form is PROJECT?

icon
Related questions
Question
Regional Labs is a company that conducts research and development work on a contract basis
for other companies and organizations. Figure 2-33 shows data that Regional Labs collects
about projects and the employees assigned to them.
This data is stored in a relation (table) named PROJECT:
PROJECT (ProjectID, Employee Name, EmployeeSalary)
ProjectID
100-A
100-A
FIGURE 2-33
Sample Data for
Regional Labs
100-B
200-A
200-B
200-C
200-C
200-D
EmployeeName
Eric Jones
Donna Smith
Donna Smith
Eric Jones
Eric Jones
Eric Parks
Donna Smith
Eric Parks
Employee Salary
64,000.00
70,000.00
70,000.00
64,000.00
64,000.00
58,000.00
70,000.00
58,000.00
Transcribed Image Text:Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-33 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, Employee Name, EmployeeSalary) ProjectID 100-A 100-A FIGURE 2-33 Sample Data for Regional Labs 100-B 200-A 200-B 200-C 200-C 200-D EmployeeName Eric Jones Donna Smith Donna Smith Eric Jones Eric Jones Eric Parks Donna Smith Eric Parks Employee Salary 64,000.00 70,000.00 70,000.00 64,000.00 64,000.00 58,000.00 70,000.00 58,000.00
B.
C.
D.
E.
What is the primary key of PROJECT?
Are all the nonkey attributes (if any) dependent on the primary key?
In what normal form is PROJECT?
Describe two modification anomalies that affect PROJECT.
Transcribed Image Text:B. C. D. E. What is the primary key of PROJECT? Are all the nonkey attributes (if any) dependent on the primary key? In what normal form is PROJECT? Describe two modification anomalies that affect PROJECT.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer