drop table employee; create table employee (empnum int, empname char (24), empphone int); insert into employee values (124, 'Alvarez, Ramon', 1212); insert into employee values (567, 'Feinstein, Betty', 8716); insert into employee values (611, 'Dinh, Melissa', 2963); drop table computer; create table computer (compid char (8), mfgname char (16), mfgmodel char (8), proctype char (8)); insert into computer values ('B121', 'Bantam', '48X', '486DX'); insert into computer values ('B221', 'Bantam', '48D', '486DX2'); insert into computer values ('C007', 'Cody', 'D1', '486DX'); insert into computer values ('M759', 'Lemmin', 'GRL', '486SX'); drop table pc; create table pc (tagnum int, compid char(8), empnum int, location char (16)); insert into pc values (32808, 'M759', 611, 'Accounting'); insert into pc values (37691, 'B121', 124, 'Sales'); insert into pc values (57772, 'C007', 567, 'Info Systems'); insert into pc values (59836, 'B221', 124, 'Home'); insert into pc values (77740, 'M759', 567, 'Home'); drop table package; create table package (packid char (8), packname char (24), packver decimal (3,2) , packtype char (16), packcost decimal (5,2)); insert into package values ('AC01', 'Boise Accounting', 3.00, 'Accounting', 725.83); insert into package values ('DB32', 'Manta', 1.50, 'Database', 380.00); insert into package values ('DB33', 'Manta', 2.10, 'Database', 430.18); insert into package values ('SS11', 'Limitless View', 5.30, 'Spreadsheet', 217.95); insert into package values ('WP08', 'Words and More', 2.00, 'Word Processing', 185.00); insert into package values ('WP09', 'Freeware Processing', 4.27, 'Word Processing', 30.00); drop table software; create table software (packid char (8), tagnum int, instdate char (8), softcost decimal (5,2)); insert into software values ('AC01', 32808, '09/13/95', 754.95); insert into software values ('DB32', 32808, '12/03/95', 380.00); insert into software values ('DB32', 37691, '06/15/95', 380.00); insert into software values ('DB33', 57772, '05/27/95', 412.77); insert into software values ('WP08', 32808, '01/12/96', 185.00); insert into software values ('WP08', 37691, '06/15/95', 227.50); insert into software values ('WP08', 57772, '05/27/95', 170.24); insert into software values ('WP09', 59836, '10/30/95', 35.00); insert into software values ('WP09', 77740, '05/27/95', 35.00);