Question: 2. 2a. Write appropriate SQL statements to create the tables specified in the figure (you may assign appropriate column types and lengths); also include important

2. 2a. Write appropriate SQL statements to create the tables specified

2a. Write appropriate SQL statements to create the tables specified in the figure (you may assign appropriate column types and lengths); also include important integrity constraints. Use your SQL statements to create the tables. [36]

2b. Insert sample data into your database tables (at least six records per table). Your data must illustrate the role of foreign keys and referential integrity. [18]

Music Database Relations Musicians (Mog. MName, MDOB MCountry} PK (Mnol Compositions (Co. CTitle CMno. CDate} PK [Cng]: FK [CMng references Musicians) Ensembles {Eno, EName ECountry, EMnoMor} PK [Eno]; FK [EMnoMar references Musicians) Performances (Png. PDate. Pone PCity. PCountry Peno_CKs (PDate. Penol. Prel; FK [PCno references Compositions); FK [PEno references Ensembles] Ensemble Members (EmEng. EmMno, Emlostrument) PK [EmEng. Emunol: FK [EmEng references Ensembles); FK EmMno references Musicians)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. Prepare a database specification (either a RAL or an ESG showing database-related details only) for the database. This database specification may be refined by introducing a sixth relational...

1. Write SQL statements to create all tables in the final normalized ERD Use appropriate data types and required constraints for attributes. Ensure all relationships and relationship constraints are...

Populating database with sample data AND 5. and 6. Questions. I want answer for 3 questions that i wrote bold and also I mentioned above. Thank you SHIP Shiple ShipName Weight YearBuilt...

Assignment 3 Instructions Create a database in SQLServer for the relational model provided in the HW3- Relational Schema file. Populate your database with some data to test your database. Write the...

World Traveler Cruise Line SHIP Ship Nurriter Ship Name Weight Year Built Passenger Capacity CRUISE Cruise Serial Number Sailing Date Return Date VISITS Visit Order BOOKING Price Satisfaction Rate...

Can you answer the questions I squared on the red below? Thank you very much, I really appreciate your work. Create a database in SQLServer for the relational model provided in the HW3- Relational...

Create a database in SQLServer for the relational model provided in the HW3- Relational Schema file. Populate your database with some data to test your database. Write the requested queries in SQL....

1. (10 points) Write SQL code to create the tables that implements the following design in a database named Library : - Include the drop statements and GO at appropriate places - ISBN is a Primary...

I also publish the same provided with the picture to make your work easier. i appreciate your work. Thank you very much SHORT SUMMARY: Provided the queries as per the requirement. Given the add...

When a company adds one increment of time to its budget period as one increment of time expires, it is practicing continuous budgeting. (T/F)

Mr. Khalil went to Pre-Owned Motor Corp to purchase a Jaguar for $120,000. He put 3% down and the interested rate is 5.00% for 5 years. What was the total principal paid at the end of year 3. Show...

Question 1 of 5 How do you change a setting so that a team member is not able to view a specific folder after a particular date?

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

How do direct subsidies, countercyclical payments, and marketing loan subsidies differ under the Farm Act of 2002? In what way do countercyclical payments and marketing loans help reduce the...

ADVANCED ANALYSIS Suppose the equation for the demand curve for some product X is P 8 .6 Q and the supply curve is P 2 .4 Q. What are the equilibrium price and quantity? Now suppose an excise tax...

KEY QUESTION Explain how each of the following contributes to the farm problem: a. The inelasticity of demand for farm products. b. The rapid technological progress in farming. c. The modest long-run...