City Guilds Model Questions Vol1 2018 Information Technology Question 6
Practice objective / multiple choice question 6 from the 2018 City Guilds Model Questions Vol1 Information Technology examination.
A relation R(A, B, C, D, E) has the set of functional dependencies \(A \rightarrow B\), \(BC \rightarrow D\), \(D \rightarrow E\), and \(AB \rightarrow C\).\n\n(a) State whether R is in Boyce‑Codd Normal Form (BCNF).\n(b) If it is not, decompose R into a set of relations that are in BCNF using a lossless‑join decomposition. List the resulting relations and their attributes.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2018 Information Technology Question 6. It is one of the objective questions from the 2018 City Guilds Model Questions Vol1 Information Technology examination.
Difficulty level: Medium .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.