Scribd
Upload
7 views2 pages

Understanding Database Normalization Types

The document outlines three types of normalization in database design, emphasizing the importance of primary keys and the need to avoid repeating groups and mixed data in columns. It also mentions breaking normalization rules as a point of discussion. The content appears to be structured in a way that suggests further elaboration on each normalization type.

Uploaded by

rola.nidal.makahleh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views2 pages

Understanding Database Normalization Types

The document outlines three types of normalization in database design, emphasizing the importance of primary keys and the need to avoid repeating groups and mixed data in columns. It also mentions breaking normalization rules as a point of discussion. The content appears to be structured in a way that suggests further elaboration on each normalization type.

Uploaded by

rola.nidal.makahleh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Example Task Adventure Works

Wednesday, July 3, 2024 9:29 AM

1. First type of normalization

1. Primary key

2. In order column
a.

3. Repeating group

b. Break normalization rules 4. Mixed between


data in same
column

2. Second type of normalization

a.

b. Break normalization rules

i.

3. Third type of normalization

a.

New Section 1 Page 1


b. Break normalization rules

Sub Product id ----------> Product Name -------------> Sub Product Name

i.

New Section 1 Page 2

You might also like