The following assignment is based on the database environment designed in the Week Three Individual Assignment.
Your database project must meet the following assessment requirements:
Create a database using professional principles and standards.
Use a relational database software application to develop a database implementing the logical design into a physical design.
Use MySQL database to create the normalized physical database including tables, columns with data types, primary keys, constraints, etc.
Create a minimum of ten rows of test data in each table in an SQL file with the scripts needed to create tables with keys and to insert test rows, etc., into the tables.
For week 4:
1. submit your final ERD (after your normalized changes)
2. submit SQL scripts for database creation, table creation with keys, insert statements of 10 rows in each tables
3. submit a word doc with the screenshots from your DB showing your DB, tables, rows in each tables.
All the above 3 can be put in one single word doc as your assignment submission.