Overview

This homework assignment is about applying DML statements and database logic in order to manage your data. You are given three two tables with sample data, you are to write the required SQL statements to complete each task. You must consider entity integrity and referential integrity when writing your queries.

Tables and Data

Below are two tables used to solve the problems below. The Course table contains the courseID and courseName attributes for each class offered. There are currently three records in this table. The Class table contains the sections of each course that are offered. The courseID serves as a foreign key in the class table creating the 1:M relationship. The courseID and sectionID together is a composite primary key for the Class table. There would be other tables in the database but for this assignment we will focus only on these two table. All attributes in both tables consist of string data types.

Task 1 - INSERT

The university hired a new professor to teach a new class. The name of the class is MGMT498 and is called Big Data Analytics. Professor Lee will be teaching one section of this course on Tuesdays from 5:00 until 7:30 PM. Your task is to write the SQL script(s) that will insert this data into the database.

Overview

This homework assignment is about applying DML statements and database logic in order to manage your data. You are given three two tables with sample data, you are to write the required SQL statements to complete each task. You must consider entity integrity and referential integrity when writing your queries.

Tables and Data

Below are two tables used to solve the problems below. The Course table contains the courseID and courseName attributes for each class offered. There are currently three records in this table. The Class table contains the sections of each course that are offered. The courseID serves as a foreign key in the class table creating the 1:M relationship. The courseID and sectionID together is a composite primary key for the Class table. There would be other tables in the database but for this assignment we will focus only on these two table. All attributes in both tables consist of string data types.

Task 1 - INSERT

The university hired a new professor to teach a new class. The name of the class is MGMT498 and is called Big Data Analytics. Professor Lee will be teaching one section of this course on Tuesdays from 5:00 until 7:30 PM. Your task is to write the SQL script(s) that will insert this data into the database.

Course courseID (PK) MGMT329 MGMT330 MGMT450 courseName Database Management Business Programming Computer Based Information Systems Class courseID (PK, FK) sectionID (PK) classTime classDays Instructor MGMT329 MGMT329 MGMT330 MGMT450 MGMT450 01 02 01 01 02 11:00-12:15 T,R 11:00-12:15M,W 9:00-11:45 F 12:30-1:45 T,FR 12:30-1:45 M,W French Bose Flor French Bose