City Guilds Model Questions Vol1 2023 Information Technology Question 47
Practice objective / multiple choice question 47 from the 2023 City Guilds Model Questions Vol1 Information Technology examination.
Consider a relation R(A,B,C,D,E) with the set of functional dependencies:\n\(A \rightarrow B,\; A \rightarrow C,\; BC \rightarrow D,\; D \rightarrow E\).\n(a) List all candidate keys of R.\n(b) Decompose R into a collection of relations that are in Third Normal Form (3NF) while preserving dependencies and ensuring a lossless‑join. Provide the resulting relation schemas.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2023 Information Technology Question 47. It is one of the objective questions from the 2023 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.