Question: Task 2 [40 points Given an ER diagram (as shown below), write SQL statements to create the corresponding relations and capture as many of the

 Task 2 [40 points Given an ER diagram (as shown below),

Task 2 [40 points Given an ER diagram (as shown below), write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why. ( title p id d_name salary d id budget manages phone Professor Department Building works_in Dependent Child name age Task 3 [20 points). Suppose that we have a ternary relationship R between entity sets A, B, and C such that (i) A has a key constraint; and (ii) C has a key constraint and total participation. These are the only constraints. A has attributes al and a2, with al being the key; B has attributes b1 and b2, with b1 being the key: and C has attributes c1 and c2, with c1 being the key. R has no descriptive attributes. All of the above-mentioned attributes are to be stored as Strings of 10 characters. Write SQL statements that create tables corresponding to this information so as to capture as many of the constraints as possible. If you cannot capture some constraint, explain why

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!