Table: Student

Student$\_$ID

Student$\_$Email

Student$\_$FName

Student$\_$LName

Student$\_$Phone

Table: Class$\_$Instructor

Instructor$\_$ID

Instructor$\_$Name

Instructor$\_$Pref

Instructor$\_$Email

Instructor$\_$Education

Table: Class

Class$\_$ID

Class$\_$Name

Class$\_$Credits

Class$\_$Start$\_$Date

Class$\_$Fee

Table: Registrater$\_$Class

Reg$\_$ID

Reg$\_$Date

Student$\_$ID$\_$KF

Instructor$\_$ID$\_$KF

Class$\_$FK

Class$\_$Price

Q$1$: Database Table Creation and Constraints $-[30$ Points$]$

Task: Create tables with proper Primary Key $($PK$),$ Foreign Key $($FK$),$ Data Types, Data Size, Constraints, and Naming Standards. All tables should have the student's Campus$\_$ID in the name. Example: TableName$\_$Student$\_$IM$19182.$

A$.$ Create the Student$\_$XXXXXXX Table $-[3$ Points$]$

Query: Provide the SQL query to create the table.

Explanation: Explain the structure and reasoning behind the chosen data types, constraints, and naming conventions.

Screenshot: Include a screenshot of the successful creation of the table.

B$.$ Create the Class$\_$Instructor$\_$XXXXXXX Table $-[3$ Points$]$

Query: Provide the SQL query to create the table.

Explanation: Explain the structure and reasoning behind the chosen data types, constraints, and naming conventions.

Screenshot: Include a screenshot of the successful creation of the table.

C$.$ Create the Class$\_$XXXXXXX Table $-[3$ Points$]$

Query: Provide the SQL query to create the table.

Explanation: Explain the structure and reasoning behind the chosen data types, constraints, and naming conventions.

Screenshot: Include a screenshot of the successful creation of the table.

D$.$ Create the Registrater$\_$Class$\_$XXXXXXX Table $-[3$ Points$]$

Query: Provide the SQL query to create the table.

Explanation: Explain the structure and reasoning behind the chosen data types, constraints, and naming conventions.

Screenshot: Include a screenshot of the successful creation of the table.

E$.$ Create Named Constraints for Primary and Foreign Keys $-[5$ Points$]$

Query: Provide the SQL query to create named constraints for Primary and Foreign Keys.

Explanation: Explain why the specific constraints were used, their naming conventions, and how they maintain data integrity.

Screenshot: Include a screenshot of the successful application of constraints.

F$.$ Add Not Null Constraint to Student Name $-[3$ Points$]$

Query: Provide the SQL query to add a Not Null constraint to the Student name.

Explanation: Explain the importance of this constraint and how it will affect data entry.

Screenshot: Include a screenshot of the successful addition of the constraint.

G$.$ Add Check Constraint for Class$\_$Name in Classes Table $-[5$ Points$]$

Query: Provide the SQL query to add a Check constraint for Class$\_$Name to ensure it is one of the following: $($IS$147,$ IS$247,$ IS$310,$ IS$410).$

Explanation: Explain how the check constraint works and its purpose.

Screenshot: Include a screenshot of the successful addition of the constraint.

H$.$ Create a Sequence for the Students Table $-[5$ Points$]$

Query: Provide the SQL query to create a sequence for the Student$\_$ID in the Students table.

Explanation: Explain the purpose of the sequence and how it will be used.

Screenshot: Include a screenshot of the successful creation of the sequence.

Q$2$: Data Insertion and Foreign Key Accuracy $-[20$ Points$]$

Task: Insert records into tables while ensuring the correct Foreign Key relationships and data accuracy.

A$.$ Insert $3$ Records into Students Table Using Sequence for Student$\_$ID $-[5$ Points$]$

Query: Provide the SQL query to insert $3$ records.

Explanation: Explain how the sequence is used in the insert statement and why it ensures unique IDs.

Screenshot: Include a screenshot of the successfully inserted records.

B$.$ Insert $3$ Records into Class$\_$Instructor Table $-[5$ Points$]$

Query: Provide the SQL query to insert $3$ records.

Explanation: Explain the data being inserted and its relation to the other tables.

Screenshot: Include a screenshot of the successfully inserted records.

C$.$ Insert $5$ Records into Class Table $-[5$ Points$]$

Query: Provide the SQL query to insert $5$ records.

Explanation: Explain the data being inserted and its relevance to the course registration process.

Screenshot: Include a screenshot of the successfully inserted records.

D$.$ Insert $5$ Records into Registrater$\_$Class Table $-[5$ Points$]$

Query: Provide the SQL query to insert $5$ records.

Explanation: Explain how the foreign keys in this table relate to the other tables and ensure data integrity.

Screenshot: Include a screenshot of the successfully inserted records.

Q$3$: Data Retrieval and Manipulation Queries $-[25$ Points$]$

Task: Write and execute SQL queries to retrieve, update, and manipulate data in the created tables.

A$.$ Show All Records from Students Table $-[2$ Points$]$

Query: Provide the SQL query to retrieve all records from the Students table.

Explanation: Describe what the query does and how it retrieves data.

Screenshot: Include a screenshot of the output.

B$.$ Show Total Student Count from Students Table $-[2$ P