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


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. Submit your homework in a Microsoft Word document to UNM Learn. Tables and Data Below are two tables used to solve the problems below. The Course table contains the courselD 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 courselD and sectionlD 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 Course IcourseName courseID (PK)-- MGMT329 MGMT330 MGMT450 Database Management Business Programming puter Based Information Systems Class Instructor French PK MGMT329 MGMT329 MGMT330 MGMT450 MGMT450 11:00-12:15 TR 11:00-12:15 | ?.w 9:00-11:45 F 12:30-1:45 TR 12:30-1:45 M. W 02 Flor French Bose
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
