Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade

List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade type code, and the numeric grade.

tables in the database:

Name Null Type

----------------- -------- ------------STUDENT TABLE

STUDENT_ID NOT NULL NUMBER(8)

SALUTATION VARCHAR2(5)

FIRST_NAME VARCHAR2(25)

LAST_NAME NOT NULL VARCHAR2(25)

STREET_ADDRESS VARCHAR2(50)

ZIP NOT NULL VARCHAR2(5)

PHONE VARCHAR2(15)

EMPLOYER VARCHAR2(50)

REGISTRATION_DATE NOT NULL DATE

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE

Name Null Type

------------- -------- ------------ENROLLMENT TABLE

STUDENT_ID NOT NULL NUMBER(8)

SECTION_ID NOT NULL NUMBER(8)

ENROLL_DATE NOT NULL DATE

FINAL_GRADE NUMBER(3)

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE

Name Null Type

--------------- -------- ------------SECTION TABLE

SECTION_ID NOT NULL NUMBER(8)

COURSE_NO NOT NULL NUMBER(8)

SECTION_NO NOT NULL NUMBER(3)

START_DATE_TIME DATE

LOCATION VARCHAR2(50)

INSTRUCTOR_ID NOT NULL NUMBER(8)

CAPACITY NUMBER(3)

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE

Name Null Type

------------- -------- ------------COURSE TABLE

COURSE_NO NOT NULL NUMBER(8)

DESCRIPTION NOT NULL VARCHAR2(50)

COST NUMBER(9,2)

PREREQUISITE NUMBER(8)

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE

--------------------- -------- --------------GRADE TABLE

STUDENT_ID NOT NULL NUMBER(8)

SECTION_ID NOT NULL NUMBER(8)

GRADE_TYPE_CODE NOT NULL CHAR(2)

GRADE_CODE_OCCURRENCE NOT NULL NUMBER(38)

NUMERIC_GRADE NOT NULL NUMBER(3)

COMMENTS VARCHAR2(2000)

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions