In this assignment you are going to create multi-table join statements to query the tables that you created a previous assignment. You will use the SQL Workshop - SQL Scripts page to create a single script file to complete the assignment.

Transcribed Image Text:

DJs on Demand Table Design D_PLAY_LIST_ITEMS NUMBER (5) NUMBER (5) PF EVENT ID P SONO D COMMENTS VARCHAR2(0) DPLM_PK (EVENT ID, SONG_ID) DPLM_EVENT_O_FK (EVENT_ID) D_PLM_SONG_ID_FK (SONO_ID) 10 TITLE DURATION D SONGS ARTIST TYPE CODE D_SNG JD PK (0) D_SNG_TYPE_CODE_FK(TYPE_CODE) D_COS CD NUMBER NUMBER (5) TITLE *PRODUCER YEAR NUMBER (5) VARCHAR2 (50) VARCHAR2 (20) VARCHAR2 (20) NUMBER (10) D_TRACK LISTINGS PF SONG ID NUMBER (5) PF CD NUMBER NUMBER (5) TRACK NUMBER (2) D_TLG_PK (SONG JO. CD_NUMBER) D_TLG CD NUMBER FK (CD_NUMBER) D_TLG_SONG_ID_FK (SONG_ID) SONO_ID_IDX (SONG_ID) VARCHAR2 (50) VARCHAR2 (50) VARCHAR2(4) D_COS_CO_NUMBER_PK (CD_NUMBER) D_COS IDX (TITLE) D_TYPES D JOB ASSIGNMENTS NUMBER (5) NUMBER (5) DATE VARCHAR2 (50) D_JAT PK (PARTNER_ID, EVENT_ID) D_JAT_EVENT_ID_FK (EVENT_ID) DJAT_PARTNER_ID_FK (PARTNER_ID) PF PARTNER ID PF EVENT D JOB DATE STATUS CODE DESCRIPTION D_TPE_CODE_PK (CODE) NAME EVENT DATE DESCRIPTION D_EVENTS COST VENUE O *PACKAGE CODE *THEME CODE F CLIENT NUMBER DEVE_ID_PK (D) DEVE CLIENT NUMBER FK (CLIENT_NUMBER) D_EVE PACKAGE CODE FK (PACKAGE_CODE) DEVE THEME_CODE FK (THEME_CODE) DEVE_VENUE_ID_FK (VENUE_ID) NUMBER (10) VARCHAR2(50) NUMBER (5) VARCHAR2 (50) DATE VARCHAR2 (50) NUMBER (82) NUMBER (5) NUMBER (10) NUMBER (10) NUMBER (5) D_CLIENTS *CUENT NUMBER *FIRST NAME LAST NAME PHONE EMAIL NUMBER (5) VARCHAR2 (25) VARCHAR2(30) NUMBER (15) VARCHAR2(50) D_CLT_CLIENT_NUMBER_PK (CLIENT_NUMBER) D_PARTNERS 10 FIRST NAME LAST_NAME EXPERTISE SPECIALTY NUMBER (5) VARCHAR2 (25) VARCHAR2(30) VARCHAR2(25) VARCHAR2(25) AUTH EXPENSE AMT NUMBER (82) MANAGER JO NUMBER (5) PARTNER TYPE VARCHAR2(25) D_PTR_ID_PK (0) D.THEMES CODE NUMBER (10) DESCRIPTION VARCHAR2(100) D_TME_CODE_PK (CODE) D_PACKAGES CODE NUMBER (10) *LOW RANGE NUMBER (0) *HIGH_RANGE NUMBER (8) D_PKE_CODE_PK (CODE) D_VENUES NUMBER (5) VARCHAR2(30) VARCHAR2(100) *LOC_TYPE ADDRESS RENTAL FEE VARCHAR2 (50) COMMENTS VARCHAR2 (100) D_VNE JO_PK (10) DJs on Demand Table Design D_PLAY_LIST_ITEMS NUMBER (5) NUMBER (5) PF EVENT ID P SONO D COMMENTS VARCHAR2(0) DPLM_PK (EVENT ID, SONG_ID) DPLM_EVENT_O_FK (EVENT_ID) D_PLM_SONG_ID_FK (SONO_ID) 10 TITLE DURATION D SONGS ARTIST TYPE CODE D_SNG JD PK (0) D_SNG_TYPE_CODE_FK(TYPE_CODE) D_COS CD NUMBER NUMBER (5) TITLE *PRODUCER YEAR NUMBER (5) VARCHAR2 (50) VARCHAR2 (20) VARCHAR2 (20) NUMBER (10) D_TRACK LISTINGS PF SONG ID NUMBER (5) PF CD NUMBER NUMBER (5) TRACK NUMBER (2) D_TLG_PK (SONG JO. CD_NUMBER) D_TLG CD NUMBER FK (CD_NUMBER) D_TLG_SONG_ID_FK (SONG_ID) SONO_ID_IDX (SONG_ID) VARCHAR2 (50) VARCHAR2 (50) VARCHAR2(4) D_COS_CO_NUMBER_PK (CD_NUMBER) D_COS IDX (TITLE) D_TYPES D JOB ASSIGNMENTS NUMBER (5) NUMBER (5) DATE VARCHAR2 (50) D_JAT PK (PARTNER_ID, EVENT_ID) D_JAT_EVENT_ID_FK (EVENT_ID) DJAT_PARTNER_ID_FK (PARTNER_ID) PF PARTNER ID PF EVENT D JOB DATE STATUS CODE DESCRIPTION D_TPE_CODE_PK (CODE) NAME EVENT DATE DESCRIPTION D_EVENTS COST VENUE O *PACKAGE CODE *THEME CODE F CLIENT NUMBER DEVE_ID_PK (D) DEVE CLIENT NUMBER FK (CLIENT_NUMBER) D_EVE PACKAGE CODE FK (PACKAGE_CODE) DEVE THEME_CODE FK (THEME_CODE) DEVE_VENUE_ID_FK (VENUE_ID) NUMBER (10) VARCHAR2(50) NUMBER (5) VARCHAR2 (50) DATE VARCHAR2 (50) NUMBER (82) NUMBER (5) NUMBER (10) NUMBER (10) NUMBER (5) D_CLIENTS *CUENT NUMBER *FIRST NAME LAST NAME PHONE EMAIL NUMBER (5) VARCHAR2 (25) VARCHAR2(30) NUMBER (15) VARCHAR2(50) D_CLT_CLIENT_NUMBER_PK (CLIENT_NUMBER) D_PARTNERS 10 FIRST NAME LAST_NAME EXPERTISE SPECIALTY NUMBER (5) VARCHAR2 (25) VARCHAR2(30) VARCHAR2(25) VARCHAR2(25) AUTH EXPENSE AMT NUMBER (82) MANAGER JO NUMBER (5) PARTNER TYPE VARCHAR2(25) D_PTR_ID_PK (0) D.THEMES CODE NUMBER (10) DESCRIPTION VARCHAR2(100) D_TME_CODE_PK (CODE) D_PACKAGES CODE NUMBER (10) *LOW RANGE NUMBER (0) *HIGH_RANGE NUMBER (8) D_PKE_CODE_PK (CODE) D_VENUES NUMBER (5) VARCHAR2(30) VARCHAR2(100) *LOC_TYPE ADDRESS RENTAL FEE VARCHAR2 (50) COMMENTS VARCHAR2 (100) D_VNE JO_PK (10)

Answer rating: 100% (QA)

Create a Cross join that displays the columns in the dplaylistitems and the dtracklistings in the DJs on Demand database SELECT FROM DPLAYLISTITEMS DT... View the full answer