Question: Lab Exercise Create the following tables and insert some values. STUDENT (STDNO, SNAME, DEPTNO#) DEP (DEPTNO, DNAME) COURSE (CORSNO, CNAME, DEPTNO#, CMAX) ENROLMENT (STDNO#, CORSNO#,

Lab Exercise 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
