Can someone help me with these commands? Thank you! Tables and Data Below are tw
ID: 3811523 • Letter: C
Question
Can someone help me with these commands? Thank you!
Tables and Data Below are two tables used to answer the questions that follow. The Course table contains the courseD and courseMame 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 courselD serves as a foreign key in the class table creating the 1:M relationship. The courselD and section ID 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 eID GK course Name Course Database Management MGMT 329 IM GMT330 Business Programming MGMT 450 Computer Based Information Systems Class course ID (PK, FKO sectionID (PK classTime LclassDays LInstructor 11.00-12.15 TR IM GMT329 French 01 MGMT 329 022 11:00-12:15 M, W Bose MGMT 3300 01 9:00-11:45 F Flor French MGMT4500 01 12:30-1:45 TR 12:30-1:45 MMW MGMT 450 02 BoseExplanation / Answer
Task 1
insert into Course values('MGMT498' , 'Big Data Analytics');
insert into Class values'MGMT498' , 03 , '5:00-7:30' , 'T' , 'LeeVirginia');
Task 2
update Class set Instructor = 'Lee' where courseID = 'MGMT330';
Task 3
delete from Course where courseID = 'MGMT450';