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.
