|
DataMuseum.dkPresents historical artifacts from the history of: Regnecentalen RC-900 |
This is an automatic "excavation" of a thematic subset of
See our Wiki for more about Regnecentalen RC-900 Excavated with: AutoArchaeologist - Free & Open Source Software. |
top - metrics - download
Length: 18653 (0x48dd)
Types: TextFile
Notes: UNIX file
Names: »US.BLD«
└─⟦c93a30372⟧ Bits:30004169/disk3.imd Uniplex II+ V.6 release 1.0 (dansk)
└─⟦c93a30372⟧ UNIX Filesystem
└─⟦this⟧ »up/new/usr/UAP/demo/US.BLD«
create database us_sales
database us_sales
grant connect to public
create table branch -
(BNo char(3),Branch_name char(12), -
Address1 char(18),Address2 char(18),Address3 char(18))
create table sales_force -
(First_name char(11),Surname char(11),BNo char(3),Salary decimal(6), -
PC decimal(2),Total_Sal decimal(6),License char(8))
create table car_type -
(Car_id char(6),Make char(12),Model char(10),Type char(8),Ins char(3), -
Grade char(5))
create table cars -
(License char(8),Car_id char(6),Cost decimal(5),Repairs decimal(4), -
Mileage decimal(6), Petrol decimal(6),Yearmonth char(4))
create table year_end -
(Surname char(11),Yr_1984 decimal(6),Yr_1985 decimal(6),Yr_1986 decimal(6),Yr_1987 decimal(6))
insert into branch values -
('01','L.A','1772 Scott Ave.','Newgreen','CA 90232')
insert into branch values -
('02','Chicago','2100 Lime Ave.','Burlington','IL 08762')
insert into branch values -
('03','Dallas','2239 Devray St.','Suite 709JG310','TX 75211')
insert into branch values -
('04','Washington','4100 West Rd.','Cambridge','WA 32871')
insert into branch values -
('05','New York','Lincoln House','1219 Broadview','NY 34449')
insert into sales_force values -
('John','Baker','03',14000,5,20000,'007 BND')
insert into sales_force values -
('Robert','Dodd','02',16000,4.5,20000,'013 ASD')
insert into sales_force values -
('Tom','Brown','04',15000,4.5,2000,'090 EGC')
insert into sales_force values -
('Jack','Hill','01',18000,3,3000,'105 RTY')
insert into sales_force values -
('Stephen','Hillston','05',14000,5,2000,'039 EEQ')
insert into sales_force values -
('Philip','Marshall','02',15000,4.5,2000,'981 HHF')
insert into sales_force values -
('David','Lawson','04',13500,4,3000,'012 BTY')
insert into sales_force values -
('Andrew','Wilson','03',14000,6,2000,'320 OWU')
insert into sales_force values -
('Dawn','Michaels','05',12000,4.5,2000,'008 RBD')
insert into sales_force values -
('Dominic','Williams','03',17000,4,3000,'029 FFV')
insert into sales_force values -
('Jennifer','Dobbs','01',18000,5,3000,'088 FFD')
insert into sales_force values -
('Stuart','Harper','04',13000,5,2000,'031 HGH')
insert into sales_force values -
('Joe','Stevenson','03',14000,4.5,2000,'092 HRE')
insert into sales_force values -
('Kevin','Durham','05',14000,5,2000,'094 CCD')
insert into sales_force values -
('Elizabeth','Kingsley','01',17000,5,3000,'071 GQZ')
insert into sales_force values -
('Maria','Ellis','02',14000,4.5,3000,'133 VHB')
insert into sales_force values -
('Peter','Simmons','04',13000,4.5,2000,'290 GHM')
insert into sales_force values -
('James','Osborn','05',18000,5,4000,'056 PLT')
insert into sales_force values -
('Martin','Brownlow','02',15000,4.5,2000,'644 OMJ')
insert into sales_force values -
('Kelvin','Wallace','01',16000,4,2000,'356 XWO')
insert into sales_force values -
('Sarah','Heywood','01',17000,5,3000,'196 MUL')
insert into sales_force values -
('Suzanne','Oxendale','05',14000,5,4000,'539 NDP')
insert into sales_force values -
('Jackie','Barry','04',15000,4,3000,'647 DNM')
insert into sales_force values -
('Steve','Phoenix','02',16000,5,2000,'285 SRO')
insert into sales_force values -
('Sue','Taylor','03',12000,5,4000,'096 XBH')
insert into sales_force values -
('Jenny','Clendon','04',20000,5,2000,'032 UBH')
insert into sales_force values -
('Sarah','Withers','03',12000,4.5,4000,'045 VHJ')
insert into sales_force values -
('Jonathan','Green','05',18000,6,2000,'021 DKX')
insert into sales_force values -
('Derek','Richards','03',22000,4.5,3000,'335 OLK')
insert into sales_force values -
('Sally','Row','02',14000,4,2000,'711 SDP')
insert into sales_force values -
('Nigel','Westal','04',14000,5,4000,'349 BNK')
insert into sales_force values -
('Brian','Richardson','05',20000,5,2000,'234 RMJ')
insert into sales_force values -
('Kathleen','Jacobson','04',18000,5,4000,'882 TWJ')
insert into sales_force values -
('Simon','Bridey','02',18000,4.5,3000,'513 KNM')
insert into sales_force values -
('Nick','Harmen','05',22000,5,5000,'566 HNM')
insert into sales_force values -
('David','Harris','04',14000,4,2000,'983 DXD')
insert into sales_force values -
('Ann','Franklin','03',16000,6,2000,'569 KJH')
insert into sales_force values -
('Timothy','Smith','04',14000,4,2000,'531 YTP')
insert into sales_force values -
('Alison','Common','02',16000,4.5,2000,'359 PHN')
insert into sales_force values -
('Allen','Fetch','04',14000,5,3000,'965 PUT')
insert into sales_force values -
('Jocasta','Greek','02',16000,5,4000,'713 PGI')
insert into sales_force values -
('David','Jones','05',20000,6,4000,'132 DIP')
insert into sales_force values -
('Neil','Robson','05',22000,5,2000,'392 LDS')
insert into sales_force values -
('Gregory','Smith','04',18000,5,3000,'052 XCI')
insert into sales_force values -
('Robert','Smails','03',16000,4,2000,'567 ORK')
insert into sales_force values -
('Laura','Oakley','02',14000,5,4000,'193 PUD')
insert into sales_force values -
('Anthony','Johnson','05',24000,4,2000,'972 MJD')
insert into sales_force values -
('Julian','Phelps','02',20000,6,4000,'791 HFP')
insert into sales_force values -
('William','Morris','03',18000,5,3000,'014 PGS')
insert into sales_force values -
('Desmond','Morris','05',14000,4,4000,'459 RMP')
insert into sales_force values -
('Sidney','Queensland','04',20000,4,2000,'991 GUT')
insert into sales_force values -
('Alvin','Moon','03',18000,5,3000,'937 TLU')
insert into sales_force values -
('Lambro','Smith','02',17000,5,2000,'194 TNC')
insert into sales_force values -
('Keith','Stone','03',12000,5,4000,'321 POG')
insert into sales_force values -
('Eric','Blair','02',17000,4.5,3000,'498 DAW')
insert into sales_force values -
('Mark','Almond','04',14000,6,4000,'927 HIL')
insert into sales_force values -
('Indra','Patel','03',16000,5,2000,'239 LPE')
insert into sales_force values -
('David','Ball','02',18000,4.5,3000,'125 HUR')
insert into sales_force values -
('Winston','Bronson','05',15000,4,2000,'890 DLA')
insert into sales_force values -
('Sonia','Svenson','05',20000,5,4000,'892 GTF')
insert into sales_force values -
('Robert','Browning','02',13000,4,4000,'945 JTW')
insert into sales_force values -
('Charles','Windsor','05',14000,5,3000,'406 MEG')
insert into sales_force values -
('Harvey','Stevenson','05',22000,4,2000,'117 WGO')
insert into sales_force values -
('Zara','Dickens','02',15000,4,3000,'203 DUR')
insert into sales_force values -
('Richard','Milgo','03',16000,5,2000,'984 FEQ')
insert into sales_force values -
('Stephen','Wonder','04',18000,6,4000,'123 GAP')
insert into sales_force values -
('Roy','Dearman','05',14000,4.5,2000,'530 WIG')
insert into sales_force values -
('Diana','Mason','02',16000,4,3000,'333 IPS')
insert into sales_force values -
('Nicholas','Rutherford','03',16000,4,2000,'555 POP')
insert into sales_force values -
('Lucy','Barrow','04',15000,4,4000,'938 TIP')
insert into sales_force values -
('Frank','Littlefield','04',14000,4,2000,'315 GUR')
insert into sales_force values -
('Anthony','McDowell','05',16000,4.5,2000,'129 BUN')
insert into sales_force values -
('Robert','Rosenburg','05',15500,5,2000,'004 HOP')
insert into sales_force values -
('Kevin','Turvey','03',16000,4,2000,'444 PIP')
insert into sales_force values -
('Yei May','Tokhai','02',15600,5,2000,'123 PDP')
insert into sales_force values -
('Simon','Tolman','04',14000,5,2000,'378 CNM')
insert into sales_force values -
('Aaron','Walters','05',16000,5,2000,'392 SOX')
insert into sales_force values -
('Zak','Peters','05',18000,5,4000,'120 TEL')
insert into sales_force values -
('Venessa','Lipman','04',14000,4.5,2000,'349 PID')
insert into sales_force values -
('Donna','Wimpole','02',14000,5,2000,'829 FOG')
insert into sales_force values -
('Wiliam','Beckett','03',17800,5,3000,'395 COP')
insert into sales_force values -
('Alfred','Grundon','02',14000,4,2000,'439 RUG')
insert into sales_force values -
('Roger','Redrup','02',15000,4,4000,'123 JKW')
insert into sales_force values -
('Christopher','Whitehead','05',18000,5,4000,'385 JHW')
insert into sales_force values -
('George','Horton','04',15000,5,3000,'322 XMO')
insert into sales_force values -
('Henry','Simms','03',20000,4,2000,'385 IFN')
insert into sales_force values -
('Olive','Brumwick','02',14000,5,4000,'939 PVS')
insert into sales_force values -
('Simone','Rocha','05',22000,6,6000,'929 HUR')
insert into sales_force values -
('Sally','Donaldson','02',20000,5,4000,'660 GBH')
insert into sales_force values -
('Norman','George','03',16000,4,2000,'984 MUC')
insert into sales_force values -
('Steve','Hurst','05',18000,5,2000,'948 CMJ')
insert into sales_force values -
('Ann','Gunner','04',15000,5,4000,'982 LPR')
insert into sales_force values -
('Beverly','Boyce','03',16000,5,4000,'878 JHJ')
insert into sales_force values -
('Michael','Calderwood','02',17500,5,3000,'789 LPP')
insert into sales_force values -
('Julie','Holland','05',18000,5.5,4000,'193 CON')
insert into sales_force values -
('karen','Dicken','04',20000,5,3000,'213 DHU')
insert into sales_force values -
('Pam','Wilkinson','04',16000,4.5,4000,'865 ANV')
insert into sales_force values -
('Clive','Magnuson','02',18000,5.5,3000,'988 XMU')
insert into sales_force values -
('Linval','Davis','04',15000,5,2000,'494 WAR')
insert into sales_force values -
('Dennis','Menis','02',24000,5,4000,'810 DAP')
insert into cars values -
('007 BND','001',6337.5,2017.5,32045,3434.745,'7808')
insert into cars values -
('013 ASD','007',8250,892.5,26096,2996.325,'7908')
insert into cars values -
('090 EGC','012',9375,532.5,20789,2333.94,'8108')
insert into cars values -
('105 RTY','014',10125,850.5,29876,4496.97,'7908')
insert into cars values -
('039 EEQ','008',8250,300,17678,2333.85,'8108')
insert into cars values -
('981 HHF','010',9150,765,20056,2517.33,'8108')
insert into cars values -
('012 BTY','003',7500,232.5,25667,2517,'8201')
insert into cars values -
('320 OWU','020',12750,1800,45983,4650.12,'8101')
insert into cars values -
('008 RBD','002',6750,3010.5,56007,4184.97,'7808')
insert into cars values -
('029 FFV','019',12187,981,25097,3150.135,'8101')
insert into cars values -
('088 FFD','017',10875,2100,45021,4496.01,'8009')
insert into cars values -
('031 HGH','001',6337.5,3004.5,57056,3313.635,'7906')
insert into cars values -
('092 HRE','009',8625,297,24065,2531.34,'8208')
insert into cars values -
('094 CCD','011',9375,103.5,27582,2512.14,'8210')
insert into cars values -
('071 GQZ','008',8250,201,29432,3686.88,'8210')
insert into cars values -
('133 VHB','013',9862.5,249,30754,5322.975,'8112')
insert into cars values -
('290 GHM','017',10875,67.5,945,1019.985,'8308')
insert into cars values -
('056 PLT','015',10200,358.5,25000,2017.5,'8108')
insert into cars values -
('644 OMJ','007',8250,651,32095,2335.38,'8306')
insert into cars values -
('356 XWO','014',10125,688.5,35701,3450.975,'8111')
insert into cars values -
('196 MUL','001',6337.5,1614,59993,4357.14,'8005')
insert into cars values -
('539 NDP','005',7837.5,1504.5,45983,3461.01,'8103')
insert into cars values -
('647 DNM','002',6750,1017,49892,3195,'7909')
insert into cars values -
('285 SRO','003',7500,1506,59678,4018.425,'8104')
insert into cars values -
('096 XBH','004',7687.5,3679.5,45321,3550.5,'8107')
insert into cars values -
('032 UBH','006',7837.5,283.5,39032,2979.135,'8109')
insert into cars values -
('045 VHJ','010',9150,37.5,499,20.985,'8309')
insert into cars values -
('021 DKX','016',10200,358.5,27099,2819.985,'8212')
insert into cars values -
('335 OLK','018',11250,400.5,34056,3203.175,'8201')
insert into cars values -
('711 SDP','020',12750,37.5,9001,185.985,'8401')
insert into cars values -
('349 BNK','019',12187,450,45000,3148.56,'8203')
insert into cars values -
('234 RMJ','012',9375,357,37609,2998.635,'8307')
insert into cars values -
('882 TWJ','009',8625,313.5,23009,1830.03,'8306')
insert into cars values -
('513 KNM','011',9375,534,23497,2534.835,'8312')
insert into cars values -
('566 HNM','008',8250,898.5,54397,3597.015,'8009')
insert into cars values -
('983 DXD','013',9862.5,847.5,34974,2864.01,'8109')
insert into cars values -
('569 KJH','017',10875,450,44397,3014.01,'8302')
insert into cars values -
('531 YTP','015',10200,75,3009,909.135,'8401')
insert into cars values -
('359 PHN','002',6750,2098.5,67004,5998.605,'8401')
insert into cars values -
('965 PUT','004',7687.5,1165.5,45074,3008.505,'8112')
insert into cars values -
('713 PGI','008',8250,745.5,45698,3297,'8012')
insert into cars values -
('132 DIP','020',12750,1800,45029,5986.38,'8306')
insert into cars values -
('392 LDS','012',9375,1447.5,26750,2034.825,'8204')
insert into cars values -
('052 XCI','009',8625,1950,39038,2668.5,'8009')
insert into cars values -
('567 ORK','013',9862.5,1332,34008,2985,'8301')
insert into cars values -
('193 PUD','017',10875,1950,45009,3601.26,'8111')
insert into cars values -
('972 MJD','003',7500,735,23009,1486.095,'8307')
insert into cars values -
('791 HFP','011',9375,594,30583,3049.485,'8109')
insert into cars values -
('014 PGS','006',7837.5,511.5,10748,1489.545,'8401')
insert into cars values -
('459 RMP','010',9150,492,15083,1584.675,'8312')
insert into cars values -
('991 GUT','016',10200,687,29747,2857.395,'8112')
insert into cars values -
('937 TLU','018',11250,2022,23958,2413.545,'8208')
insert into cars values -
('194 TNC','015',10200,87,6708,148.53,'8308')
insert into cars values -
('321 POG','007',8250,1957.5,45082,2697.045,'8006')
insert into cars values -
('498 DAW','014',10125,2112,34068,2941.26,'8112')
insert into cars values -
('927 HIL','001',6337.5,3450,69927,4622.73,'7908')
insert into cars values -
('239 LPE','005',7837.5,1506,45839,2535.72,'8012')
insert into cars values -
('125 HUR','002',6750,1363.5,56039,2836.17,'8101')
insert into cars values -
('890 DLA','004',7687.5,4500,57093,3450.975,'8107')
insert into cars values -
('892 GTF','008',8625,2250,56084,3149.745,'8106')
insert into cars values -
('945 JTW','020',12750,675,30957,2995.56,'8208')
insert into cars values -
('406 MEG','019',12187,723,29068,2923.245,'8209')
insert into cars values -
('117 WGO','013',9862.5,357,23847,1949.235,'8209')
insert into cars values -
('203 DUR','017',10875,1873.5,34059,1959.585,'8109')
insert into cars values -
('984 FEQ','003',7500,906,45098,3458.895,'8305')
insert into cars values -
('123 GAP','011',9375,688.5,35498,2994.135,'8304')
insert into cars values -
('530 WIG','006',7837.5,675,11004,2114.085,'8401')
insert into cars values -
('333 IPS','010',9150,2515.5,45968,3459.87,'8007')
insert into cars values -
('555 POP','016',10200,1935,34987,2099.985,'8209')
insert into cars values -
('938 TIP','018',11250,450,18593,1514.22,'8312')
insert into cars values -
('315 GUR','015',10200,522,3598,449.07,'8212')
insert into cars values -
('129 BUN','007',8250,687,32498,2985.72,'8301')
insert into cars values -
('004 HOP','014',10125,688.5,12304,1491,'8312')
insert into cars values -
('444 PIP','001',6337.5,1957.5,44059,2263.545,'8012')
insert into cars values -
('123 PDP','005',7837.5,576,34953,3072,'8207')
insert into cars values -
('378 CNM','004',7687.5,592.5,12308,1356.045,'8409')
insert into cars values -
('392 SOX','002',6750,1812,50483,4305.06,'7906')
insert into cars values -
('120 TEL','008',8250,1437,34983,1942.5,'8108')
insert into cars values -
('349 PID','020',12750,517.5,11305,1049.775,'8209')
insert into cars values -
('829 FOG','019',12187,58.5,205,18.75,'8308')
insert into cars values -
('395 COP','009',8625,1942.5,23495,1289.985,'8109')
insert into cars values -
('439 RUG','013',9862.5,358.5,24984,2534.235,'8307')
insert into cars values -
('123 JKW','017',10875,1939.5,39584,2389.56,'8306')
insert into cars values -
('385 JHW','003',7500,51,239,35.91,'8411')
insert into cars values -
('322 XMO','011',9375,2242.5,21238,2553.045,'8206')
insert into cars values -
('385 IFN','006',7837.5,679.5,34059,1948.95,'8209')
insert into cars values -
('939 PVS','010',9150,2880,30590,4485.045,'8307')
insert into cars values -
('929 HUR','016',10200,523.5,19023,2259.045,'8307')
insert into cars values -
('660 GBH','018',11250,1806,30598,2856.06,'8109')
insert into cars values -
('984 MUC','015',10200,1813.5,30496,2986.23,'8110')
insert into cars values -
('948 CMJ','007',8250,2907,45079,3101.895,'8011')
insert into cars values -
('982 LPR','014',10125,1515,23899,2113.5,'8305')
insert into cars values -
('878 JHJ','005',7837.5,358.5,994,37.35,'8312')
insert into cars values -
('789 LPP','001',6337.5,3450,59028,4531.53,'8102')
insert into cars values -
('193 CON','004',7687.5,493.5,23098,2113.53,'8306')
insert into cars values -
('213 DHU','008',8250,1860,40593,3031.515,'8204')
insert into cars values -
('865 ANV','020',12750,3463.5,45093,3613.5,'8203')
insert into cars values -
('988 XMU','012',9375,37.5,1244,58.545,'8401')
insert into cars values -
('494 WAR','002',6337.5,3598.5,67029,5413.5,'7909')
insert into cars values -
('810 DAP','012',9375,1806,45439,3462.045,'8107')
insert into car_type values -
('001','Dodge','Daytona','1.3 L','1','A')
insert into car_type values -
('002','Dodge','Daytona','1.3GL','1','A')
insert into car_type values -
('003','Cadillac','Cimarron','1.3','2','A')
insert into car_type values -
('004','Dodge','Daytona','1.3 L','2','B')
insert into car_type values -
('005','Cadillac','Cimarron','1.3L','3','B')
insert into car_type values -
('006','Cadillac','Cimarron','1.6','3','B')
insert into car_type values -
('007','Cadillac','Cimarron','1.6 Ghia','4','C')
insert into car_type values -
('008','Dodge','Daytona','1.6L','4','C')
insert into car_type values -
('009','Dodge','Daytona','GTE 1.8','4','D')
insert into car_type values -
('010','Cadillac','Cimarron','1.6','5','D')
insert into car_type values -
('011','Dodge','Daytona','1.6','5','D')
insert into car_type values -
('012','Cadillac','Cimarron','1.6L','5','D')
insert into car_type values -
('013','Cadillac','Cimarron','2.0 L','6','E')
insert into car_type values -
('014','Dodge','Daytona','2.0 L','6','E')
insert into car_type values -
('015','Dodge','Daytona','GLS','6','E')
insert into car_type values -
('016','Cadillac','Cimarron','2.0 GL','6','E')
insert into car_type values -
('017','Cadillac','Cimarron','2.0 S','6','E')
insert into car_type values -
('018','Cadillac','Cimarron','2.8 Ghia','7','F')
insert into car_type values -
('019','Dodge','Daytona','2.00','7','F')
insert into car_type values -
('020','Dodge','Daytona','3.00','7','F')
insert into year_end values ('Hill',130,140,145,155)
insert into year_end values ('Dobbs',220,225,230,255)
insert into year_end values ('Green',130,195,225,295)
insert into year_end values ('Smith',150,165,175,180)
insert into year_end values ('Ellis',135,140,120,140)