Third Normal Form Example

• Customer attributes depend only on Customer ID

  • Split them into new table (Customer)
  • Remember to leave CustomerID in Rentals table.
  • We need to be able to reconnect tables.

• 3NF is sometimes easier to see if you identify primary objects at the start--then you would recognize that Customer was a separate object.

RentalForm2(TransID, RentDate, CustomerID, Phone, Name, Address, City, State, ZipCode)

Rentals(TransID, RentDate, CustomerID )

Customers(CustomerID, Phone, Name, Address, City, State, ZipCode )

前一張投影片

下一張投影片

回到第一張投影片

檢視圖形版本