Given Relation R B C D Answer Following Questions Given Set Fds Identify Candidate Keys St Q37211990

Given a relation R={A,B,C,D}

Answer the following questions with the given a set of FDs:

1. Identify candidate keys
2. State the strongest normal form that R satisfies (e.g., 1NF,2NF, 3NF or BCNF)
3. Decompose R into a set of BCNF relations that satisfies thedependency preservation property

1. FDs:

           A → B

           B → C

           C → D

2. FDs:

           AB → C

           AB → D

           B → C

           C → D

3. FDs:

           A → B

           BC → D

           A → C

---

Answer

---

DATE: C1 idat oni oSe 2 RI (ABC DATE 201 B<D