{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Examples of Normalization

Examples of Normalization - Examples of Normalization...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Examples of Normalization Example #1 Product # Name Mfr Mfr_HQ 1001 Walkman Sony Japan 1002 Camera Leica Germany 1003 DVD Sony Japan The functional dependencies here include Product # —> Mfr Mfr —> Mfr_HQ By transitivity we have Product # —> Mfr_HQ This simply means that for any product number, there is an associated unique headquarters. This is a transitive dependency within this table. So, the table is not in 3NF. Solution: Break the table into 2 tables as follows: Product(Product #, Name, Mfr) Company(Mfr, Mfr_HQ)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon