CAN YOU PLEASE EXPLAIN IN TASK 3 - HOW DO WE REPRESENT TOTAL PARTICIPATION AND KEY CONSTRAINTS IN SQL CODE. PLEASE PROVIDE SOLUTION AND DETAILED EXPLANATION.

I WOULD REALLY APPRECIATE IF YOU CAN HELP ME WITH THE ABOVE 2 QUESTIONS.

I WILL DEFINITELY RATE!!

Thank you.

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. d_name p_id title 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 52, with b1 being the key; and Chas attributes cl and c2, with cl 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