Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
THIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS IN THIS ASSIGNMENT.

THIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS IN THIS ASSIGNMENT.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

THIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS IN THIS
ASSIGNMENT.

 

GRADE CONVERSION LETTER GRADE(PK) VARCHAR(2) NOT NULL GRADE POINT MAX_ORADE MN_GRADE CREATED_BY CREATED DATE MODFED_BY MODIFIED_DATE GRADE TYPE GRADE TYPE CODE(PK) CHARC2) NOT NULL NLMBER(3,2) NUMBER3,0) VARCHARZ(50) NOT NULL VARCHARIG0) NOT NULL DATE NOT NULL DES CRIPTION CREATED_BY CREATED DATE MODFIED_BY MODFIED DATE NOT NULL NUMBER3,0) VARCHARZ30) NOT NULL DATE NOT NULL NOT NULL VARCHARRO0) NOT NULL DATE NOT NULL NOT NULL VARCHARO0) NOT NULL DATE NOT NULL GRTW GRTYP_FK GRADE STUDENT ID(PKXFIO SECTION_ID (PK(FK) GRADE CODE OCCURRENCE (PK) NUMBERO8.0) NUMERC_GRADE COMMENTS CREATED_BY CREATED DATE MODIFIED_BY MODFIED DATE GRADE TYFE_CODE (PK)(FK) NUMBERS.0) NUMBERS.0) GRADE TYPE WEIGHT SECTON_ID(PKXFK) NOT NULL NEMBERO,0) NOT NULL NOT NULL NOT NULL GR GRTW FK GRADE TYPE CODE(PKO(FK) CHARQ) NOT NULL NULL NOT NULL NOT NULL NOT NULL NUMBER PER SECTION PERCENT_OF_FINAL_GRADE NUMBER30) NOT NULL DROP LOWEST CREATED_BY CREATED DATE MODIFIED_BY MODIFIED DATE NLMBERO.0) NOT NULL NUMBER3.0) VARCHAR(2000) VARCHAR(30) DATE CHARI) VARCHARC30) NOT NULL DATE NOT NULL NOT NULL VARCHAR(30) NOT NULL NOT NULL NOT NULL VARCHARI(30) NOT NULL DATE DATE NOT NULL CHARZ) GRTW_SECT_FK GR_BIR_FK SECTION ENROLLMENT STUDENT ID (PKOXFK) NBER(S0) SECTION_D (PKO(FK) NUMBERSA) BNROLL_DATE FINAL_GRADE CREATED_BY CREATED DATE MODFIED BY MODFIED DATE SECTION_D (PK) COURSE NO (FK) NUMBERB,0) NOT NULL SECTION_NO START DATE TME DATE LOCATION INSTRUCTOR D(FIO NUMBERS,0) CAPACTY CREATED_BY CREATED_DATE MODFED_BY MODFED DATE NLMBERO,0) NOT NULL NOT NULL NOT NULL DATE NOT NULL NUMBERO,0) NOT NULL NULL NMBERIA) VARCHARI(30) NOT NULL DATE NULL ENR SECT FK VARCHAR(50) NULL NOT NULL NOT NULL NLMBERO.0) VARCHARZ(30) NDT NULL DATE NULL VARCHARIGD) NOT NULL DATE NOT NULL NOT NULL VARCHARZ(30) NOT NULL DATE NOT NULL SET CRSE FK SECT_NST FK COURSE COURSE NO (PK) NMBERS0) DESCRIFTION NOT NULL VARCHARO(S0) NOT NULL NULL INSTRUCTOR NSTRUCTOR_ID(PK) NUMBERCOD) VARCHARI(S) VARCHARI25) VARCHAR(25) STREET ADDRESss VARCHARZ(50) VARCHARZ(5) VARCHARI(15) NOT NULL NULL NULL COST NMBERO2) SALUTATION PREFEDUISTE(FIO MMBERSD) CREATED_BY CREATED DATE DATE MODFED_BY MODFED DATE DATE NULL FRST NAME VARCHAR(00) NOT NULL NOT NULL VARCHAROG0) NOT NULL NOT MULL ENR_STU FK LAST_NAME NULL NULL NULL PHONE NULL CREAT ED_BY CREAT ED_DATE MODIFIED_BY MODIFIED DATE VARCHARIO0) NOT NULL DATE CRSE CRSE FK NOT NULL VARCHAR2(30) NOT NULL STUDENT DATE NOT NULL STUDENT ID (PK) N.MBER8D) VARCHARZ5) VARCHARI26) VARCHARI25) NOT NULL NOT NULL NULL NST ZIP_FK SALUTATION NULL FIRST NAME LAST NAME STREET ADDRES S VARCHARI50) ZIP(FK) NULL APCODE ZP (PK) CITY STATE CREATED_BY VARCHAR(30) NOT NULL CREATED DATE DATE MODIFIED_BY VARCHARI(30) NOT NULL MODIFIED DATE DATE VARCHARZ5) NOT NULL VARCHARZ(15) VARCHARZ(50) VARCHARI(5) NOT NULL VARCHARI(25) VARCHARI(2) PHONE NULL NULL NULL BAFLOYER REDISTRAT ON_DATE DATE CRSATED_BY CREATED DATE MODFIED_BY MODFIED DATE NULL STU ZIP_FK NOT NULL VARCHARIG0) NOT NULL NOT NULL VARCHAR2(30) NOT NULL NOT NULL DATE NOT NULL DATE NOT NULL
Transcribed Image Text:GRADE CONVERSION LETTER GRADE(PK) VARCHAR(2) NOT NULL GRADE POINT MAX_ORADE MN_GRADE CREATED_BY CREATED DATE MODFED_BY MODIFIED_DATE GRADE TYPE GRADE TYPE CODE(PK) CHARC2) NOT NULL NLMBER(3,2) NUMBER3,0) VARCHARZ(50) NOT NULL VARCHARIG0) NOT NULL DATE NOT NULL DES CRIPTION CREATED_BY CREATED DATE MODFIED_BY MODFIED DATE NOT NULL NUMBER3,0) VARCHARZ30) NOT NULL DATE NOT NULL NOT NULL VARCHARRO0) NOT NULL DATE NOT NULL NOT NULL VARCHARO0) NOT NULL DATE NOT NULL GRTW GRTYP_FK GRADE STUDENT ID(PKXFIO SECTION_ID (PK(FK) GRADE CODE OCCURRENCE (PK) NUMBERO8.0) NUMERC_GRADE COMMENTS CREATED_BY CREATED DATE MODIFIED_BY MODFIED DATE GRADE TYFE_CODE (PK)(FK) NUMBERS.0) NUMBERS.0) GRADE TYPE WEIGHT SECTON_ID(PKXFK) NOT NULL NEMBERO,0) NOT NULL NOT NULL NOT NULL GR GRTW FK GRADE TYPE CODE(PKO(FK) CHARQ) NOT NULL NULL NOT NULL NOT NULL NOT NULL NUMBER PER SECTION PERCENT_OF_FINAL_GRADE NUMBER30) NOT NULL DROP LOWEST CREATED_BY CREATED DATE MODIFIED_BY MODIFIED DATE NLMBERO.0) NOT NULL NUMBER3.0) VARCHAR(2000) VARCHAR(30) DATE CHARI) VARCHARC30) NOT NULL DATE NOT NULL NOT NULL VARCHAR(30) NOT NULL NOT NULL NOT NULL VARCHARI(30) NOT NULL DATE DATE NOT NULL CHARZ) GRTW_SECT_FK GR_BIR_FK SECTION ENROLLMENT STUDENT ID (PKOXFK) NBER(S0) SECTION_D (PKO(FK) NUMBERSA) BNROLL_DATE FINAL_GRADE CREATED_BY CREATED DATE MODFIED BY MODFIED DATE SECTION_D (PK) COURSE NO (FK) NUMBERB,0) NOT NULL SECTION_NO START DATE TME DATE LOCATION INSTRUCTOR D(FIO NUMBERS,0) CAPACTY CREATED_BY CREATED_DATE MODFED_BY MODFED DATE NLMBERO,0) NOT NULL NOT NULL NOT NULL DATE NOT NULL NUMBERO,0) NOT NULL NULL NMBERIA) VARCHARI(30) NOT NULL DATE NULL ENR SECT FK VARCHAR(50) NULL NOT NULL NOT NULL NLMBERO.0) VARCHARZ(30) NDT NULL DATE NULL VARCHARIGD) NOT NULL DATE NOT NULL NOT NULL VARCHARZ(30) NOT NULL DATE NOT NULL SET CRSE FK SECT_NST FK COURSE COURSE NO (PK) NMBERS0) DESCRIFTION NOT NULL VARCHARO(S0) NOT NULL NULL INSTRUCTOR NSTRUCTOR_ID(PK) NUMBERCOD) VARCHARI(S) VARCHARI25) VARCHAR(25) STREET ADDRESss VARCHARZ(50) VARCHARZ(5) VARCHARI(15) NOT NULL NULL NULL COST NMBERO2) SALUTATION PREFEDUISTE(FIO MMBERSD) CREATED_BY CREATED DATE DATE MODFED_BY MODFED DATE DATE NULL FRST NAME VARCHAR(00) NOT NULL NOT NULL VARCHAROG0) NOT NULL NOT MULL ENR_STU FK LAST_NAME NULL NULL NULL PHONE NULL CREAT ED_BY CREAT ED_DATE MODIFIED_BY MODIFIED DATE VARCHARIO0) NOT NULL DATE CRSE CRSE FK NOT NULL VARCHAR2(30) NOT NULL STUDENT DATE NOT NULL STUDENT ID (PK) N.MBER8D) VARCHARZ5) VARCHARI26) VARCHARI25) NOT NULL NOT NULL NULL NST ZIP_FK SALUTATION NULL FIRST NAME LAST NAME STREET ADDRES S VARCHARI50) ZIP(FK) NULL APCODE ZP (PK) CITY STATE CREATED_BY VARCHAR(30) NOT NULL CREATED DATE DATE MODIFIED_BY VARCHARI(30) NOT NULL MODIFIED DATE DATE VARCHARZ5) NOT NULL VARCHARZ(15) VARCHARZ(50) VARCHARI(5) NOT NULL VARCHARI(25) VARCHARI(2) PHONE NULL NULL NULL BAFLOYER REDISTRAT ON_DATE DATE CRSATED_BY CREATED DATE MODFIED_BY MODFIED DATE NULL STU ZIP_FK NOT NULL VARCHARIG0) NOT NULL NOT NULL VARCHAR2(30) NOT NULL NOT NULL DATE NOT NULL DATE NOT NULL
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS