Database Normalization Excercise

jojojojo · March 25, 2021, 9:57am

I have just learn about Database Normalization but I don’t really got it, example this exercise, can you help me, Thank youuuu <3

Consider the following functional dependencies
a,b -> c,d e,g,h -> f,j
a,c -> b,d p,q -> r,s
e,f,g -> h,i s -> t
f,g -> j q -> u
g,h -> i
Which of the following best describes the relation R(e,f,g,h,i,j)?
a. R is in First Normal Form
b. R is in Second Normal Form
c. R is in Third Normal Form
d. R is in Boyce Codd Normal Form

noname00 · March 26, 2021, 5:46am

You should read this first:
https://daynhauhoc.com/faq

@jojojojo you also should read your textbook carefully, and attempt to solve this problem first. This problem’s quite basic and should not take longer than few hour to solve.
If you have any specific question relating this problem, please come back here and raise another topic.