Consider the above conditions. Which of the following relation holds ?
A. Course id-> title, dept name, credits
B. Title-> dept name, credits
C. Dept name-> credits
D. Cannot be determined
Answer:A
Consider the above conditions. Which of the following relation holds ?
A. Course id-> title, dept name, credits B. Title-> dept name, credits C. Dept name-> credits D. Cannot be determined
Explanation: Here course id is not a superkey. Thus, class is not in BCNF. 5. The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is