Second Normal Form Example

• Title depends only on VideoID

  • Each VideoID can have only one title

• Rent depends on VideoID

  • This statement is actually a business rule.
  • It might be different at different stores.
  • Some stores might charge a different rent for each video depending on the day (or time).

• Each non-key column depends on the whole key.

RentalLine(TransID, VideoID, Copy#, Title, Rent)

VideosRented(TransID, VideoID, Copy#)

Videos(VideoID, Title, Rent)

前一張投影片

下一張投影片

回到第一張投影片

檢視圖形版本