Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: James Stewart

8th edition

1285741552, 9781305482463 , 978-1285741550

More Books

Students also viewed these Programming questions