In this assignment you are going to create multi-table join statements to query the tables that you
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Expert Answer:
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
Related Book For
Intermediate Accounting
ISBN: 978-0324592375
17th Edition
Authors: James D. Stice, Earl K. Stice, Fred Skousen
Posted Date:
Students also viewed these accounting questions
-
On the first day of class last semester, 50 students were asked for the one-way distance from home to college (to the nearest mile).The resulting data follow: a. Construct a grouped frequency...
-
Partner D is a 10 percent general partner in ABCD Partnership. The partnership's financial records for the current tax year reveal the following: Gross receipts from sales . . . . . . . . . . . . . ....
-
O O O O O O O O O O E E O O E E Use the given sequence to determine the values of n1 n2, the number of runs G, and the 5% cutoff values from Table A-10.
-
Karamazov Semiconductors is considering an investment to expand its existing line of business. The investment will cost $10 million and is expected to produce after-tax cash flows of $1 million per...
-
In Austin, Texas, a comedy club complained to its landlord that its performances were being interrupted by the boisterous congregation of a church within the same building. The landlord asked the...
-
You word processed a short memo to John Richards, the accounting manager, whom you dont know. You gave it to your secretary, Chris, to send. Chris realized that you used the wrong last name, retyped...
-
Which of the following is a true statement about the comparison of Euclidean distance versus Manhattan distance? a. Manhattan distance is distorted less by outlier observations. b. Euclidean distance...
-
On January 1, 2011, Jessica Marie Company sold equipment to Gwang Ju Company for 20,000,000 Korean won, with payment to be received in two years on January 1, 2013. The exchange rate on January 1,...
-
What would be the value of x after the following statements were executed? int x; for (x=0; x
-
Javier is a police officer or Javier is a little league coach. If Javier is a police officer, then Javier is a community leader. Javier is a little league coach if and only if Javier is a community...
-
Using MSMS SQL Server Import/Export Wizard how do I import a .xlsx file to the SQL Server environment? Is there a process to follow?
-
How many typefaces should be used in an ad? Why?
-
What role does the media plan play in campaign development?
-
How can a brand come alive over the radio?
-
How are databases used in direct marketing? What is their importance?
-
What needs to be considered to ensure an IMC campaign is consistent and cohesive across multiple media?
-
1 of these Short Answer Questions requires you to refer to the state/territory-specific requirements, such as legislation and regulations of your state/territory. For your assessor's reference, put...
-
You are maintaining a subsidiary ledger account for Police-Training Expenditures for 2013. The following columns are used: Inventory purchases are initially recorded as expenditures. Record the...
-
On January 1, Reschke Company signed a 1-year rental for a total of $90,000, with quarterly payments of $22,500 due at the end of each quarter. In addition, the renter must pay contingent rent of 3%...
-
Describe the differences between pension plans and other postretirement benefit plans.
-
Match the numbered statements below with the lettered terms. An answer (letter) may be used more than once, and some terms require more than one answer (letter). 1. Key ingredients in quality of...
-
What can we learn from studying hunter-gatherer societies that might help us understand and interpret life in industrial societies today?
-
What are the benefits and limitations of conducting cross-cultural research?
-
What types of economic exchange would you expect to find in hunter-gatherer societies? Are the individuals in foraging societies more altruistic, magnanimous, and generous, or are they no more nobler...
Study smarter with the SolutionInn App