zipcodes(67226,'Wichita').
zipcodes(60606,'Fort Dodge').
zipcodes(50302,'Kansas City').
zipcodes(54444,'Columbia').
zipcodes(66002,'Liberal').
zipcodes(61111,'Fort Hays').

employees(1000,'Jones',67226,'12-DEC-95').
employees(1001,'Smith',60606,'01-JAN-92').
employees(1002,'Brown',50302,'01-SEP-94').

parts(10506,'Land Before Time I',200,19.99,20).
parts(10507,'Land Before Time II',156,19.99,20).
parts(10508,'Land Before Time III',190,19.99,20). 
parts(10509,'Land Before Time IV',60,19.99,20).
parts(10601,'Sleeping Beauty',300,24.99,20).
parts(10701,'When Harry Met Sally',120,19.99,30).
parts(10800,'Dirty Harry',140,74.99,30).
parts(10900,'Dr. Zhivago',100,54.99,30).

customers(1111,'Charles','123 Main St.',67226,'316-636-5555').
customers(2222,'Bertram','237 Ash Avenue',67226,'316-689-5555').
customers(3333,'Barbara','111 Inwood St.',60606,'316-111-1234').
customers(4444,'Thomas','222 Inwood St.',60606,'316-111-1235').
customers(5555,'Johnny','333 Inwood St.',60606,'316-111-1236').
customers(6666,'Timothy','333 Woodland St.',50302,'316-111-1237').

orders(1020,1111,1000,'10-DEC-94','12-DEC-94').
orders(1021,1111,1000,'12-JAN-95','15-JAN-95').
orders(1022,2222,1001,'13-FEB-95','20-FEB-95').
orders(1023,3333,1000,'20-JUN-97',null).
orders(1024,3333,1001,'21-JUN-97',null).
orders(1025,3333,1002,'22-JUN-97',null).

odetails(1020,10506,1).
odetails(1020,10507,1).
odetails(1020,10508,2).
odetails(1020,10509,3).
odetails(1021,10601,4).
odetails(1021,10800,4).
odetails(1021,10701,4).
odetails(1022,10601,1).
odetails(1022,10701,1).
odetails(1023,10800,1).
odetails(1023,10900,1).
odetails(1024,10506,1).
odetails(1024,10900,1).
odetails(1024,10507,1).
odetails(1025,10900,1).
odetails(1025,10507,1).