Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q 7 : [ 5 marks ] Consider the Payment relation and its FDs to answer the following questions: Payment ( assistant No , assistantName,
Q: marks Consider the Payment relation and its FDs to answer the following questions: Payment assistant No assistantName, job Type, hours, ratePerHour FD: assistant No assistant Name, job Type, hours, ratePerHour FD: assistant Name assistant No job Type, hours, ratePerHour FDs: job Type ratePerHour a mark For, what does FD indicate about assistant Name attribute? b mark Explain briefly why the above relation is or is not, in INF, NFNF and BCNF If it is not, decompose it to comply with the three normal forms. marks if the job Type attribute is removed from the Payment relation, then in the table below write X in front of each Normal Form NF to indicate whether it is satisfied it or violated by the relation: Satisfied Violated NF INF NF NF BCNF
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