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
-
Two steady flow of air enters a control volume, shown in Fig. P6.37. One is 0.025 kg/s flow at 350 kPa, 150C, state 1, and the other enters at 350 kPa, 15C, both flows with low...
-
1) A mass m on a massless string of length 1 hangs from the ceiling of a train accelerating with constant acceleration 9/8. a) Find the tension in the string and the angle that the string makes with...
-
Visit www.pearsonglobaleditions.com/malhotra to read the video case and view the accompanying video. Marriott: Marketing Research Leads to Expanded Offerings highlights Marriotts success in using...
-
Royale Aluminum desires an after-tax income of $500,000. It has fixed costs of $2,500,000, a unit sales price of $300, and unit variable costs of $150, and is in the 40% tax bracket. Required: 1....
-
Given that the rate of change in the exchange rate is conditionally normally distributed, if the standard deviation of the 90-day rate of appreciation of the CAD relative to the USD is 4%, what range...
-
Construct a bond graph or Niggli formula to determine if it is possible for all anions to be equivalent in a structure of tetrahedrally coordinated cations and stoichiometry of C 2 A 3 ? Which...
-
The electric field and the magnetic field in free space are given by 50 R cos(106t+Bz) V/m # cos(106t+Bz) A/m = = Ho R Express these in phasor form and determine the constants H, and such that the...
-
Jim Junction purchased a building business on November 17,2017 , for \(\$ 400,000\). On July 21, 2018, he exchanged the building for another business building in a like-kind exchange. The new...
-
What is meant by cross-validation in a discriminant model? Why is it done and how does it work?
-
In 2018, Sally Morris, a single taxpayer, pays \(\$ 3,000\) of interest on qualified student loans. Her AGI is \(\$ 40,000\). What is her qualified student loan interest deduction in 2018 ?
-
How can the ill-effects of multicollinearity be mitigated? Describe each potential remedy and note the advantages and disadvantages of each.
-
What are some of the key differences and key assumptions between scientific and interpretive approaches to conducting research in health communication? Give two examples for how each approach can be...
-
As shown in the illustration, Assuming elastic action for the beam, determine the slope at point B and the deflection at point A. Neglect the weight of the beam itself. I = 144 in.4 E = 24 X 106 psi...
-
-4 1 9. Let A = Find A-1, (A") and verify that (A")= (A-1)".
-
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?
-
Holland at Home is considering introducing a variation of its current breakfast cereal, Zonnatura Regular Muesli Rich. The new cereal will be similar to the old with the exception that it will...
-
TSMC Corporation is considering selling one of its old wafer fabrication machines. The machine, purchased for \($3,000,000\) 5 years ago, had an expected life of 10 years and an expected salvage...
-
Assume that Fiskars Finland plans to invest in a new project that will annually generate revenues of \($2.3\) million. Cash expenses including both fixed and variable costs will be \($950,000,\) and...
Study smarter with the SolutionInn App