Assignment 3
Assignment 3
Assignment 3
1
SQL Command to create REGISTRATION relation:
SQL commands to insert the four records into the Course relation
(Hint: write four INSERT INTO statements to insert the four records):
ii. Retrieve all values from the CourseID attribute in the COURSE relation
SELECT CourseID
FROM Course_T;
SELECT CourseID
FROM Course_T
WHERE CourseID = “ISM4930”;