BigHit Video Schema
Customer(acctID, lName, fName, street, city, st, zip, balance)
OtherUsers(acctID, name)
Reservation(acctID, VID, dateReserved)
Rental(acctID, VID, dtRent, dtDue, cost)
PrevRental(acctID, VID, dtRent, dtRet, cost)

VideoTape(VID, dtAcq, movID, storeID)
Movie(movID, title, genre, length, rating)

PurchaseOrder(POID, supplierID, date, total)
PODetail(POID, movID, qty, price)
Supplier(supplierID, name, street, city, st)

Employee(ssn, lName, fName)
HourlyEmployee(ssn, hourlyRate)
SalariedEmployee(ssn, weeklyRate, vacLvHrs, sickLvHrs)
TimeCard(ssn, date, stTime, endTime, storeID, paid)
PayStatement(ssn, hourlyRate, numHours, amtPaid, dtPaid)
WorksIn(ssn, storeID)
Store(storeID, street, city, st, zip, manager)