The schema for the sample database used as examples in class is given below:
people(ssn, fname, lname, city, state)
agents(ssn, salary, photo)
autos(vin, make, year, agent_ssn)
owns(ssn, vin)
accidents(vin, accident_date, damages, driver_ssn)
Details of the table structures are given here.