Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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

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
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 


(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

SEE SOLUTIONCheck out a sample Q&A here
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
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