Question
(a) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J and the set of functional dependencies F
(a) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J and the set of functional dependencies F = { {A, B} {C}, {A} {D,E}, {B}{F}, {F}{G,H}, {D} -> {I, J}}. 1. Derive the key for R. 2. Decompose R into 2NF, then 3NF relations. (b) Consider the universal relation R(A, B, C, D, E, F, G) and the set of functional dependencies A --> B, B --> {A, C, E, C --> {B, F, D}, F --> {D, G} Derive the key for R (c) Consider the relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F as follows; F = { AB C, BD EF, AD GH, A I, HJ}. Find the key of relation R.
Step by Step Solution
3.50 Rating (167 Votes )
There are 3 Steps involved in it
Step: 1
a Key AB Explanation Let us find attribute closure of AB We add AB to attribute closure first Now fr...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 StartedRecommended Textbook for
A Survey of Mathematics with Applications
Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde
10th edition
134112105, 134112342, 9780134112343, 9780134112268, 134112261, 978-0134112107
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App