Assignment title: Information
Question1:
Display all information about all courses
Query:
Select * from course;
Output:
Question2:
Add a new course "Relational Database Systems" with course number 651. Use your user name
as created_by/modified_by and current date as created_date/modified_date
Query:
INSERT INTO course (COURSE_NO, DESCRIPTION, CREATED_BY, CREATED_DATE,
MODIFIED_BY, MODIFIED_DATE) VALUES (651,'Relational Database Systems',
'username', SYSDATE, 'username', SYSDATE);
Output:
Question3:
List the course number for "Database System Principles"
Query:
SELECT COURSE_NO FROM course WHERE DESCRIPTION LIKE '%Database System
Principles%';
Output:
Question4:
Set "Database System Principles" as the prerequisite for "Relational Database Systems"
Query:
UPDATE course SET PREREQUISITE=(SELECT COURSE_NO FROM course WHERE
DESCRIPTION LIKE '%Database System Principles%') WHERE DESCRIPTION LIKE
'%Relational Database Systems%';
Output:
Question5:
List all courses that have "Database System Principles" as prerequisite
Query:
Select * from course where PREREQUISITE = (SELECT COURSE_NO FROM course
WHERE DESCRIPTION LIKE '%Database System Principles%');
Output:
Question6:
List total number of courses that have no prerequisite
Query:
Select count (*) from course where PREREQUISITE IS NULL;
Output:
Question7:
Delete course "Relational Database Systems"
Query:
delete from course where DESCRIPTION LIKE '%Relational Database Systems%';
Output:
Question8:
Display total number of courses Lower cost of all courses by 1100
Query:
Select count (*) from course where COST < 1100;
Output:
Question9:
List all course cost (show course description and cost only) by the order of cost from highest to
lowest
Query:
select description, cost from course order by COST desc;