-- QUERY 1: CREATE DATABASE UNIVERSITY_DATABASE2

-- QUERY 2: USE UNIVERSITY_DATABASE2

-- QUERY 3: CREATE TABLE TBLCOURSES ( COURSE_ID INT UNIQUE, COURSE_NAME VARCHAR(30) NOT NULL, COURSE_DUR INT CHECK (COURSE_DUR = 120 OR COURSE_DUR = 180) )

-- QUERY 4: INSERT INTO TBLCOURSES VALUES (101, 'COMPUTERS', 120) INSERT INTO TBLCOURSES VALUES (102, 'ROBOTICS', 180) INSERT INTO TBLCOURSES VALUES (103, 'CIVIL', 180)

-- QUERY 5: SELECT * FROM TBLCOURSES

-- QUERY 6: CREATE TABLE TBLSTUDENTS ( STD_ID INT PRIMARY KEY, STD_NAME VARCHAR(30) NOT NULL, STD_AGE INT CHECK (STD_AGE >= 18), STD_COURSE_ID INT REFERENCES TBLCOURSES(COURSE_ID) )

-- QUERY 7: INSERT INTO TBLSTUDENTS VALUES (1001, 'SAI', 34, 101) INSERT INTO TBLSTUDENTS VALUES (1002, 'JON', 34, 101) INSERT INTO TBLSTUDENTS VALUES (1003, 'JOHNE', 34, 102) INSERT INTO TBLSTUDENTS VALUES (1004, 'JOHNY', 34, 102) INSERT INTO TBLSTUDENTS VALUES (1005, 'JON 2', 34, 101) INSERT INTO TBLSTUDENTS VALUES (1006, 'JOHNY 2', 34, 102)

-- QUERY 8: SELECT * FROM TBLSTUDENTS

-- QUERY 9: HOW TO REPORT LIST OF COURSES AND RESPECTIVE (MATCHING) STUDENTS?

-- QUERY 10: HOW TO REPORT LIST OF COURSES WITH AND WITHOUT STUDENTS?

-- QUERY 11: HOW TO REPORT LIST OF COURSES WITH AND WITHOUT STUDENTS?

-- QUERY 12: HOW TO REPORT LIST OF COURSES WITH STUDENTS?

-- QUERY 13: HOW TO REPORT LIST OF COURSES WITHOUT STUDENTS?