Wrong/Incomplete information in certification books??

Sumit · Guest

Hey Guys,

I am preparing for MCSD certification and referring to Certification book by
microsoft. But there are instances in book where information is incorrect or
incomplete. So should I follow the book in that case??

eg:
here's what book specifies as criteria for first normal form. Three Criterias:

• Tables must be two-dimensional and have data organized as columns and
rows. Entities specified in the logical data model are transformed into
database tables represented in a two-dimensional table, similar to a
spreadsheet.
• Each cell must contain one value.
• Each column must have a single meaning. For example, you cannot have a
dual-purpose column such as Order Date/Delivery Date.

It doesnt talk about Repeating Groups....and that's what 1NF is all about???
any suggestions???

Thanks

Chris Mullins [MVP - C#] · Guest

A quick read via Google says that's a pretty good definition of 1st Normal
Form.

I know most databases that people deal with are in 3rd Normal Form. Once in
a while, we'll go deeper than that and end up in 4th normal form.

http://databases.about.com/od/specificproducts/a/firstnormalform.htm
http://databases.about.com/od/specificproducts/a/2nf.htm
http://databases.about.com/od/specificproducts/a/3nf.htm

--
Chris Mullins

"Sumit" <Sumit@discussions.microsoft.com> wrote in message
news:E073A5BC-F349-47EF-97DF-1F2485B9F4E8@microsoft.com...