Demonstrate your understanding of Assembly in relation to other languages, your ability to apply existing ARM64 assembly mnemonics and techniques to a specific purpose, and to demonstrate the ability to….
Analyze the ERD for a student information system provided below.
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
· Create a new Database using MySQL.
· Create your SCRIPT file to be named as Ph3.sql.
Step 3: Include the following commands at the tops of your scripts:
· SET FOREIGN_KEY_CHECKS=0;
· DROP TABLE IF EXISTS STUDENT;
· DROP TABLE IF EXISTS CAMPUS;
· DROP TABLE IF EXISTS ROOM;
· DROP TABLE IF EXISTS COURSE;
· DROP TABLE IF EXISTS INSTRUCTOR;
· DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
· DROP TABLE IF EXISTS CLASS;
· DROP TABLE IF EXISTS STUDENT_GRADE;
· SET FOREIGN_KEY_CHECKS=1;
Step 4: Create Tables in your database
· Create a new Table for each of the entities provided to you in the ERD diagram in Step 1.
· Add a column to represent each attribute addressed in the ERD diagram in Step 1.
· Designate Primary Key, as noted in the ERD diagram in Step 1.
· Designate a Foreign Key relationship between the tables, as noted in the ERD diagram in Step 1.
· Enable referential integrity on the relationships, as needed.
· Enable cascade updates as needed on the relationships.
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.
· Dates: they should have a date data designation type.
· Surrogate keys: shall be auto-numbered
· Character type: shall have a character data designation type.
Step 6: Column Constraints Designation.
· Grade designation must be of one of these values as follows: A, B, C, D, E, F, W, E (E=enrolled, and W = withdrawn).
· Student’s first and last names are not to be designated as NULL.
· Course Credit hours shall be BETWEEN one and four.
· The instructor first and last name must NOT be NULL
· Course name designation has to be UNIQUE and must not be NULL type.
Step 7: Data Table Addition
· Use the INSERT operator to add minimum 2-3 rows of data per each database.
· You are free to use any values you might like for each of the columns.
· NOTE/ Reminder: you are required to add data to the parent table prior to adding any data to child tables, as referential integrity is enabled.
Step 8: Executing your SCRIPT
· Must incorporate the COMMIT command at the end of your Script
· Must incorporate the SHOW TABLES command, to display the table you created. At the end of the script created.
· Must incorporate the SELECT statement to show data allocated for each table. This would be added at the end of the script.
· EXECUTE your SCRIPT.
· Copy and paste your OUTPUT into your MS Word file as follows: Ph3_Output.doc