Question: ( 6 marks ) Consider the relational schema R ( A , B , C , D , E , G , H , I,
marks Consider the relational schema RA B C D E G H I, J and a set of functional dependencies F A EH BE G DI AJ GH CI C BDI Note that A B C D E G H I and J are attributes. Regarding F given a decomposition RADIG RABEG RCEGH and RBECJ of R i Is R in NF Please justify your answer. marks ii Is the decomposition lossless? Please justify your answer. marksb marks Consider the relational schema RA B C D E G H I, J and the set of functional dependencies F AE CGH BE IJG, D AI GJ DE AHI B Note that A B C D E G H I and J are attributes. Justify your answer to each question. i Determine the highest normal form of R marks ii Find all the candidate keys for R marks iii. Find a minimal cover Fm for F marks iv Decompose R into BCNF marks v From your answer in iv is your decomposition dependency preserving? marks
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
