ARTIKEL NORMALIZATION
N or m al i z at i o n I I :
• 3 rd norm al f orm .
• M ultiv alued dep endencies.
• 4 th norm al f orm .
• So m e o bserv atio ns o n norm alizatio n.
Case st udi es i n dat abase desi g n:
• I nternet b o o kstore.
• TV series database.
C o nsider the relatio n w ith schem a Bookings(title,theater,city)
Under certain assum ptio ns, it has the FD th ea ter → c i ty , but th ea ter is
no t a sup erkey. The B C NF deco m p o sitio n y ields relatio n schem a s
Bookings1(theater,city) and Bookings2(theater,title).
DOWNLOAD ARTIKELNYA
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment