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.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers
Section: Chapter Questions
Problem 8EYW
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
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS