Eliminate Redundant Data

The following two tables demonstrate second normal form:

Students: Student# Advisor Adv-Room

------------------------------

1022 Jones 412

4123 Smith 216

Registration: Student# Class#

------------------

1022 101-07

1022 143-01

1022 159-02

4123 201-01

4123 211-02

4123 214-01

Previous slide

Next slide

Back to first slide

View graphic version