pctest.sql

FAC analysis Sofeware

CREATE TABLE PCTest (
  PCname varchar,
  price integer,
  harddisk integer,
  CPU float,
  RAM float,
  video bigint,
  disk float,
  dosmark float,
  graphics float,
  diskmark float,
  dealer tinyint,
  directsales tinyint,
  typeCase varchar,
  typeBus varchar,
  powerSupply integer,
  powerConnectors integer,
  upgradability varchar,
  numericPUSocket varchar,
  cacheArchitecture varchar,
  cachewrite varchar,
  freeDriveSlots integer,
  internalDriveSlots integer,
  diskDrives varchar,
  hardDiskBays varchar,
  hardDiskController varchar,
  slots8bit integer,
  slots16bit integer,
  slotsEISA integer,
  slotsMCA integer,
  slotsOther integer,
  slotsLocalBus integer,
  ports varchar,
  network varchar,
  graphiccard varchar,
  DOSWIN varchar,
  software varchar,
  warranty varchar,
  service varchar,
  largeDrives integer,
  smallDrives integer,
  largeInternalDrives integer,
  smallInternalDrives integer,
  DOS varchar,
  WIN varchar
);

INSERT INTO PCTest VALUES ('ALR Flyer 32DT 4DX2/66',3962,200,16767.0,7947.0,4632,28.83,33.88,5.82,40.51,1,1,'Slimline','ISA',145,4,'Processor card','nein','Direct-mapped','wb',11,10,'1,2MB, 1,44MB',20,'Motherboard',0,3,0,0,3,0,'2,1,0','none','ISA','jj','nein','1 Jahr','9.95 $',1,1,1,0,'ja','ja');
INSERT INTO PCTest VALUES ('American Mitac TL4466',3499,380,15799.0,3685.0,1285,160.2,60.01,6.25,50.36,1,1,'Tower','EISA',302,5,'Standard socket','ja','Direct-mapped','wb',70,0,'1,44MB',16,'EISA',0,2,6,0,0,0,'Keine','none','EISA','jj','nein','1 Jahr','99 $',7,0,0,0,'ja','ja');
INSERT INTO PCTest VALUES ('American Super Computer 486X2/e66',3569,240,12371.0,8658.0,2903,32.2,35.05,7.44,44.13,1,1,'Tower','EISA',230,6,'Processor card','ja','Four-way set-associative','wt',41,40,'1,2MB, 1,44MB',34,'EISA',0,1,6,0,1,0,'Keine','none','EISA','jj','nein','2 Jahre','268 $',4,1,4,0,'ja','ja');
INSERT INTO PCTest VALUES ('Arche Legacy 486/66DX2',4498,212,15843.0,5216.0,5256,28.68,31.49,44.47,43.64,1,1,'Small-footprint','ISA',200,4,'Standard socket','ja','Direct-mapped','wb',20,10,'1,2MB, 1,44MB',22,'ISA',1,7,0,0,0,0,'Keine','none','ISA','jj','ja','2 Jahre','inklusive',2,0,1,0,'ja','ja');
INSERT INTO PCTest VALUES ('Ares 486-66DX2 VL-Bus',4350,240,16446.0,6275.0,4350,25.41,29.87,10.24,45.26,1,0,'Desktop','ISA',250,5,'Standard socket','nein','Direct-mapped','wt',21,20,'Dual',50,'Motherboard',0,8,0,0,0,2,'1,2,0','none','ISA','jj','ja','2 Jahre','inklusive',2,1,2,0,'ja','ja');
INSERT INTO PCTest VALUES ('Ariel 486DX2-66VLB',4295,520,16441.0,6275.0,7013,24.77,29.37,15.62,46.31,0,1,'Tower','ISA',300,4,'Standard socket','nein','Direct-mapped','wt',50,22,'1,2MB, 1,44MB',59,'ISA',0,8,0,0,0,2,'2,1,0','none','VESA Local Bus','jj','ja','1 Jahr','50 $',5,0,2,2,'ja','ja');
INSERT INTO PCTest VALUES ('AST Bravo 4/66d',4205,340,16213.0,6178.0,3759,32.77,35.54,4.45,41.59,1,0,'Slimline','ISA',145,4,'Standard socket','nein','Direct-mapped','wb',20,20,'1,2MB, 1,44MB',41,'Motherboard',0,4,0,0,0,0,'2,1,1','Ethernet','Motherboard','jj','nein','1 Jahr','inklusive',2,0,2,0,'ja','ja');
INSERT INTO PCTest VALUES ('ATronics ATI-486-66',3495,340,15582.0,4453.0,1732,117.06,59.99,6.82,28.22,1,1,'Small-footprint','ISA',200,4,'Standard socket','ja','Direct-mapped','wb',32,0,'1,2MB, 1,44MB',27,'ISA',1,7,0,0,1,0,'Keine','none','ISA','jj','nein','1 Jahr','99 $',3,2,0,0,'ja','ja');
INSERT INTO PCTest VALUES ('Austin 466DX2 WinStation',2990,220,16439.0,6249.0,7007,24.05,28.72,22.99,45.77,1,1,'Desktop','ISA',200,5,'Standard socket','nein','Direct-mapped','wt',30,2,'1,2MB, 1,44MB',4,'Motherboard',0,8,0,0,0,2,'2,1,0','none','VESA Local Bus','jj','ja','1 Jahr','inklusive',3,0,0,2,'ja','ja');
INSERT INTO PCTest VALUES ('Bi-Link Desktop i486DX2/66',2665,210,14556.0,4463.0,1789,29.34,30.44,8.82,40.6,0,1,'Tower','ISA',300,6,'Standard socket','nein','Direct-mapped','wb',50,21,'1,2MB, 1,44MB',42,'ISA',1,7,0,0,0,1,'Keine','none','Proprietary Local Bus','jj','nein','1 Jahr','',5,0,2,1,'ja','ja');
INSERT INTO PCTest VALUES ('BLK 486DX2/66',2995,213,17206.0,8301.0,2654,29.34,34.49,1.76,39.47,0,1,'Minitower','ISA',250,5,'Standard socket','ja','Two-way set-associative','wb',22,1,'1,2MB, 1,44MB',9,'Motherboard',0,8,0,0,0,0,'1,2,0','none','ISA','jj','nein','1 Jahr','inklusive',2,2,0,1,'ja','ja');
INSERT INTO PCTest VALUES ('Blue Star 466D2U',2949,340,14514.0,4463.0,3701,36.87,35.3,7.98,41.32,0,1,'Desktop','ISA',250,4,'Standard socket','ja','Direct-mapped','wb',21,20,'Dual',37,'ISA',0,8,0,0,1,0,'Keine','none','ISA','jj','ja','1 Jahr','59 $',2,1,2,0,'ja','ja');
INSERT INTO PCTest VALUES ('BOSS 466d',4495,245,17197.0,8301.0,3183,38.1,41.53,88.83,47.79,1,0,'Minitower','ISA',300,6,'Standard socket','ja','Four-way set-associative','wb',32,10,'1,2MB, 1,44MB',36,'ISA',1,7,0,0,0,0,'1,2,0','none','ISA','jj','nein','2 Jahre','inklusive',3,2,1,0,'ja','ja');
INSERT INTO PCTest VALUES ('Broadax 486DX2-66',2260,212,14292.0,3920.0,2644,28.0,28.8,2.41,34.78,1,1,'Desktop','ISA',200,5,'Standard socket','nein','Direct-mapped','wb',30,2,'1,2MB, 1,44MB',5,'ISA',2,6,0,0,0,0,'Keine','none','ISA','jj','nein','1 Jahr','80 $',3,0,0,2,'ja','ja');
INSERT INTO PCTest VALUES ('C