Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given universal schema R(A,B,C,D,E,F,G,H,I) and a set of functional dependencies as follows: AB CD A E B FH C G D B G C H

Given universal schema R(A,B,C,D,E,F,G,H,I) and a set of functional dependencies as follows:

AB CD

A E

B FH

C G

D B

G C

H I

when schema R(A,B,C,D,E,F,G,H,I) is normalized or decomposed into the following schema:

R1(A,B,C,D)

R2(A,E)

R3(B,F,H)

R4(C,G)

R5(H,I)

Group of answer choices

b. The decomposition created is in the third normal form.

c. both a. and b.

a. The decomposition created is in the Boyce-Codd normal form.

d. neither a. nor b.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Oracle Database Upgrade Migration And Transformation Tips And Techniques

Authors: Edward Whalen ,Jim Czuprynski

1st Edition

0071846050, 978-0071846059

More Books

Students also viewed these Databases questions