Given the relation MARRIED that consists of tuples of the form (a, b), where a is the husband and b is the wife, the relation BROTHER that has tuples of the form (c, d), where c is the brother of d, and the relation SIBLING which has tuples of the form (e, f), where e and f are siblings, describe how you would define the relation BROTHER-IN-LAW, where tuples have the form (x, y) with x being the brother-in-law of y.

1. Draw appropriate Entity-Relationship (E-R) diagram that satisfies the above facts. Indicate the multiplicity of relationships and the key or keys for the entity sets and relationships, and weak and subclass entity sets, whenever exist.

2. Translate the E-R diagram into relational database schema. Indicate the key or keys for each relation.

3. Give appropriate SQL statements to create the database tables and provide a solution of the problem.