Database Reference
In-Depth Information
Regional Labs Case Questions
Regional Labs is a company that conducts research and development work on a contract basis
for other companies and organizations. Figure 3-32 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, EmployeeName, EmployeeSalary)
A.
Assuming that all functional dependencies are apparent in this data, which of the fol-
lowing are true?
1.
ProjectID
S
EmployeeName
2.
ProjectID
S
EmployeeSalary
3.
(ProjectID, EmployeeName)
S
EmployeeSalary
4.
EmployeeName
S
EmployeeSalary
5.
EmployeeSalary
S
ProjectID
6.
EmployeeSalary
S
(ProjectID, EmployeeName)
B.
What is the primary key of PROJECT?
C.
Are all the non-key attributes (if any) dependent on the primary key?
D.
In what normal form is PROJECT?
e.
Describe two modification anomalies that affect PROJECT.
F.
Is ProjectID a determinant? If so, based on which functional dependencies in part A?
G.
Is EmployeeName a determinant? If so, based on which functional dependencies in
part A?
h.
Is (ProjectID, EmployeeName) a determinant? If so, based on which functional depen-
dencies in part A?
I.
Is EmployeeSalary a determinant? If so, based on which functional dependencies in
part A?
J.
Does this relation contain a transitive dependency? If so, what is it?
K.
Redesign the relation to eliminate modification anomalies.
Figure 3-32
Sample Data for regional
Labs
Search WWH ::
Custom Search