Q1 Create the following tables and insert some values.

STUDENT (STDNO, SNAME, DEPTNO#) DEP (DEPTNO, DNAME) COURSE (CORSNO, CNAME, DEPTNO#, CMAX) ENROLMENT (STDNO#, CORSNO#, GRADE, EDATE)

Query a single table: 1) Display the whole content of the DEP table 2) Display all columns of the CP department 3) Display the whole content of the STUDENT table 4) Display STDNO and SNAME for students in department CP 7) Display all columns for departments when the Dname starts with letter M or C. 8) Display all columns for courses sorting the result by the CMAX descending.