This exercise is based on four different inventory relation schemas: P, Q, R, and S. An instance of each relation schema is given below, each of which reflects a different design objective.

a. Identify the primary key of each relation schema.
b. Indicate the functional dependencies and/or multi-valued dependencies present in each design.
c. Evaluate each design for a fourth or fifth normal form violation. Explain your conclusion in each case.
d. Where there is a fourth normal form violation, provide a revised lossless-join design that is in fourth normal form.

Transcribed Image Text:

Par | Color | Store# Part# | Color Part# | Color Stor Part# | Color | Store# Red Red Bhue Green Blue Green Blue Green Ble 17 Blue 17 White B White Red 17 GreenB Black 18 Green 18 Bhck Bhck