INSTRUCTIONS Please find the full requirement in the attached file. 1. Summary: To apply all acquired knowledge in the last Project Assignments to create a Database Scheme. For this proje


INSTRUCTIONSPlease find the full requirement in the attached file.

1.             Summary:

To apply all acquired knowledge in the last Project Assignments to create a Database Scheme. For this project, the ERD is provided to you.

Deliverables:

Required Software:

Lab Steps:

Step 1: Analyze the ERD for a student information system provided below. Be alert for the specifications provided for: 1) Entities, 2) Attributes, 3) Primary Key, and 4) Relationships.  You will need to have a clear understanding for these components to create your database using MySQL.

Step 2: Create a New Database in MySQL, Produce SQL File, Drop Table

Step 3: Include the following commands at the tops of your scripts:

Step 4: Create Tables in your database

Step 5: Designate Data Types. Update the data type as needed to enforce the domain constrain of the data. This needs to be completed for every column for all tables.

Step 6: Column Constraints Designation.

Step 7: Data Table Addition

Step 8: Executing your SCRIPT

Step 9: Upload your work

Please find the full requirement attached.