Video Rental View - Solution

The following is the solution to the specs for the first view in Joe's videos.

Legend

This legend is a guide to reading and interpreting the table listings under 0NF through 3NF.

• TableName: - Table names will be bolded and end with a colon. (e.g.: **TableName:**)
• (Column, Names) - Column names for a table will be enclosed in (rounded parenthesis).
• PrimaryKeyFields - Primary key fields will be bold and inside a box. (e.g.: <b class="pk">PrimaryKeyFields</b>)
• ForeignKeyFields - Foreign key fields will be a wavy underline in italic and green. (e.g.: <u class="fk">ForeignKeyFields</u>)
• Repeating Groups - Groups of repeating fields will be identified in 0NF stage, and will be enclosed in orange curly braces. (e.g.: <b class="rg">{Repeating, Group, Fields}</b>)

0NF

VideoRental: (TransactionId, Date, CustomerId, FirstName, LastName, Phone, StreetAddress, City, Province, PostalCode, VideoId, CopyNumber, Title, ReturnDate, RentalCharge, CurrentRentalCharge, Subtotal, GST, Total)

1NF

VideoRental: (TransactionId, Date, CustomerId, FirstName, LastName, Phone, StreetAddress, City, Province, PostalCode, Subtotal, GST, Total)

RentalDetail: (TransactionId, VideoId, CopyNumber, Title, ReturnDate, RentalCharge, CurrentRentalCharge)

2NF

Note: To Be Revised

RentalDetail: (TransactionId, VideoId, CopyNumber, ReturnDate, RentalCharge)

Video: (VideoId, Title, CurrentRentalCharge)

3NF

VideoRental: (TransactionId, Date, CustomerId, Subtotal, GST, Total)

Customer: (CustomerId, FirstName, LastName, Phone, StreetAddress, City, Province, PostalCode)