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;