ARTIKEL NORMALIZATION - Amazing Indonesia

Latest

Sunday, 23 October 2011

ARTIKEL NORMALIZATION

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

No comments:

Post a Comment