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 script file with the SQL statements needed to create tables with keys and to insert test rows, etc., into the tables.
Submit your single SQL script file containing all statements to the Assignment Files tab.