Question: Given the schema S = ( : { A , B , C , D , E , G , H } , F :

Given the schema S=(:{A,B,C,D,E,G,H},F:), where F represents the following dependencies:
GBD
GD
EB
BH
HC
EC
EBAH
EA
i. Find a minimal cover for this schema.
ii. Find a key for this schema.
iii. Find a third normal form decomposition for this schema.
iv. Find a BCN form decomposition for this schema.
v. Determine whether the following decompositions are lossy or lossless.
R1={E,C,B}R2={D,H,E,G,A}
R1={H,B}R2={C,D,E,A,G,B}
For this question, write your solution on paper then take a picture of the solution and upload.
 Given the schema S=(:{A,B,C,D,E,G,H},F:), where F represents the following dependencies: GBD

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!