CUSTOMER (Customer ID, Last Name, First Name, Address, Email Address, Encrypted Password, City, State, ZIP, Phone) EMPLOYEE (Employee ID, Last Name, First Name, Phone, Email) VENDOR (Vendor ID, Company Name, Contact Last Name, Contact First Name, Address, City, State, ZIP, Phone, Fax, Email) ITEM (Item ID, Item Description, Purchase Date, Item Cost, Item Price, Vendor ID) SALE (Sale ID, Customer ID, Employee ID, Sale Date, Sub Total, Tax, Total) SALE_ITEM (Sale ID, Sale Item ID, Item ID, Item Price)
Customer ID in SALE must exist in Customer ID in CUSTOMER Employee ID in SALE must exist in Employee ID in EMPLOYEE Sale ID in SALE_ITEM must exist in Sale ID in SALE Item ID in SALE_ITEM must exist in Item ID in ITEM Vendor ID in ITEM must exist in Vendor ID in VENDOR
Customer ID Start at 1 Increment by 1
Employee ID Start at 1 Increment by 1
Vendor ID Start at 1 Increment by 1
Item ID Start at 1 Increment by 1
Sale ID Start at 1 Increment by 1