- 1 Write A Statement That Displays Student Id The First And Last Name And Enrollment Date And Time Of Enrollment Of The 1 (85.48 KiB) Viewed 42 times
Unix Tips and Techniques Unix Tips and Techniques 6 rows selected. ***** COURSE NO DESCRIPTION 3. Select the course number, course description and total course capacity for each course. Show only those courses with a total course capacity less than the average capacity of all sections. Arrange the list by course description and then total course capacity **** 144 Database Design 10 Technology Concepts STUDENT_ID FIRST_NAME ***** FIRST_NAME 4. Choose the most ambitious students by showing the student ID, first name and last name and the number of sections taken for those students enrolled in the most sections. Arrange the list by student last name then first name Jeffrey 1095 1095 LAST_NAME Citron LAST_NAME 07024 15 15 124 Daniel Wicelinski 214 Yvonne Williams 4 5. Show the names of the students who live in the zip code which has the most students enrolled. Arrange the list alphabetically by last name then first name ZIP 24 113 115 TOTAL_CAPACITY 15 15 4 MOST SECTIONS
Jeffrey Julius Roy Angel Hedy Donna 7 rows selected. Delbrun Kwong Limate Moskowitz Naso Walston **** COURSE_DESCRIPTION Advanced Java Programming Advanced Unix Admin Basics of Unix Admin DB Programming with Java 6. Display the course description, the course number and grade type description of courses that use a Midterm. Order by course description. List each course only once Database Design Database System Principles GUI Design Lab Hands-On Windows Intermediate Java Programming Internet Protocols Intro to Information Systems Intro to Java Programming Intro to Programming Intro to SQL Intro to Unix Intro to the BASIC Language Intro to the Internet 07024 07024 07024 Java Developer I Java Developer II Java for C/C++ Programmers Network Administration Operating Systems 07024 07024 07024 COURSE_NO GRADE_TYPE_DESCRIPTION 124 Midterm 134 Midterm 132 Midterm 450 Midterm 144 Midterm 420 Midterm 147 Midterm 100 Midterm 122 Midterm 145 Midterm 20 Midterm 120 Midterm 25 Midterm 204 Midterm 130 Midterm 240 Midterm 230 Midterm 125 Midterm 350 Midterm 146 Midterm 330 Midterm 310 Midterm
Oracle Tools PL/SQL Programming Project Management Systems Analysis Technology Concepts Unix Tips and Techniques 28 rows selected. ***** FIRST_NAME Jerry Abdou Carlos Airall Maria Allende Yvonne Allende John Ancean Craig Anglin Sarah Annina Oscar Archer 7. Show the first and last names of students who are not enrolled in any class. Arrange the list by last name then first name ************* John Velie Artie Ward Vera Wetcel Yvonne Winnicki Reeva Yeroushalmi Mei-Wah Zopf 103 rows selected 210 Midterm LAST_NAME 220 Midterm 142 Midterm 140 Midterm 10 Midterm 135 Midterm 8. Determine the first and last name, course description, section ID and numeric grade of the students who had the lowest Quiz (QZ) grade from all courses. Arrange the list by last name, first name and then course description
***** FIRST_NAME SECTION_ID NUMERIC_GRADE Jeffrey Janet J. Paul Jeff 5 rows selected. ***** ENROLLED CAPACITY 12 12 Delbrun Jung Landry Lefkowitz Runyan ******** LAST_NAME DESCRIPTION CAPACITY 12 10 Systems Analysis Intro to Java Programming Intro to Information Systems Java Developer II Technology Concepts SECTION_ID Intro to the BASIC Language 15 Intro to the Internet 15 COURSE_DESCRIPTION 99 101 9. Select the sections that are full by comparing section capacity to the number of students enrolled in the section. A section is full it the number of students enrolled meets or exceeds the capacity. Show the number of students enrolled, the capacity of the section and the section ID. Order by capacity in descending order then section ID COURSE_NO 230 240 L214 117 L214 147 LOCATION 81 10. Show the description, course number, location and capacity of the cheapest courses. Arrange the list by location, description then capacity 106 80 73 73 73 73 73
Unix Tips and Techniques 15 Intro to the Internet 12 Intro to the BASIC Language 10 Unix Tips and Techniques 25 Unix Tips and Techniques 25 Unix Tips and Techniques 15 8 rows selected 230 135 240 135 135 135 L214 L500 L509 L509 L509 M200
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