Create a database called music. Create a table called bandinfo with the following columns. Make sure...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a database called music. Create a table called bandinfo with the following columns. Make sure to choose optimal data type for each. Insert 20 records into the table. Pick your favourite bands and favourite genre of music. - Band Name - Formation Year Current Status (Active or Inactive) Base City Base Country - Number of Releases - Genre 2- (25%) - Create a second table called bandrecognition with the following columns. Make sure to choose optimal data type for each. Insert 20 rows. Make sure band names in this table have a corresponding band name in the bandinfo table. - - Number of Band Members - Band Name Award Nomination ("N" for nominated; "A" for awarded) Year 3- (25%) - Alter the bandinfo table. Add a column called releases. This column will contain a JSON document containing with the list of releases, type of release, release year and release title. See JSON example provided. Choose a number of bands (a minimum of 5) and create a JSON document to list releases. 4- (25%) - Create a fourth table called bandmembers with the following columns: - - Band Name - Last Name First Name Role Start Year End Year Select a set of bands (a minimum of 5) and add the band members to this table. For this table we need to set up automatic history - sometimes called history tables. The purpose of history tables is to keep track of changes made to the table so you can run - what is called - an "AS OF" query. Read about this. You'll understand why we want to use this capability for this table given band members can change quite a bit for bands. If you are using Db2 - this is what you want: https://www.ibm.com/docs/en/db2-warehouse?topic=tables- application-period-temporal If you are using Oracle - this is what you want: https://docs.oracle.com/database/121/VLDBG/GUID-AF78C832-516A- 4686-9DDF-CE12597F7723.htm#VLDBG14127 If you are using Microsoft SQLServer- this is what you want: https://learn.microsoft.com/en-us/sql/relational- databases/tables/temporal-tables?view=sql-server-ver16 Create a database called music. Create a table called bandinfo with the following columns. Make sure to choose optimal data type for each. Insert 20 records into the table. Pick your favourite bands and favourite genre of music. - Band Name - Formation Year Current Status (Active or Inactive) Base City Base Country - Number of Releases - Genre 2- (25%) - Create a second table called bandrecognition with the following columns. Make sure to choose optimal data type for each. Insert 20 rows. Make sure band names in this table have a corresponding band name in the bandinfo table. - - Number of Band Members - Band Name Award Nomination ("N" for nominated; "A" for awarded) Year 3- (25%) - Alter the bandinfo table. Add a column called releases. This column will contain a JSON document containing with the list of releases, type of release, release year and release title. See JSON example provided. Choose a number of bands (a minimum of 5) and create a JSON document to list releases. 4- (25%) - Create a fourth table called bandmembers with the following columns: - - Band Name - Last Name First Name Role Start Year End Year Select a set of bands (a minimum of 5) and add the band members to this table. For this table we need to set up automatic history - sometimes called history tables. The purpose of history tables is to keep track of changes made to the table so you can run - what is called - an "AS OF" query. Read about this. You'll understand why we want to use this capability for this table given band members can change quite a bit for bands. If you are using Db2 - this is what you want: https://www.ibm.com/docs/en/db2-warehouse?topic=tables- application-period-temporal If you are using Oracle - this is what you want: https://docs.oracle.com/database/121/VLDBG/GUID-AF78C832-516A- 4686-9DDF-CE12597F7723.htm#VLDBG14127 If you are using Microsoft SQLServer- this is what you want: https://learn.microsoft.com/en-us/sql/relational- databases/tables/temporal-tables?view=sql-server-ver16
Expert Answer:
Answer rating: 100% (QA)
It looks like youve shared a complex multipart database assignment with various steps Heres the outline and SQL statements required to complete each part based on the images provided Since the specifi... View the full answer
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
Mr. Rahul is one of major player in textile business in southern part of India but his 65% percent of the product is sold in the domestic market only and 35% is being exported. He is not availing any...
-
One of the key questions raised by the facts of the Friars For Life case is should the client be allowed to determine what appears in the financial statements? should audit firms discuss their audit...
-
Project 1 provides experience with creating ERDs and writing CREATE TABLE statements for the Expense Reporting database at XCorp, a fast-growing web consulting company. You will design an ER Diagram...
-
Suggest a good synthetic method for preparing each of the following haloalkanes from the corresponding alcohols. CH3 H3C CI I () CH-CH-CH,CI (b) CH;CH,CHCH,Br () (d) CH;CHCH(CH3)2
-
Does the three-step writing process apply to IM? Why or why not?
-
For each of the following $1,000-par-value bonds paying semi-annual interest payments, calculate the before- and after-tax cost of debt. Use the 21% corporate tax rate. Issuer Name AT&T Boeing CVS...
-
Zainab visits the nursing home every 5 days. She visits on a Sunday. What day of the week will it be when she visits it for the 7 th time after that?
-
Davis Instruments has two manufacturing plants located in Atlanta, Georgia. Product demand varies considerably from month to month, causing Davis extreme difficulty in workforce scheduling. Recently...
-
Compare the differences of information provided by a balance sheet and an income statement. When considering scenarios like a supplier planning to extend credit with terms of payment in 60 days,...
-
Cortez Manufacturing intends to increase capacity by overcoming a bottleneck operation by adding new equipment. Two vendors have presented proposals. The fixed costs are $50,000 for proposal A and...
-
You are bullish on X Corp stock. The current stock price is $50 per share. You have $35,000 of your own, and you borrow an additional $25,000 from your broker. 1. How many shares did you buy? ...
-
Assume the United States has a standard flexible exchange rate regime with free flows of capital: All else equal, if the Federal Reserve increases the money supply and lowers interest rates, what...
-
Managers use CVP concepts to perform sensitivity analysis. Sensitivity analysis is a "what-if" technique that asks what will happen to a company's breakeven or target profit if sales price, costs, or...
-
Write a Java program that prompts the user to input the elapsed time for an event in seconds. The program then outputs the elapsed time in hours, minutes, and seconds. (For example, if the elapsed...
-
Estimate the chronic daily intake of 1,1,1-trichloroethane from exposure to a city water supply that contains a 1,1,1-trichloroethane concentration equal to the drinking water standard of 9,2 mg/L....
-
Consider the Obsidian Project, which requires an investment of $362,868 initially, with subsequent cash flows of $58,160, $72,091 and $97,900. We can characterize the project with the following...
-
A business owner applies for a credit card to cover $13,000 in emergency expenses. The credit card charges 19.99% annual interest compounded continuously. If no payments are made for 2 years, what...
-
Why is inventory management important for merchandising and manufacturing firms and what are the main tradeoffs for firms in managing their inventory?
-
Describe the general guidelines for structuring data entry fields. Can you think of any instances when it would be appropriate to violate these guidelines?
-
Jim Watanabe looked around his new office. He couldnt believe that he was the assistant director of information technology at Petrie Electronics, his favorite consumer electronics retail store. He...
-
What is the difference between reverse engineering and reengineering tools?
-
What information appears on Form W-2, the employee's Wage and Tax Statement?
-
Workers compensation provides insurance for employees who (a) are unemployed due to a layoff. (b) are unemployed due to a plant closing. (c) are underemployed and need additional compensation. (d)...
-
The journal entry at the end of the year that recognizes an additional premium owed under workers compensation insurance will include a (a) debit to Workers Compensation Insurance Expense. (b) debit...
Study smarter with the SolutionInn App