Part 1: Using SQL to Modify a Database (35 points total) Consider the following schema for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 1: Using SQL to Modify a Database (35 points total) Consider the following schema for a book database. bookDB: COLUMN BookID CategoryID Title Price Pages CIS9340 Exam 2 Book DATA TYPE INT INT VARCHAR(25) DECIMAL(6,2) INT ReleaseYear INT Category COLUMN CategoryID CategoryName VARCHAR(25) DATA TYPE INT COLUMN BookAuthorID Book D INT INT INT AuthorOrder INT AuthorID BookID CategoryID BookAuthor COLUMN Author D Here is some information that will help you: The schema (database) name is bookDB. The Book table contains books. Each row is a unique book. 1011 LastName FirstName DATA TYPE The Category table contains book categories such as business, novel, science fiction, education, etc. Each row is a unique category. Author The Author table contains authors. Each row is a ulque author. Each book can have multiple authors; and each autor can write multiple books. Each book only belongs to one category; and there are many books in each category. DATA TYPE INT Write the SQL statement (just one for each question) that performs the following tasks. (5 points) All the tables have already been created, except for the BookAuthor table. Create the BookAuthor table. VARCHAR(25) VARCHAR(25) b) (5 points) Add a new entry to the Book table that captures the following information for a new author: Instructor: Shuting Wang) Page 1 of 5 Part 1: Using SQL to Modify a Database (35 points total) Consider the following schema for a book database. bookDB: COLUMN BookID CategoryID Title Price Pages CIS9340 Exam 2 Book DATA TYPE INT INT VARCHAR(25) DECIMAL(6,2) INT ReleaseYear INT Category COLUMN CategoryID CategoryName VARCHAR(25) DATA TYPE INT COLUMN BookAuthorID Book D INT INT INT AuthorOrder INT AuthorID BookID CategoryID BookAuthor COLUMN Author D Here is some information that will help you: The schema (database) name is bookDB. The Book table contains books. Each row is a unique book. 1011 LastName FirstName DATA TYPE The Category table contains book categories such as business, novel, science fiction, education, etc. Each row is a unique category. Author The Author table contains authors. Each row is a ulque author. Each book can have multiple authors; and each autor can write multiple books. Each book only belongs to one category; and there are many books in each category. DATA TYPE INT Write the SQL statement (just one for each question) that performs the following tasks. (5 points) All the tables have already been created, except for the BookAuthor table. Create the BookAuthor table. VARCHAR(25) VARCHAR(25) b) (5 points) Add a new entry to the Book table that captures the following information for a new author: Instructor: Shuting Wang) Page 1 of 5
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
1. How strong are the competitive forces confronting J. Crew in the market for specialty retail? Do a [Michael Porter] five-forces analysis to support your answer. (see chapter 3 in the textfor...
-
"I'm not sure we should lay out $300,000 for that automated welding machine," said Jim Alder, president of the Superior Equipment Company. "That's a lot of money, and it would cost us $84,000 for...
-
1. If your job were to allocated one large amount of money to combat the illegal drug problem in America, (assume strong addictive characteristics to these drugs). Would you attack the supply or...
-
On January 1, 2014, Housen Company issued 10-year bonds of $500,000 at 102. Interest is payable on January 1 and July 1 at 10%. On April 1, 2015, Housen Company reacquires and retires 50 of its own...
-
KnightWashing is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The cost formula for its electricity cost is $1,200 per month plus $0.15 per car washed....
-
Explain the main accounting conventions underpinning the income statement.
-
Reinterpret the endogenous growth model in this chapter as follows. Suppose that there are two groups of people in a country, the low-skilled workers and the high-skilled workers. The low-skilled...
-
Anne Arnie runs a Soda 'n Stuff store in a large strip mall that has only Anne's store and one other business as tenants. The remaining stores in the strip mall are vacant. Anne's customers are...
-
Consider the following income tax footnote information for Oracle for the fiscal year ended May 31, 2019 (fiscal year 2019). The following is a geographical breakdown of income before the provision...
-
Adjustment for Uncollectible Accounts Below is the aging of receivables schedule for Evers Industries. Aging-of-Receivables Schedule November 30 Not 1-30 31-60 61-90 Over 90 Past Days Days Customer...
-
You would like your retirement fund to have 450,000$ after 32 years. The bank offers you an APR of 2.6%, compounded quarterly. How much should your quarterly deposits be in order to reach that goal?...
-
write this program in python example Project 1 *ensure you have read course policies in D2L shell Required python aspects for this project Pseudocode Submission of code in D2L (pseudocode is in a...
-
Determine whether the planes are parallel, perpendicular, or neither. x + 7y-z = 7, 7x-7y + z = 1 parallel O perpendicular O neither If neither, find the angle between them. (Use degrees and round to...
-
4. Solve and find an explicit solution to (x+2)2y+8y=5-4xy. dy da
-
following digraphs: a. Apply the DFS-based algorithm to solve the topological sorting problem for the b. [4]
-
The first step in a time series analysis is to plot the data. true false maybe A B Question 1 Unanswered The first step in a time series analysis is to plot the data. True False C Maybe X Submit
-
Citing a scientific article, explain in your own words, how DNA fingerprinting has been used in forensic science to solve crimes and why it may not always be accurate or effective.
-
Frank, age 35, and Joyce, age 34, are married and file a joint income tax return for 2012. Their salaries for the year total $83,000 and they have taxable interest income of $4,000. They have no...
-
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...
-
During 2012, Tom sold Sears stock for $10,000. The stock was purchased 4 years ago for $13,000. Tom also sold Ford Motor Company bonds for $35,000. The bonds were purchased 2 months ago for $30,000....
-
The amplitudes of displacement and acceleration of an unbalanced turbine rotor are found to be \(0.5 \mathrm{~mm}\) and \(0.5 \mathrm{~g}\), respectively. Find the rotational speed of the rotor using...
-
The root mean square (rms) value of a function, \(x(t)\), is defined as the square root of the average of the squared value of \(x(t)\) over a time period \(\tau\) :...
-
Prove that the sine Fourier components \(\left(b_{n} ight)\) are zero for even functions-that is, when \(x(-t)=x(t)\). Also prove that the cosine Fourier components \(\left(a_{0} ight.\) and...
Study smarter with the SolutionInn App