SQL Tables

Customers
CustomerID	Int	Primary Key
CustomerName	VarChar
CustomerStreet	VarChar
CustomerCity	VarChar
CustomerZip	VarChar
CustomerPhone	VarChar

Titles
TitleID	Int	PrimaryKey
Title	VarChar
Year	Int
Price	Float
URL	VarChar
Image	BLOB

Tapes
TapeID	Int	PrimaryKey
TitleID	Int	ForeignKey Titles
Type	VarChar

Orders
OrderNumber	Int	PrimaryKey
CustomerID	Int	ForeignKey Customers
TapeID	Int	ForeignKey Tapes
DueDate	Date
Status	Char
Rating	Integer