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

تمرين 7

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.
-In what normal form is the LOTS relation schema in Figure 14.12(a) with respect to the restrictive interpretations of normal form that take only the primary key into account? Would it be in the same normal form if the general definitions of normal form were used?