1. What is the highest-normal form for Relation T? Show all the reasoning. 

2. If T is not already at least in 3NF, decompose the relation into 3NF. Specify the new relations and their candidate keys. Your decomposition has to be both join-lossless and dependency-preserving. If T is already in 3NF but not BCNF, can it be decomposed into BCNF?

T(A, B, C, D, E, F, G) Note: All attributes contain only atomic values. 

AF → BDEG, G → DE, B → C

 

Answer rating: 100% (QA)

To determine the highest normal form for relation T we need to examine its functional dependencies and apply the rules of normalization Lets analyze t... View the full answer