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.

Professional Australia Essay Writers | AustraliaEssayWriting.com

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

determine the context, order, and any linkages between the required elements listed below

 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….

Identify and write the main issues found discussed in the case (who, what, how, where and when (the critical facts in a case).

Case Study: You have just been hired to perform digital investigations and forensics analysis for a company. You find that no policies, processes, or procedures are currently in place. Conduct….

Identify dependencies between various business areas and functions.

PROJECT TITLE Business Continuity Plan for Financial Institutions ABSTRACT Due to increase in customers’ demand, competition, 24hrs continuous service, frequent changes in regulatory policy requirements and changes in various threats….