Question: Consider the relational database schema R(A, B, C, D, E, F, G, H, I) with the following set of functional dependencies: {A} + {E, F}

Consider the relational database schema R(A, B, C, D, E, F,

Consider the relational database schema R(A, B, C, D, E, F, G, H, I) with the following set of functional dependencies: {A} + {E, F} {A,B,C,D} {G,H} {C,D,G} {A,B,1} {H} + {I} A. Use the inference rules to show that {A,B,C,D} {1}. (5 marks) B. Determine which ones of the following sets of attributes are superkeys and which ones are also candidate keys: {A,B,C,D} {C,D,G,H} {C,D,G} Justify your answer by computing the closures. (10 marks) C. Use the candidate keys that you have identified in part B to decompose the relation R such that it satisfies the 2NF

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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 Databases Questions!

need help on this Part 3 - Normalization [20 marks total] Case 1: The table R (A, B, C, D, E, F, G, H, Y) holds the following functional dependencies: FD1 A, C B, D, E, F, G, H, Y FD2 B H, Y FD3 G E,...

data base Consider the relation R (A, B, C, D, E, F, G, H, I) with the following functional dependencies: A, C B, D, E, F, G A- B, E, G, H, I B E CD Does the relation R in 3NF? If it does not, then...

Consider the relation R (A, B, C, D, E, F, G, H, I) with the following functional dependencies: A, C B, D, E, F, G A- B, E, G, H, I BE C-D . Does the relation R in 3NF? If it does not, then convert...

Consider the relation R (A, B, C, D, E, F, G, H, I) with the following functional dependencies: A, C B, D, E, F, G A B, E, G, H, I BE C-D Does the relation R in 3NF? If it does not, then convert it...

Consider the relation R (A, B, C, D, E, F, G, H, I) with the following functional dependencies: A, CB, D, E, F, G A B, E, G, H, I BE C-D Does the relation R in 3NF? If it does not, then convert it...

. Consider the relation R (A, B, C, D, E, F, G, H, I) with the following functional dependencies: A, CB, D, E, F, G A-B, E, G, H, I BE C-D . Does the relation R in 3NF? If it does not, then convert...

Consider the relation R (A, B, C, D, E, F, G, H, 1) with the following functional dependencies: A, C-B, D, E, F, G A-B, E, G, H, 1 .BE C-D Does the relation Rin 3NF? If it does not, then convert it...

General - Question 8 Not yet answered Consider the relation R (A, B, C, D, E, F, G, H, I) with the following functional dependencies: A, C-B, D, E, F, G AB, E, G, H, 1 CD Does the relation Rin 3NF?...

please solve as fast as possible i am in exam!!! Consider the relation R (A, B, C, D, E, F, G, H, I) with the following functional dependencies: A,B I A C B D,E F, B G G H . Does the ration R in 3NF?...

Consider the relation R (A, B, C, D, E, F, G, H, I) with the following functional dependencies: A, CB, D, E,F,G A + B, E, G, H, I BE C-D Does the relation R in 3NF? If it does not, then convert it...

Aaron wants to renovate the bathroom and kitchen in his home, and he hires Rodney for this work. They enter into a contract after agreeing to a cost of $50,000. However, once Rodney starts work, he...

1. Responsibility reports for a profit center includes: a. revenues only. b. invested capital. c. both revenues and costs. d. returns on investments. 2. Brad, one of the managers of a multi-national...

25. 1. Carolina Creations recently discovered that a payroll clerk had issued checks to nonexistent employees for several years and cashed the checks himself. The company does not have any internal...

Question 5 [ 2 0 ] SMB is a small local corporate entity that operates a transport business in Country X . On 1 April 2 0 1 3 SMB acquired an additional vehicle that qualified for tax depreciation...

1. Integrated talent management is the new buzzword. Rather than considering each aspect of creating a talent pipeline as a separate process, companies are beginning to integrate all processes to...

2. Global leadership development is an important business activity. The globalization of business means that employees at all levels must be up- skilled to work effectively with colleagues around the...

3. Ongoing skill gaps are being identified between what is needed to perform todays jobs and the lack of qualified people to fill them. Nearly half of the executives of U.S. firms cite skill gaps as...