«

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

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/specif...normalform.htm
http://databases.about.com/od/specif...ucts/a/2nf.htm
http://databases.about.com/od/specif...ucts/a/3nf.htm

--
Chris Mullins

"Sumit" <> wrote in message
news:E073A5BC-F349-47EF-97DF-...
> 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
>