Suppose that we have a ternaryrelationship R between entity sets A, B, and C such that (i) A has a key constraint; and (ii) Chas a key constraintand total participation. These are the only constraints. A has attributes a1 and a2, with a1 being the key; B has attributes b1 and b2, with b1 being the key; and C has attributes c1and 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.
