SNF, Second Normal Form
Remove part key dependencies
Are any data elements dependent on a part of the
FNF
key?
- Create a new
table for these data elements,
avobe the old one.
Draw a connection between the old and the new table, a
many to one
relation.
- Mark the relation at the many side with a red capital
I
meaning
Identifying .
- The new table will get a smaller
key.
Create new sticky pads for the new key.
Keep the key in the old table.
- Move the dependent data to the new table.
- Repeat these steps for the other part-key dependencies.
Link table
Note: In this old table there is no data anymore.
Yet, the combination of keys is meaningful.
Such a link table makes a many to many relation possible:
- One reader can have many subscriptions to various newspapers.
- One newspaper has many readers with a subscription.
This is quite a reasonable
database
design, with
three tables
and two
one-to many
relations.
Using the
keys
you can find related information in the other
tables.
- Subscription has the tax number.
- With the tax number you can read the correct
row
in "Reader".
- In the row of Reader there is oa the house address and the house number.
|
|