SQL Statement Course courseID (PK) courseName MGMT329 Database Management MGMT33
ID: 3566844 • Letter: S
Question
SQL Statement
Course
courseID (PK)
courseName
MGMT329
Database Management
MGMT330
Business Programming
MGMT450
Computer Based Information Systems
1:M Relationship (1 Course to Many Classes)
Class
courseID (PK, FK)
sectionID (PK)
classTime
classDays
Instructor
MGMT329
01
11:00-12:15
T,R
French
MGMT329
02
11:00-12:15
M,W
Bose
MGMT330
01
9:00-11:45
F
Flor
MGMT450
01
12:30-1:45
T,R
French
MGMT450
02
12:30-1:45
M,W
Bose
Task 1: INSERT
CNM hired a new professor to teach a new class. The name of the class is MGMT498 and is called
courseID (PK)
courseName
MGMT329
Database Management
MGMT330
Business Programming
MGMT450
Computer Based Information Systems
Explanation / Answer
TASK 1:-
INSERT INTO Course('MGMT498','BigDataAnalytics');INSERT INTO class('MGMT498',01,'5:00-7:30 PM','T','Lee')
TASK 2:-
UPDATE class
SET Instructor='Lee'
WHERE Instructor='Flor' and CourseId='MGMT430'
TASK-3:-
DELETE FROM class
WHERE courseId='MGMT450';
DELETE FROM Course
WHERE courseId='MGMT450'
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.