Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

تمرين 8

Figure 14.12
Normalization into 2NF and 3NF.
(a) The LOTS relation with its functional dependencies FD1 through FD4.
(b) Decomposing into the 2NF relations LOTS1 and LOTS2.
(c) Decomposing LOTS1 into the 3NF relations LOTS1A and LOTS1B.
(d) Summary of the progressive normalization of LOTS.
-Prove that any relation schema with two attributes is in BCNF.