Must Read and prepare Part E exactly like the attach sample file .

you should carefully answer below questions

Step. 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:

Step6.1-6.2.docx