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).