Consider the following two relational schemas: Schema 1: R(A,B,C,D) Schema 2: R1(A,B,C),R2(B,D) (a) Consider Schema 1 and suppose that the only functional dependencies that hold on the relations in this schema are AB,CD, and all dependencies that follow from these. Is Schema 1 in Boyce-Codd Normal Form (BCNF)? (b) Consider Schema 2 and suppose that the only functional dependencies that hold on the relations in this schema are AB,AC,BA,AD, and all dependencies that follow from these. Is Schema 2 in BCNE? (c) Suppose we omit dependency AD from part (b). Is Schema 2 in BCNF? (d) Consider Schema 1 and suppose that the only functional and multivalued dependencies that hold on the relations in this schema are ABC,BD,BCD, and all dependencies that follow from these. Is Schema 1 in Fourth Normal Form (4NF)? (e) Consider Schema 2 and suppose that the only functional and multivalued dependencies that hold on the relations in this schema are ABD,DC,AC,BD, and all dependencies that follow from these. Is Schema 2 in 4NF S