Write SQL statements to create the relationships that correspond to the entity sets and relationship sets...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write SQL statements to create the relationships that correspond to the entity sets and relationship sets considering all the constraints in the given E-R diagram (50 Points). PROCEDURE 2: Write the SQL statements (50 Points). Write an SQL statement to add 'Thom Yorke' with ssn= 101 and 'PJ Harvey' with ssn=102 as musicians. Write an SQL statement to add 'Piano' with instrid=001, intstruments_key=1 and 'Guitar' with instrid=002, intstruments_key=0 as instruments. Write an SQL statement to add 'Piano' and 'Guitar' for 'PJ Harvey' and 'Guitar' for 'Thom Yorke' as Plays. Write the SQL statement that lists the musician's name and the instrument name this musician can play. Write an SQL statement to delete the 'PJ Harvey' Musician. Given the referential integrity constraints you chose for this schema, explain what happens when this statement is executed. Instruments instrid dname instruments_key Plays 8 ssn instrld Musicians ssn name Write SQL statements to create the relationships that correspond to the entity sets and relationship sets considering all the constraints in the given E-R diagram (50 Points). PROCEDURE 2: Write the SQL statements (50 Points). Write an SQL statement to add 'Thom Yorke' with ssn= 101 and 'PJ Harvey' with ssn=102 as musicians. Write an SQL statement to add 'Piano' with instrid=001, intstruments_key=1 and 'Guitar' with instrid=002, intstruments_key=0 as instruments. Write an SQL statement to add 'Piano' and 'Guitar' for 'PJ Harvey' and 'Guitar' for 'Thom Yorke' as Plays. Write the SQL statement that lists the musician's name and the instrument name this musician can play. Write an SQL statement to delete the 'PJ Harvey' Musician. Given the referential integrity constraints you chose for this schema, explain what happens when this statement is executed. Instruments instrid dname instruments_key Plays 8 ssn instrld Musicians ssn name
Expert Answer:
Answer rating: 100% (QA)
In the provided image you have an EntityRelationship ER diagram depicting the relationship between Musicians and Instruments through an associative en... View the full answer
Related Book For
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff
Posted Date:
Students also viewed these programming questions
-
Required: 1. Suppose that on January 1, 2020, Boeing sells one of its 777 series planes to Singapore Airlines on account-its first and only transaction on the first day of the fiscal year. The sales...
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
Write a python program that reads a string S containing integers and prints the maximum number of toys Robert has to buy for Charlie . . Input : 5 1 2 2 4 5 1 2 2 4 Output : 3 3
-
Why does the sky sometimes appear whitish?
-
Consider steady flow of air through the diffuser portion of a wind tunnel (Fig. P422). Along the centerline of the diffuser, the air speed decreases from u entrance to u exit as sketched....
-
What is a machine ?
-
Record the following transactions on the books of Keyser Co. (a) On July 1,Keyser Co. sold merchandise on account to Maxfield Inc. for $15,200, terms 2/10, n/30. (b) On July 8, Maxfield Inc. returned...
-
At December 31, balances in Manufacturing Overhead are Sandhill Company-debit $1,360, Wildhorse Company-credit $1,120. Prepare the adjusting entry for each company at December 31, assuming the...
-
The Philbrick Company has two plants on opposite sides of the United States. Each of these plants produces the same two products and then sells them to wholesalers within its half of the country. The...
-
Question The function f(x) = -2x + ax+bx+c is sketched below. The turning points of the graph of f are T(2:-9) and S(5:18). 9.1 9.2 9.3 S(5:18) T(2 : -9) Show that a = 21, b = -60 and c = 43....
-
Required: Compute the Drying Department's equivalent units of production for pulping and conversion. Compute the Drying Department's cost per equivalent unit for pulping and conversion. Compute the...
-
1. The receiving sensitivity level of a hydrophone is -80 dB re 1 V/ubar. a) Express this sensitivity level re 1 V/Pa. b) What will be the output voltage if the pressure level of the field is 80 dB...
-
The following code format represents an instruction that deals with a destination register and a source memory location. If the microcontroller was of RISC architecture, calculate: 1 - Number of...
-
Consider an agency MBS pool consisting of $300m of 15 year FRMs with a mortgage coupon rate of 4.5%. Mortgage payments are monthly. Assume a servicing and guarantee fee of 50bp per year (combined)...
-
Tabitha's Toys specializes in the manufacture of toys for children of all ages. In the Tabitha plant, parts for Tabitha's smaller toys are machined on two converted metal lathes. These lathes were...
-
What is the maturity value of a $90,000, 12%, six-month note? A. $84,600 B. $100,800 C. $90,000 D. $95.400
-
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...
-
Consider the following collection of relations and dependencies. Assume that each relation is obtained through decomposition from a relation with attributes ABCDEFGHI and that all the known...
-
Answer the following questions about Extendible Hashing: 1. Explain why local depth and global depth are needed. 2. After an insertion that causes the directory size to double, how many buckets have...
-
Discuss the strengths and weaknesses of the trigger mechanism. Contrast triggers with other integrity constraints supported by SQL.
-
How are the identifiable assets and liabilities acquired in a business combination measured?
-
What is meant by deferred consideration and how is it accounted for?
-
Distinguish between a business combination and a non-business acquisition.
Study smarter with the SolutionInn App