Using Oracle SQL created the commands used to achieve what is asked below.

List the full name (first and last name) and phone number for students that live in Newark, NJ.
Sort on last name and first name.

For all 300 level courses (300-399), list the course number, prerequisite course number and prerequisite course description. Sort by course number.

List the course number and description for all 100-level courses taught by Charles Lowry.
Arrange the list in order of course number.

List the grade type code, description and number per section (a column in the grade_type_weight table) of all grades in course 144. Arrange by description.

Provide an alphabetic list of students (student last name followed by first name) who have an overall grade average of 93 or higher. The name should be one column, last name first and sorted on last name then first name.

 

APPENDIX D STUDENT DATABASE GRADE CONVERSION LETTER GRADE (PO VARCHAR22) NOT NULL GRADE POINT NUMBER(3.35 NOT NULL NUMBER 3,0 NOTNILL NUMBER(3, NOT NULL VARCHAR230) NOT NULL CATE NOT NULL VARCHAR2(30) NOT NULL CATE NOT NULL MAX GRADE MN GRADE CREATED BY CREATED CATE MOOFED BY MOOFED DATE GRADE STUDENT DIPO(K) SECTION D IPKOPO GRADE TYPE CODE (PFK) CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE GRADE CODE OCCURRENCE (PC NUMBER(380) NUMERIC GRADE COMMENTS FINAL GRADE CREATED BY CREATED DATE MOOFED BY MOOFED DATE ENR STU FK STUDENT STUDENT D (RK) SALUTATION FIRST NAME LAST NAME ENROLLMENT STUDENT D (PKPK) NUMER) NOT NULL SECTION ID(PK)(FK) NUMBER(80) ENROLL DATE NOT NULL NOT NULL CATE MAR NULL VARCHAR2(3 NOT NULL DATE NOT NULL VARCHARX30 NOT NULL DATE NOT NULL STREET ADORESS ZP(FK) PHONE SCHEMA EMPLOYER REGISTRATION DATE DATE CREATED BY CREATED DATE NAK NUMBER CHAR(2) MODIFIED BY MOOFED DATE NUMBER (30) NOT NULL MAL VARCHAR2000 VARCHAR(30) NOT MALL DATE NOT NULL VARCHAR(30) NOT NULL NOT NAL DATE OR ENR FK NOT NALL NOT NULL NOT NULL NOT MALL NUMBER(80) NOT NULL VARCHAR NAL VARCHAR(2) MULL VARCHAR2(25) NOT NULL VAROHAR NALL VARCHAR(5) NOT NULL VARCHAR(15) NILL VARCHAR(50) NULL NOT NULL VAROHAR2(30) NOT NULL DATE NOT NULL VARCHAR(30) NOT NULL DATE NOT NULL ENR_SECT FK COURSE COURSE NO (PK) NUMBER(80) NOT NULL DESCRIPTION VARCHARE(50) NOT NULL NAL NULL VARCHAR(30) NOT NULL PATE NOT NAL VARCHAR2(30) NOT NULL DATE NOT NULL COST NUMBERS 21 PREREQUISITE (FK) NUMBER) CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE SECT_CRSE FK GRADE TYPE WEIGHT SECTION_D(P)(FK) GR GRTW FK NUMBER PER SECTION GRADE TYPE CODE (PFO CHAR GR GRTW FK NUMBER PER ORSE ORSE PK GRADE TYPE GRADE TYPE CODE (PO OHAR(2) STU ZP FK DESCRIPTION CREATED BY CREATED DATE MODIFIED BY MODIFIED CATE NOT NULL VARCHAR(50) NOT MAL VARCHAR(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL GRTW_GRTVP FK GRTW SECT FK NUMBER(8,0) NUMBER, NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL SECTION NUMBER(3,0) PERCENT OF FINAL GRADE NUMBER(3,0) DROP LOWEST CHAR(1 CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL LICOPED BY VARCHAR2(30) NOT NULL MODRED DATE DATE NOT NULL SECTION SECTION D(P) COURSE NO (FO SECTION NO START DATE TIME LOCATION INSTRUCTOR D (FK) NUMBER(8,0) CAPACITY NUMBER(30 MAL CREATED BY VARCHAR230) NOT NULL CREATED CATE DATE NOT NULL MOOFED BY VARCHAR230) NOT NULL MOOFED DATE CATE NOT NULL NUMBER NUMBER 8.0 NLA3 DATE VARCHAR250) NULL www NOT NULL NOT NULL NOT NULL NOT NULL MAL SECT_INST.FK INSTRUCTOR INSTRUCTOR D (PNAK80) NOT NULL SALUTATION VARCHARZ SI NULL FIRST NAME VARCHAR(25 NULL LAST NAME VARCHAR(25) NULL STREET ADDRESS VARCHAR2(50) NULL ZP (FK) VARCHARIS NILL PHONE VARCHAR(15) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED CATE DATE NOT NU NULL MOORED BY VARCHAR2(30) NOT NUL MOORED DATE DATE NOT MAL NST ZP K ZIPCODE 2P ( CITY STATE CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODIFIED BY VARCHAR2(30) NOT NULL MODIFIED DATE DATE NOT NULL VAROHARRIS NOT NELL MALL VARCHAR21251 VARCHAR212) NULL