1. 
   
2. Write a SQL statement to create a non-unique index for the DJ's on Demand database column (cd_number) in the D_TRACK_LISTINGS table. (4 points)
   1. In Apex Oracle
   2. Use the APEX SQL Workshop Object Browser to confirm that the index was created.
3. Write a SQL statement to create an unique index for the DJ's on Demand database column (email) in the D_CLIENTS table. (4 points)
   1. Use the APEX SQL Workshop Object Browser to confirm that the index was created.
4. Write a SQL statement to create a non-unique index for the DJ's on Demand database columns (title, artist) in the D_SONGS table. (4 points)
   1. Make sure both columns are part of the same index
   2.  

Transcribed Image Text:

DJs on Demand Table Design PCD NUMBER PF EVENT_ID PF SONG ID P 10 TITLE PRODUCER YEAR D_PLAY LIST ITEMS NUMBER (5) NUMBER (5) COMMENTS VARCHAR2 (80) D_PLM_PK (EVENT_ID, SONG_ID) D_PLM_EVENT_ID_FK (EVENT_ID) D_PLM_SONG_ID_FK (SONG_ID) D SONGS TITLE DURATION ARTIST F TYPE CODE D_TRACK LISTINGS PF SONG ID NUMBER (5) NUMBER (5) PF CD NUMBER TRACK NUMBER (2) D_TLO_PK (SONG_ID. CD_NUMBER) D_TLG_CD_NUMBER_FK (CD_NUMBER) D TLG SONG ID_FK (SONG ID) SONG_ID_IDX (SONG_ID) D_CDS NUMBER (5) VARCHAR2 (50) VARCHAR2 (20) VARCHAR2 (20) NUMBER (10) D_SNG_ID_PK (ID) D_SNG TYPE_CODE_FK (TYPE_CODE) NUMBER (5) VARCHARZ (50) VARCHAR2 (50) VARCHAR2 (4) D_CDS_CD_NUMBER_PK (CD_NUMBER) D_CDS_IDX (TITLE) D_TYPES PF PARTNER_ID PF EVENT ID JOB DATE STATUS PID F F F F D JOB ASSIGNMENTS NUMBER (5) NUMBER (5) DATE VARCHAR2 (50) D_JAT PK (PARTNER_ID. EVENT_ID) D_JAT EVENT ID_FK (EVENT_ID) D_JAT PARTNER_ID_FK (PARTNER_ID) NAME *EVENT_DATE DESCRIPTION COST VENUE_ID D EVENTS PACKAGE CODE THEME_CODE CLIENT NUMBER D_EVE_ID_PK (ID) CODE NUMBER (10) DESCRIPTION VARCHAR2 (50) D_TPE_CODE_PK (CODE) NUMBER (5) VARCHAR2 (50) DATE VARCHAR2 (50) NUMBER (8.2) NUMBER (5) NUMBER (10) NUMBER (10) NUMBER (5) D_EVE CLIENT NUMBER FK (CLIENT_NUMBER) D_EVE PACKAGE CODE FK (PACKAGE_CODE) D_EVE THEME_CODE_FK (THEME_CODE) D_EVE_VENUE_ID_FK (VENUE_ID) D_CLIENTS NUMBER (5) VARCHAR2 (25) VARCHAR2 (30) NUMBER (15) VARCHAR2 (50) P CLIENT NUMBER FIRST NAME LAST NAME PHONE EMAIL D_CLT CLIENT NUMBER_PK (CLIENT_NUMBER) ID FIRST NAME LAST NAME D PARTNERS EXPERTISE SPECIALTY AUTH_EXPENSE AMT MANAGER ID PARTNER TYPE D_PTR_ID_PK (10) IP CODE DESCRIPTION P CODE PID NUMBER (5) VARCHAR2 (25) VARCHAR2 (30) VARCHAR2 (25) D_THEMES VARCHAR2 (25) NUMBER (8.2) NUMBER (5) VARCHAR2 (25) D_TME CODE_PK (CODE) NUMBER (10) VARCHAR2 (100) D PACKAGES *LOC_TYPE ADDRESS *RENTAL FEE COMMENTS D_VNE_ID_PK (ID) LOW RANGE HIGH_RANGE D_PKE_CODE_PK (CODE) NUMBER (10) NUMBER (6) NUMBER (6) D_VENUES NUMBER (5) VARCHAR2 (30) VARCHAR2 (100) VARCHAR2 (50) VARCHAR2 (100) DJs on Demand Table Design PCD NUMBER PF EVENT_ID PF SONG ID P 10 TITLE PRODUCER YEAR D_PLAY LIST ITEMS NUMBER (5) NUMBER (5) COMMENTS VARCHAR2 (80) D_PLM_PK (EVENT_ID, SONG_ID) D_PLM_EVENT_ID_FK (EVENT_ID) D_PLM_SONG_ID_FK (SONG_ID) D SONGS TITLE DURATION ARTIST F TYPE CODE D_TRACK LISTINGS PF SONG ID NUMBER (5) NUMBER (5) PF CD NUMBER TRACK NUMBER (2) D_TLO_PK (SONG_ID. CD_NUMBER) D_TLG_CD_NUMBER_FK (CD_NUMBER) D TLG SONG ID_FK (SONG ID) SONG_ID_IDX (SONG_ID) D_CDS NUMBER (5) VARCHAR2 (50) VARCHAR2 (20) VARCHAR2 (20) NUMBER (10) D_SNG_ID_PK (ID) D_SNG TYPE_CODE_FK (TYPE_CODE) NUMBER (5) VARCHARZ (50) VARCHAR2 (50) VARCHAR2 (4) D_CDS_CD_NUMBER_PK (CD_NUMBER) D_CDS_IDX (TITLE) D_TYPES PF PARTNER_ID PF EVENT ID JOB DATE STATUS PID F F F F D JOB ASSIGNMENTS NUMBER (5) NUMBER (5) DATE VARCHAR2 (50) D_JAT PK (PARTNER_ID. EVENT_ID) D_JAT EVENT ID_FK (EVENT_ID) D_JAT PARTNER_ID_FK (PARTNER_ID) NAME *EVENT_DATE DESCRIPTION COST VENUE_ID D EVENTS PACKAGE CODE THEME_CODE CLIENT NUMBER D_EVE_ID_PK (ID) CODE NUMBER (10) DESCRIPTION VARCHAR2 (50) D_TPE_CODE_PK (CODE) NUMBER (5) VARCHAR2 (50) DATE VARCHAR2 (50) NUMBER (8.2) NUMBER (5) NUMBER (10) NUMBER (10) NUMBER (5) D_EVE CLIENT NUMBER FK (CLIENT_NUMBER) D_EVE PACKAGE CODE FK (PACKAGE_CODE) D_EVE THEME_CODE_FK (THEME_CODE) D_EVE_VENUE_ID_FK (VENUE_ID) D_CLIENTS NUMBER (5) VARCHAR2 (25) VARCHAR2 (30) NUMBER (15) VARCHAR2 (50) P CLIENT NUMBER FIRST NAME LAST NAME PHONE EMAIL D_CLT CLIENT NUMBER_PK (CLIENT_NUMBER) ID FIRST NAME LAST NAME D PARTNERS EXPERTISE SPECIALTY AUTH_EXPENSE AMT MANAGER ID PARTNER TYPE D_PTR_ID_PK (10) IP CODE DESCRIPTION P CODE PID NUMBER (5) VARCHAR2 (25) VARCHAR2 (30) VARCHAR2 (25) D_THEMES VARCHAR2 (25) NUMBER (8.2) NUMBER (5) VARCHAR2 (25) D_TME CODE_PK (CODE) NUMBER (10) VARCHAR2 (100) D PACKAGES *LOC_TYPE ADDRESS *RENTAL FEE COMMENTS D_VNE_ID_PK (ID) LOW RANGE HIGH_RANGE D_PKE_CODE_PK (CODE) NUMBER (10) NUMBER (6) NUMBER (6) D_VENUES NUMBER (5) VARCHAR2 (30) VARCHAR2 (100) VARCHAR2 (50) VARCHAR2 (100)

Answer rating: 100% (QA)

Sure I can help with that Heres how you can create these indexes using SQL queries 1 To create a non... View the full answer