LETTER GRADE( PI) VARCHARI2) NOT NULL GRADE POINT MAX_GRADE MN_GRADE CREATED_BY CREATED DATE MODIFED_BY MODIFIED_DATE GRADE TY PE CODE(PK) CHAR(2) DES CRIPTION CREATED_BY CRBATED_DATE MODFIED_BY MODFIED DATE NOT NULL VARCHARZ(50) NOT NULL VARCHARIO0) NOT NULL DATE VARCHARZ30) NOT NULL DATE NUMBER(3,2) NOT NULL NOT NULL NOT NULL NUMBER(3,0) NUMBER3,0) VARCHAR30) NOT NULL DATE VARCHAROO0) NOT NULL DATE NOT NULL NOT NULL NOT NULL NOT NULL GRTW_GRTYP_FK GRADE STUDENT_ID(PKXF1Q SECTION_ID (PKX FK) GRADE CODE OCCURRENCE(PI) NUMBERO8.0) NUMERC_ORADE COMMMENTS CREATED_BY CREATED DATE MODFIED_BY MODFIED DATE GRADE TYFE_CODE (PK)(FK) GRADE_TYPE WEIGHT SECT ON_ID(PKXFK) NOT NULL NOT NULL NOT NULL GR GRTW FK GRADE TYPE CODE(PKO(FK) CHARQ) NOT NULL NUMBERS.0) NUMBERS,0) NEMBERO 0) NOT NULL NOT NULL NUMBER PER SECTON PERCENT OF_FINAL_GRADE NUMBER30) NOT NULL DROP LOWEST CREATED_BY CREATED DATE MODIFIED_BY MODIFIED_DATE NLMBERS 0) NOT NULL NUMBER3.0) VARCHARZ(2000) VARCHARZ(30) NOT NULL DATE NULL NOT NULL CHARI) VARCHARZ(30) NOT NULL DATE NOT NULL NOT NULL VARCHAR(30) NOT NULL VARCHARI(30) NOT NULL DATE DATE NOT NULL NOT NULL CHARZ) NỘT NULL GRTW_SECT_FK GR_BIR_FK SECTION ENROLLMENT STUDENT ID (PIOCFK) NUMBER(80) SECTION D (PIO(FK) NUMBERS0) BROLL_DATE SECTION_D (PK) COURSE NO (FI) SECTION_NO START DATE TME DATE LOCATION INSTRUCTOR D(FI) NUMBERS,0) NOT NULL CAPACTY CREATED BY CREATED_DATE MODFIED_BY MODFED DATE NLMBERO,0) NUMBER,0) NOT NULL NUMBERO,0) NOT NULL NOT NULL NOT NULL NOT NULL DATE NMBERIA) VARCHARI30) NOT NULL DATE NOT NULL NULL FINAL_GRADE CREATED_BY CREATED DATE MODFIED BY MODFIED DATE NULL ENR SECT_FK VARCHARZ(50) NULL NOT NULL NLMBERO.0) VARCHARZ(30) NOT NULL NULL VARCHARIGD) NOT NULL DATE NOT NULL DATE NOT NULL VARCHAR(30) NOT NULL DATE NOT NULL SECT CRSE_FK 一 SECT_NST_FK COURSE COURSE NO (PK) MMBERSD) DESCRIPTION NOT NULL INSTRUCTOR VARCHARO(S0) NOT NULL NULL NULL NSTRUCTOR ID(PK) NUMBERSD) VARCHARI(S) VARCHARR25) VARCHARR(25) STREET ADORES S VARCHARZ(50) VARCHARI(5) VARCHARI(15) NOT NULL NULL coST NMB ER92) PREFEDUISTE(FIO NMBERSD) CREATED_BY CREATED DATE MODFED_BY MODFED DATE SALUT ATION FRST NAME LAST NAME NULL ENR_STU FK VARCHAR30) NOT NULL NOT MULL NULL DATE VARCHARO(30) NOT NULL DATE NULL NOT NULL ZP (FK) NULL PHONE NULL CREAT ED_BY CREAT ED_DATE VARCHARZ(30) NOT NULL NOT NULL CRSE CRSE FK DATE

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
icon
Related questions
Question

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


(a) From which two fields in which table can you calculate the enrollment of a section?
(b) From which table can you get both course and section numbers?
(c) Which field in table SECTION uniquely identifies a section, section id or section no?
(d) Write a SQL statement to show sections and their enrollment.
(e) Write a SQL statement to show sections with enrollment greater than five. Display both course and
section numbers

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

Blurred answer
Knowledge Booster
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