--------------------------------------------------------------- -- Homework ... more employees, parts, and customers --------------------------------------------------------------- insert into employees values (1003,'Pink',67226,'01-SEP-96'); insert into employees values (1004,'Black',67226,'01-SEP-96'); insert into employees values (1005,'Blue',54444,'01-SEP-97'); insert into employees values (1006,'Green',67226,'01-SEP-98'); insert into employees values (1007,'White',66002,'01-SEP-99'); insert into employees values (1008,'Orange',61111,'01-SEP-00'); insert into employees values (1009,'Red',67226,'01-SEP-01'); insert into employees values (1010,'Tan',61111,'01-SEP-02'); insert into parts values (10510,'Land Before Time 5',60,19.99,20); insert into parts values (10511,'Land Before Time 6',60,19.99,20); insert into parts values (10512,'Land Before Time 7',60,19.99,20); insert into parts values (10513,'Land Before Time 8',60,19.99,20); insert into parts values (10514,'Land Before Time 9',60,19.99,20); insert into parts values (10515,'Land Before Time 10',60,19.99,20); insert into parts values (10516,'Land Before Time 11',60,19.99,20); insert into parts values (10517,'Land Before Time 12',60,19.99,20); insert into parts values (10518,'Land Before Time 13',60,19.99,20); insert into parts values (10519,'Land Before Time 14',60,19.99,20); insert into parts values (10520,'Land Before Time 15',60,19.99,20); insert into parts values (10521,'Land Before Time 16',60,19.99,20); insert into parts values (10522,'Land Before Time 17',60,19.99,20); insert into parts values (10523,'Land Before Time 18',60,19.99,20); insert into parts values (10524,'Land Before Time 19',60,19.99,20); insert into parts values (10525,'Land Before Time 20',60,19.99,20); insert into parts values (10526,'Land Before Time 21',60,19.99,20); insert into parts values (10527,'Land Before Time 22',60,19.99,20); insert into parts values (10528,'Land Before Time 23',60,19.99,20); insert into parts values (10529,'Land Before Time 24',60,19.99,20); insert into parts values (10530,'Land Before Time 25',60,19.99,20); insert into parts values (10531,'Land Before Time 26',60,19.99,20); insert into parts values (10532,'Land Before Time 27',60,19.99,20); insert into parts values (10533,'Land Before Time 28',60,19.99,20); insert into parts values (10534,'Land Before Time 29',60,19.99,20); insert into parts values (10535,'Land Before Time 30',60,19.99,20); insert into parts values (10536,'Land Before Time 31',60,19.99,20); insert into parts values (10537,'Land Before Time 32',60,19.99,20); insert into parts values (10538,'Land Before Time 33',60,19.99,20); insert into parts values (10539,'Land Before Time 34',60,19.99,20); insert into parts values (10540,'Land Before Time 35',60,19.99,20); insert into parts values (10541,'Land Before Time 36',60,19.99,20); insert into parts values (10542,'Land Before Time 37',60,19.99,20); insert into parts values (10543,'Land Before Time 38',60,19.99,20); insert into parts values (10544,'Land Before Time 39',60,19.99,20); insert into parts values (10545,'Land Before Time 40',60,19.99,20); insert into parts values (10546,'Land Before Time 41',60,19.99,20); insert into parts values (10547,'Land Before Time 42',60,19.99,20); insert into parts values (10548,'Land Before Time 43',60,19.99,20); insert into parts values (10549,'Land Before Time 44',60,19.99,20); insert into parts values (10550,'Land Before Time 45',60,19.99,20); insert into parts values (10551,'Land Before Time 46',60,19.99,20); insert into parts values (10552,'Land Before Time 47',60,19.99,20); insert into parts values (10553,'Land Before Time 48',60,19.99,20); insert into parts values (10554,'Land Before Time 49',60,19.99,20); insert into parts values (10555,'Land Before Time 50',60,19.99,20); insert into parts values (10556,'Land Before Time 51',60,19.99,20); insert into parts values (10557,'Land Before Time 52',60,19.99,20); insert into parts values (10558,'Land Before Time 53',60,19.99,20); insert into customers values (4000,'Ned','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4001,'George','111 Inwood St.',61111,'316-111-1234'); insert into customers values (4002,'Mary','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4003,'Sam','111 Inwood St.',50302,'316-111-1234'); insert into customers values (4004,'Sue','111 Inwood St.',50302,'316-111-1234'); insert into customers values (4005,'Arny','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4006,'Greg','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4007,'Bill','111 Inwood St.',54444,'316-111-1234'); insert into customers values (4008,'Will','111 Inwood St.',54444,'316-111-1234'); insert into customers values (4009,'Tom','111 Inwood St.',61111,'316-111-1234'); insert into customers values (4010,'Jack','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4011,'Karen','111 Inwood St.',54444,'316-111-1234'); insert into customers values (4012,'Rose','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4013,'Rich','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4014,'Ivan','111 Inwood St.',50302,'316-111-1234'); insert into customers values (4015,'Terry','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4016,'Frank','111 Inwood St.',61111,'316-111-1234'); insert into customers values (4017,'Bernie','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4018,'Len','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4019,'Harry','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4020,'Helen','111 Inwood St.',54444,'316-111-1234'); insert into customers values (4021,'Pat','111 Inwood St.',54444,'316-111-1234'); insert into customers values (4022,'Candice','111 Inwood St.',50302,'316-111-1234'); insert into customers values (4023,'Alex','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4024,'Alen','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4025,'Vicki','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4026,'Henry','111 Inwood St.',67226,'316-111-1234'); insert into customers values (4027,'Arthur','111 Inwood St.',50302,'316-111-1234');