Second Normal Form Example (Data)

TransID VideoID Copy#

1 1 2

1 6 3

2 2 1

2 6 1

2 8 1

3 4 1

3 9 1

3 15 1

4 3 1

4 8 1

4 13 1

4 17 1

VideoID Title Rent

1 2001: A Space Odyssey $1.50

2 Apocalypse Now $2.00

3 Blues Brothers $2.00

4 Boy And His Dog $2.50

5 Brother From Another Planet $2.00

6 Clockwork Orange $1.50

7 Gods Must Be Crazy $2.00

8 Hopscotch $1.50

VideosRented(TransID, VideoID, Copy#)

Videos(VideoID, Title, Rent)

RentalForm2(TransID, RentDate, CustomerID, Phone,

Name, Address, City, State, ZipCode)

(Unchanged)

前一張投影片

下一張投影片

回到第一張投影片

檢視圖形版本