Pick one of the three common relationship types that often give an opportunity for denormalization (one-to-one; many-to-many with non-key attributes; reference data (1:N)) and make up a possible scenario that would fit it. a. Provide the normalized relations that represent your scenario.
b. Now, show the resulting relation(s) if you were to denormalize what you provided above.
c. Explain the advantages and disadvantages to what you did in (b). Or, if you were not able to denormalize, justify why it was not possible. Answer (12 pts):