Answered step by step
Verified Expert Solution
Question
1 Approved Answer
B . What is the primary key of PROJECT? ProjectID . . . . C . Are all the nonkey attributes ( if any )
B What is the primary key of PROJECT?
ProjectID
C Are all the nonkey attributes if any dependent on the primary key?
Explain: Yes, it is dependent on the primary key PrejectID for EmployeeName but EmployeeSalary is might not be depend on ProjectID. Because each Name is associated with each ProjectID but Salary is not just depend on project, it can be influenced by other things too.........................
D In what normal form is PROJECT?
PROJECT ProjectID EmployeeName, EmployeeSalary
The third normal form NF
E Describe two modification anomalies that affect PROJECT.
The two modification anomalies that affect PROJECT are:
INSERTION: when we insert some new project data to it Like we know the employees name but dont know the ID that will cause the error
MODIFICATION: data update, for example Parks salary has be increase and we need to update it But it will cause error when we try to do for every project the Park was in
F Is ProjectID a determinant? If so based on which functional dependencies in part A
Yes, ProjectID is a determinant based on the functional dependency
ProjectID EmployeeName
G Is EmployeeName a determinant? If so based on which functional dependencies
in part A
NO only ProjectID EmployeeName
H Is ProjectID EmployeeName a determinant? If so based on which functional dependencies in part A
NO only ProjectID EmployeeName
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.
The following seems workable:
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 Started