Deliverables:
- SQL Script with your name as follows: YourLastName_Project_Ph3.sql.
- MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.
- ZIP file to include the two files mentioned above.
- Required Software:
- MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench.
- Follow Step 1-3 for your Course Project Phase phase 1, to install the required software component
- 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
0 comments