Question
Normalization Assignment Consider the universal relation R = {A, B, C, D, E, F G, H I, J} and the set of functional dependencies R
Normalization Assignment
Consider the universal relation R = {A, B, C, D, E, F G, H I, J} and the set of functional dependencies
R = {{A, B} -> { C}, {A} ->{D, E}, {B} -> { F}, F->{G, H}, {D}->{I, J}}.
What is the key for R. Decompose R into 2NF and 3NF relations.
Note: Here, A, B, C, etc. are attributes of a relation. In other words, think of it this way, someone has asked you to create a database, but you have very little knowledge of this subject area. Since you could not really understand the attributes, you might as well use A, B, C, etc. instead of the attribute names. So, now you have to come up with a normalized database for this team.
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