Question
Question 1 Suppose you are given a relation R with four attributes ABCD and the following set of FDs: ABC, BCD. a. Identify the candidate
Question 1 Suppose you are given a relation R with four attributes ABCD and the following set of FDs: ABC, BCD. a. Identify the candidate key(s) for R (recall that keys must be minimal) b. Determine if R is in BCNF, 3NF, or none of the above. If it is not in BCNF, decompose it into a set of BCNF relations.
Question 2 Suppose you are given a relation R with four attributes ABCD and the following set of FDs: BCA, ABC, CDA. a. Identify the key(s) for R (recall that keys must be minimal) b. Determine if R is in BCNF, 3NF, or none of the above. If it is not in BCNF, decompose it into a set of BCNF relations. Note: For both questions, recall that it is not sufficient to consider the set of FDs that are given, but also its closure. Question 3 (20
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started