Question: Consider the relational schema R(A, B, C, D, E, G, H, I, J) and a set of functional dependencies F = {AI BC, CGI,

Consider the relational schema R(A, B, C, D, E, G, H, I, J) and a set of functional dependencies F = {AI BC, 

Consider the relational schema R(A, B, C, D, E, G, H, I, J) and a set of functional dependencies F = {AI BC, CGI, EIBG, I AHJ, B I, JHI). Note that A, B, C, D, E, G, H, I, J are attributes. 1. Find a minimal cover Fm for F. Please justify your answer. (3 marks) 2. Compute total number of the super keys of R with respect to F that are not candidate keys. Please justify your answer. (3 marks) 3. Given the smallest possible number of functional dependencies you need to delete from the minimal cover to make R satisfying 3NF. Please justify your answer. (4 marks) 4. Decompose R into BCNF based on your edited minimal cover from Question 3(a).3 (last question) and indicate a key in each of the resulting relation by underlining the attributes. Please justify your answer. (4 marks)

Step by Step Solution

3.55 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Consider the relational schema RA B C D E G H I J and set of functional dependencies The set of functional dependencies on the relation R is as follows FAIBCCGIEIBGIAHJBIJHI 1 The minimal cover for th... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!