Question: Consider the relation R = {A, B, C, D, E, F, G, H, I} and the set of functional dependencies {AB C, A DE, B

Consider the relation R = {A, B, C, D, E, F, G, H, I} and the set of functional dependencies {AB C, A DE, B F, F G, D HI}.

For each of the following decompositions of R, determine whether it has (i) the lossless join property; and (ii) which normal form each relation is in.

(a) D = {R1, R2, R3, R4, R5}, with R1 = {A, B, C}, R2 = {A, D, E}, R3 = {B, F}, R4 = {F, G}, R5 = {D, H, I}.

(b) D = {R1, R2, R3, R4, R5}, with R1 = {A, B, C, D}, R2 = {D, E}, R3 = {B, F}, R4 = {F, G, H}, R5 = {D, H, I}.

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!

Part (e) Problem 8 Consider a relation R (A, B, c, D, E, F, G, H) together with the functional dependencies AB E CD onsider RI (A, B, C, D) with the above functional dependencies. What would be a...

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

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

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

Database systems Please solution as soon as possible Consider the relation R (A, B, C, D, E, F, G, H) with the following functional dependencies: AB CH CF DE C,F EG GD Does the ration R in 3NF? If it...

4. 15 points] Let relation R (A, B, C, D, E, F, G, H) satisfy the following functional dependencies: AB CH A BD C EG H DE F Which one of the following FDs is also guaranteed to be satisfied by R? A....

Consider the relation R = {A, B, C, D, E, F, G, H, I, J} and functional dependencies {A, B} rightarrow {C} {A} rightarrow {D, E} {B} rightarrow {F} {F} rightarrow {G, H} {D} rightarrow {I, F} What is...

(a) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J and the set of functional dependencies F = { {A, B} {C}, {A} {D,E}, {B}{F}, {F}{G,H}, {D} -> {I, J}}. 1. Derive the key for R....

Which one is correct w . r . t . RDBMS ? primary key super key candidate key primary key candidate key super key super key candidate key primary key super key primary key candidate key The relation...

Mission Oak Company produces oak bookcases to customer order. It received an order from a customer to produce 5,000 bookcases. The following information is available for the production of the...

Included in Gonzalez Companys December 31 trial balance is a note receivable of $12,000. The note is a 4-month, 10% note dated October 1. Prepare Gonzalezs December 31 adjusting entry to record $300...

Which one of the following assets is not considered a capital asset? 1 ) ken owns a personal residence 2 ) drake owns us government secuthat he holds as an investment 3 ) darren bought a computer to...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

To whom might an entrepreneur present his or her business plan? Why? (Objective 4)

Assume you want to start a business in the community in which your school is located. What resources are available to youlocally or through the Internetas you approach the task of drafting a business...

A student organization to which you belong recently returned from its national conference. One of the highlights of the conference was announcement of Chapter of the Yearand your group won! Prepare...