Normalize the database project Relational Schema, following the steps attached below, and create a Normalized version of the Relational Schema

must show the Dependency Diagrams used at each normal form for each table in the database

must show the DETAILED steps used at each normal form for each table in your project database.

must submit the NORMALIZED version of the Relational Schema of the database

The Relational schema must be drawn digitally (NOT manually with pen/pencil on paper

relational schema :

 

Normal Form First normal form (1NF) Second normal form (2NF) Third normal form (3NF) Boyce-Codd normal form (BCNF) Fourth normal form (4NF) Characteristic Table format, no repeating groups, and PK identified 1NF and no partial dependencies 2NF and no transitive dependencies Every determinant is a candidate key (special case of 3NF) 3NF and no independent multivalued dependencies Section 6-3a 6-3b 6-3c 6-6a 6-6b