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), 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
Get step-by-step solutions from verified subject matter experts
