Question: consider the payment relation and its FDs to answer the following questions. Payment ( assistantNo , assistantName , jobType , hours, ratePerHour ) FD 1
consider the payment relation and its FDs to answer the following questions. PaymentassistantNo assistantName jobType hours, ratePerHour FD: assistantNo assistantName jobType hours, ratePerHour FD: assistantName assistantNo, jobType hours, ratePerHour FD: jobType ratePerHour a for, what does FD indicate about assistantName attribute? b explain breifly why the above relation is in NF NFND and BCNF if it is not, decompose it to comply with the three normal forms. c if the jobType attribute is removed from the Payment realtion, then for each NFNFNH and BCNF indicate with its satisfied or violated by the relation
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
