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...
-
Dana Dodson died October 31, 2014, with a gross estate of $6.7 million, debts of $200,000, and a taxable estate of $6.5 million. Dana made no taxable gifts. All of her property passed under her will...
-
Skaters and dancers are energetic individuals. (S, D, E, I ) Translate the following statements into symbolic form. Avoid negation signs preceding quantifiers. The predicate letters are given in...
-
Greeks on campus. The question-and-answer column of a campus newspaper was asked what percentage of the campus was Greek (that is, members of fraternities or sororities). The answer given was that...
-
Assume the following financial data for Rembrandt Paint Co. and Picasso Art Supplies: a. If all the shares of Rembrandt Paint Co. are exchanged for those of Picasso Art Supplies on a share-for-share...
-
Ch Week 1 2 3 4 5 6 7 8 Number of Cost to Run Campers Camp 122 $9,210 176 14,430 106 8,910 100 8,900 96 8,770 128 9,710 124 9,920 196 13,370 E5-16 (Algo) Preparing Contribution Margin Income...
-
Pulsar Optics produces medical lasers for use in hospitals. The accounts and their balances appear in the ledger of Pulsar Optics on April 30 of the current year as follows: Preferred 1% Stock, $120...
-
Assume that you wish to purchase a bond with a 30-year maturity, an annual coupon rate of 10 percent, a face value of $1,000, and semiannual interest payments. If you require a 8.6 percent nominal...
-
PROVIDE A CASE BRIEF FOR THE FOLLOWING CASE PROVIDED BELOW: PEOPLE v. REKTE Court of Appeal, Fourth District, Division 2, California. The PEOPLE, Plaintiff and Respondent, v. Viktors Andris REKTE,...
-
The time between release from prison and another crime charge for a certain group of men is 36 months with a standard deviation of 9 months. What percentage of men get charged with a second crime...
-
capacitance simulation: https://phet.colorado.edu/sims/html/capacitor-lab-basics/latest/capacitor-lab-basics_en.html w Lab 4 (1).docx Homework Help - Q&A from Or x + C...
-
Mel Jackson, a resident of Tennessee, has been a driver for Blues Delivery Company for the past 7 years. For this purpose, he leases a truck from Blue, and his compensation is based on a percentage...
-
On Halloween night, a small boy decided to dress up as a bank robber. He went to house where the lights were on, indicating that the owner was receiving trick-or-treaters. When the homeowner, a...
-
Required: 1o. For both companies compute the (a) current ratio, (b) acid test ratio, ( accounts receivable turnover (inventory turnover (@days' sales in inventory, and (days' sales uncollected. (Do...
-
Suppose that you could invest in the following projects but have only $30,000 to invest. How would you make your decision and which projects would you invest in? Project Cost $ 8,000 11,000 9,000...
-
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...
-
7. A teacher working for the City of Lights earns vacation pay of $2,000 during 2008. However, the vacation will not be taken until the end of 2009. In the government-wide financial statements for...
-
8. Assume in question 7 that the teacher takes the vacation late in 2009 and is paid the entire $2,000. What journal entry is reported in creating each of the two types of financial statements?
-
5. A landfill is scheduled to be filled to capacity over a 10-year period. However, at the end of the first year of operations, the landfill is only 7 percent filled. How much liability for closure...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App