Sunday, February 19, 2012

index cluster

Can u explain it to me pls?

2/ also what s 4th normal form ?

Thanks

hi,
i think u want tp know abt clustered index....its the way of physically arranging data on the disk for faster access of data...its arranged in the form of B-tree structure, where the leaf nodes contain the data (best way to explain in real life is how the data is arranged in telephone directory)...its explained well in sql server books online...

ao for 4th normal form...i'll assume that u know till 3rd normal... in 3rd normal form we try to keep only the fully functional fields rematin in the stable...still we may be left with multivalued dependencies...in the 4th NF we try to make these multivalued dependencies to functional dependency...
multivalued dependencies are of the type a-> b ->c , so we need to make them a->b and a->c
this is a gud link for normalization..
http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/normalisation/1nf.html|||just a normal index then, right

No comments:

Post a Comment