The given SQL creates an Album table and a Song table. The SHOW COLUMNS queries show...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The given SQL creates an Album table and a Song table. The SHOW COLUMNS queries show information about the Album and Song table columns. Modify the two CREATE TABLE statements: 1. Add a primary key constraint to the Album table's ID column. 2. Add a primary key constraint to the Song table's ID column. 3. Add a foreign key constraint to the Song table so the AlbumID column refers to the Album table's ID column. 1 Add a primary key 2 CREATE TABLE Album ( 3 ID INT, 4 Title VARCHAR(60), 5 ReleaseYear INT 6); 7 8 9 CREATE TABLE Song ( 10 ID INT, -- Add primary and foreign keys 11 Title VARCHAR(60), 12 Artist VARCHAR (60), 13 AlbumID INT 14); 15 16 SHOW COLUMNS 17 FROM Album; 18 19 SHOW COLUMNS 20 FROM Song; The given SQL creates an Album table and a Song table. The SHOW COLUMNS queries show information about the Album and Song table columns. Modify the two CREATE TABLE statements: 1. Add a primary key constraint to the Album table's ID column. 2. Add a primary key constraint to the Song table's ID column. 3. Add a foreign key constraint to the Song table so the AlbumID column refers to the Album table's ID column. 1 Add a primary key 2 CREATE TABLE Album ( 3 ID INT, 4 Title VARCHAR(60), 5 ReleaseYear INT 6); 7 8 9 CREATE TABLE Song ( 10 ID INT, -- Add primary and foreign keys 11 Title VARCHAR(60), 12 Artist VARCHAR(60), 13 AlbumID INT 14); 15 16 SHOW COLUMNS 17 FROM Album; 18 19 SHOW COLUMNS 20 FROM Song; The given SQL creates an Album table and a Song table. The SHOW COLUMNS queries show information about the Album and Song table columns. Modify the two CREATE TABLE statements: 1. Add a primary key constraint to the Album table's ID column. 2. Add a primary key constraint to the Song table's ID column. 3. Add a foreign key constraint to the Song table so the AlbumID column refers to the Album table's ID column. 1 Add a primary key 2 CREATE TABLE Album ( 3 ID INT, 4 Title VARCHAR(60), 5 ReleaseYear INT 6); 7 8 9 CREATE TABLE Song ( 10 ID INT, -- Add primary and foreign keys 11 Title VARCHAR(60), 12 Artist VARCHAR (60), 13 AlbumID INT 14); 15 16 SHOW COLUMNS 17 FROM Album; 18 19 SHOW COLUMNS 20 FROM Song; The given SQL creates an Album table and a Song table. The SHOW COLUMNS queries show information about the Album and Song table columns. Modify the two CREATE TABLE statements: 1. Add a primary key constraint to the Album table's ID column. 2. Add a primary key constraint to the Song table's ID column. 3. Add a foreign key constraint to the Song table so the AlbumID column refers to the Album table's ID column. 1 Add a primary key 2 CREATE TABLE Album ( 3 ID INT, 4 Title VARCHAR(60), 5 ReleaseYear INT 6); 7 8 9 CREATE TABLE Song ( 10 ID INT, -- Add primary and foreign keys 11 Title VARCHAR(60), 12 Artist VARCHAR(60), 13 AlbumID INT 14); 15 16 SHOW COLUMNS 17 FROM Album; 18 19 SHOW COLUMNS 20 FROM Song;
Expert Answer:
Answer rating: 100% (QA)
To modify the CREATE TABLE statements to add a primary key constraint to the Album tables ID column ... View the full answer
Related Book For
Using Microsoft Excel and Access 2016 for Accounting
ISBN: 978-1337109048
5th edition
Authors: Glenn Owen
Posted Date:
Students also viewed these databases questions
-
Manufacturing A ball manufacturer produces soccer balls, footballs, and volleyballs. The manager feels that restricting the types of balls produced could increase revenue. The following table gives...
-
Write project about the capital structure of Amazon or any publicly traded company and the M&M theory of capital structure. project should consist of The I-Abstract II - Table of Contents III -...
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
The following information is available for Marigold's Hot Dogs: Actual production Budgeted production Standard direct labor hours Actual direct labor hours Standard variable overhead rate Actual...
-
When is energy most evident?
-
Does the Challenge Solution change if the entry of the generic causes a parallel shift to the left of the patent monopoly's linear demand curve?
-
Assume, in the preceding problem, that Everlast Batteries is in stable growth, and that it expects its economic value added to grow at 5% a year forever. a. Estimate the value of the firm. b. How...
-
After six months of study, much political arm wrestling, and some serious financial analysis, Dr. Martin Starr, president of Southwestern University, had reached a decision. To the delight of its...
-
Hi! Please help with the following question QUESTION 7 4 points Save Answer ClassPass and SoulCycle are American companies operating in the consumer fitness industry. ClassPass does not own or...
-
Rain is falling on a poorly designed 150-m2 flat roof of a contemporary home. The design flaw requires the water level on the roof to reach approximately 5 cm above the plane of the roof before the...
-
Page 2 of 6 Question 6 (2 points) Listen What is the domain and range of the following graph. Write each in set notation Reminder-- submit all your work for the entire assignment in one single pdf...
-
The following information pertains to ABC Company's Direct Labor for March: Standard DL Hours - 21,000 Actual DL Hours - 20,000 Labor Rate Variance - 8,400 Favorable Standard Labor Rate per hour is...
-
At the beginning of the year, Eagle Corp. purchased 10,000 of the 200,000 shares of common stock of Bobcat Inc. at $40 per share as a long-term investment. The records of Bobcat Inc. showed the...
-
Timmy owns 25% of the stock of Jabo Corporation. Jabo has depreciable machinery that cost $25,000 two years ago and has an adjusted basis of $18,000. This year, Jabo sells it to Timmy for $17,000....
-
What strategic imperatives should firms consider when expanding into emerging markets characterized by cultural nuances, regulatory intricacies, and socioeconomic disparities, and how can they...
-
What management accounting related considerations would be important if the company decided to move one of its operation to a production facility in a foreign country? How does the ownership of that...
-
The stock price is $ 3 0 , the strike price is $ 3 0 , the risk free rate is 6 % per annum, the volatility is 2 0 % per annum and the time to maturity is 9 months. Assume a 3 stop binomial model a )...
-
What types of questions can be answered by analyzing financial statements?
-
Create action queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.) a. Create and run an update query that increases the unit price for...
-
What do liquidity ratios represent?
-
Edit select queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.) a. Edit Query1 by adding the field PostalCode from the Supplier Tableand...
-
You are hired to perform a forensic audit of a movie (e.g., College). Prepare a short term paper on production accounting for a movie or T.V. production.
-
Define misappropriation of asset. What are other terms for this concept?
-
Multiplier, Inc. has a 25 percent gross profit margin during a year when there is a skimming scheme which reduces the bottom-line by \(\$ 1,200,000\). What increase in revenue is needed to replace...
Study smarter with the SolutionInn App