Scribd
Upload
9 views1 page

Database Normalization Principles Guide

The document discusses the principles of database normalization, specifically focusing on transforming tables into third normal form (3NF). It presents two tables that violate normalization rules and prompts the reader to identify issues and illustrate the normalization process. Additionally, it asks for the identification of primary, alternate, and foreign keys in the normalized tables.

Uploaded by

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

Database Normalization Principles Guide

The document discusses the principles of database normalization, specifically focusing on transforming tables into third normal form (3NF). It presents two tables that violate normalization rules and prompts the reader to identify issues and illustrate the normalization process. Additionally, it asks for the identification of primary, alternate, and foreign keys in the normalized tables.

Uploaded by

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

ITU_07305 - Database Principles

Normalization

1. Examine the table shown below.

branchNo branchAddress telNos


B001 8 Jefferson Way, Portland, OR 97201 503-555-3618, 503-555-2727, 503-555-6534
B002 City Center Plaza, Seattle, WA 98122 206-555-6756, 206-555-8836
B003 14 – 8th Avenue, New York, NY 212-371-3000
10012
B004 16 – 14th Avenue, Seattle, WA 98128 206-555-3131, 206-555-4112

a) Why is this table not in 1NF?


b) (Describe and illustrate the process of normalizing the data shown in this table to
third normal form (3NF).
c) Identify the primary, alternate and foreign keys in your 3NF relations.

2. Examine the table shown below.

branc branchAddress telNo mgrStaffNo name


hNo
B001 8 Jefferson Way, Portland, OR 97201 503-555-3618 S1500 Tom Daniels

B002 City Center Plaza, Seattle, WA 98122 206-555-6756 S0010 Mary Martinez

B003 14 – 8th Avenue, New York, NY 10012 212-371-3000 S0145 Art Peters

B004 16 – 14th Avenue, Seattle, WA 98128 206-555-3131 S2250 Sally Stern

a) Why is this table not in 3NF?


b) Describe and illustrate the process of normalizing the data shown in this table to third
normal form (3NF).
c) Identify the primary, (alternate) and foreign keys in your 3NF relations.

You might also like