Consider the universal relation schema STOCK (Symbol, Company, Exchange, Investor, Date, Price, Broker, Dividend) and the following dependencies set:
fd: Symbol → {Company, Exchange, Dividend}
mvd: Symbol --->> {Investor, Broker}
a. Identify the primary key such that STOCK is in first normal form.
b. Explain the immediate normal forms violated by the functional dependencies and multi-valued dependencies.
c. Step through the normalization process to obtain a final design that is in fourth normal form. At each level of decomposition, indicate the primary key and dependencies resolved and explain the normal form achieved and violated in each one of the decomposed relation schemas. Explain how each of the decompositions is lossless. Finally, show all integrity constraints in the final relational schema.
d. Reverse engineer your final design to a Presentation Layer ER diagram.