Answer Happy

7. List the course number and course description of the courses with the lowest number of enrolled students. Arrange the list on course description. ****** COURSE NO DESCRIPTION 450 DB Programming with Java 204 Intro to SQL 10 Technology Concepts
APPENDIX D STUDENT DATABASE GRADE_CONVERSION LETTER GRADE (PK) VARCHAR2(2) NOT NULL GRADE POINT NUMBER(3,2) NOT NULL MAX_GRADE MIN GRADE CREATED BY CREATED_DATE MODIFIED BY MODIFIED_DATE GRADE STUDENT ID (PK) (FK) SECTION_ID (PK)(FK) CREATED BY CREATED DATE MODIFIED BY MODIFIED_DATE GRADE_TYPE_CODE (PK) (FK) GRADE CODE OCCURRENCE (PK) NUMERIC GRADE COMMENTS CREATED BY CREATED DATE MODIFIED BY MODIFIED_DATE STUDENT ENR STU FK SALUTATION FIRST NAME LAST NAME ZIP (FK) PHONE ENROLLMENT STUDENT D (PK) (FK) NUMBER(8,0) SECTION_ID (PKK(FK) NUMBER(8,0) ENROLL DATE FINAL GRADE NUMBER(3,0) NOT NULL NUMBER(3.0) NOT NULL VARCHAR2(30) NOT NULL NOT NULL NOT NULL NOT NULL DATE EMPLOYER VARCHAR2(30) DATE CREATED BY SCHEMA NUMBER(8,0) NUMBER(8,0) CHAR(2) NUMBER(38,0) NUMBER(3,0) REGISTRATION DATE DATE DATE VARCHAR2(2000) VARCHAR2(30) NOT NULL NOT NULL VARCHAR2(30) DATE CREATED DATE DATE MODIFIED BY MODIFIED DATE GR_ENR FK NOT NULL NULL DATE NUMBER(3,0) VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL NOT NULL DATE VARCHAR2(5) NOT NULL NOT NULL CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE VARCHAR2(15) VARCHAR2(50) NOT NULL NOT NULL NULL COURSE COURSE NO (PK) NUMBER(8,0) NOT NULL DESCRIPTION VARCHAR2(50) NOT NULL COST NUMBER(9,2) NULL PREREQUISITE (FK) NUMBER(8,0) NOT NULL NOT NULL NOT NULL GR GRTW FK NUMBER PER SECTION NOT NULL NOT NULL SECT_CRSE FK GRADE_TYPE GRADE TYPE CODE (PK) CHAR(2) DESCRIPTION CREATED BY CREATED_DATE NULL VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL MODIFIED BY MODIFIED DATE ORSE_CRSE_FK - ENR SECT FK GRADE_TYPE_WEIGHT SECTION_ID (PK)(FK) GRADE_TYPE_CODE (PK)(FK) CHAR(2) STUDENT D (PK) NUMBER(8,0) NOT NULL NULL VARCHAR2(25) NULL VARCHAR2(25) NOT NULL 11-19 STREET_ADDRESS VARCHAR2(50) NULL VARCHAR2(5) NOT NULL NULL NULL STU_ZP FK NOT NULL VARCHAR2(30) NOT NULL NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL GRTW_SECT_FK SECTION SECTION ID (PK) COURSE NO (FK) SECTION NO START DATE TIME LOCATION NUMBER(3,0) PERCENT_OF_FINAL_GRADE NUMBER(3,0) DROP LOWEST CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE FIRST NAME LAST NAME STREET ADDRESS ZP (FK) PHONE CREATED BY CREATED_DATE MODIFIED BY MODIFIED_DATE NOT NULL VARCHAR2(50) NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL NOT NULL NOT NULL NUMBER(8,0) NUMBER(8,0) NUMBER(3,0) NOT NULL NULL DATE NULL VARCHAR2(50) NOT NULL INSTRUCTOR_ID (FK) NUMBER(8,0) CAPACITY CREATED BY CREATED DATE MODIFIED BY MODIFIED_DATE NULL NUMBER(3,0) VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL ZIPCODE GRTW_GRTYP_FK NUMBER(8,0) NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL CHAR(1) VARCHAR2(30) NOT NULL NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL ZIP (PK) INSTRUCTOR SALUTATION NULL INSTRUCTOR_ID (PK) NUMBER(8,0) NOT NULL NULL VARCHAR2(5) VARCHAR2(25) NULL VARCHAR2(25) NULL VARCHAR2(50) VARCHAR2(5) VARCHAR2(15) NULL VARCHAR2(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL NULL NOT NULL CITY STATE DATE DATE VARCHAR2(5) NOT NULL VARCHAR2(25) NULL NULL CREATED BY VARCHAR2(30) NOT NULL SECT INST FK CREATED DATE DATE INST ZIP FK VARCHAR2(2) MODIFIED_DATE DATE NOT NULL MODIFIED BY VARCHAR2(30) NOT NULL NOT NULL