First page Back Continue Last page Image

Normalization

1 place and only 1 place for each piece of Data

Customer
Key	Field	Type
PK	CNumb
	CName
	Cad_Hn
	Cad_Cty
	Cad_St
	Cad_Zip

Address
Key	Field	Type
PK	ANumb
FK	CNumb
	Cad_Hn
	Cad_Cty
	Cad_St
	Cad_Zip

What happens if the customer has more than 1 address ?