Overview This homework assignment is about applying DML statements and database
ID: 3911785 • Letter: O
Question
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
Explanation / Answer
If you have any doubts, please give me comment...
INSERT INTO Course VALUES('MGMT498', 'Big Data Analytics');
INSERT INTO Class VALUES('MGMT498', '01','5:00-7:30', 'T', 'Lee');
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.