Must Read and prepare Part E exactly like the attach sample file .you should carefully answer below questionsStep. Begin with the relational schema that you have already developed.for each table on the list identify functional dependencies..Step 2. Show why the table is 1NF 2NF 3NF . Most of the tables will already be normalized because we spent time on the ER diagram and the relational model.Step 3. If the tables are not normalized you must normalize them. Show me the work that you have done. For each table list the functional dependencies and how you have normalized it.Step 4. Give the final schema for the relational model.Step 6.2 Update the data dictionary and the list of assumptions as needed.
Attachments: