CREATE TABLE `pc`.`pc` (
`model` VARCHAR(5) NOT NULL,
`speed` DECIMAL(10,2) NOT NULL,
`ram` INT NOT NULL,
`hd` INT NOT NULL,
`price` INT NOT NULL,
PRIMARY KEY (`model`));
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1001', '2.66', '1024', '250', '2114');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1002', '2.10', '512', '250', '995');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1003', '1.42', '512', '80', '478');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1004', '2.80', '1024', '250', '694');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1005', '3.20', '512', '250', '630');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1006', '3.20', '1024', '320', '1049');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1007', '2.20', '1024', '200', '510');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1008', '2.20', '2048', '250', '770');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1009', '2.00', '1024', '250', '650');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1010', '2.80', '2048', '300', '770');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1011', '1.86', '2048', '160', '959');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1012', '2.80', '1024', '160', '649');
INSERT INTO `pc`.`pc` (`model`, `speed`, `ram`, `hd`, `price`) VALUES ('1013', '3.06', '512', '80', '529');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2001', '2.00', '2048', '240', '20.1', '3673');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2002', '1.73', '1024', '80', '17.0', '949');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2003', '1.80', '512', '60', '15.4', '549');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2004', '2.00', '512', '60', '13.3', '1150');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2005', '2.16', '1024', '120', '17.0', '2500');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2006', '2.00', '2048', '80', '15.4', '1700');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2007', '1.83', '1024', '120', '13.3', '1429');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2008', '1.60', '1024', '100', '15.4', '900');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2009', '1.60', '512', '80', '14.1', '680');
INSERT INTO `pc`.`laptop` (`model`, `speed`, `ram`, `hd`, `screen`, `price`) VALUES ('2010', '2.00', '2048', '160', '15.4', '2300');
CREATE TABLE `pc`.`printer` (
`model` VARCHAR(5) NOT NULL,
`color` VARCHAR(5) NOT NULL,
`type` VARCHAR(45) NOT NULL,
`price` INT NOT NULL,
PRIMARY KEY (`model`));
INSERT INTO `pc`.`printer` (`model`, `color`, `type`, `price`) VALUES ('3001', 'true', 'ink-jet', '99');
INSERT INTO `pc`.`printer` (`model`, `color`, `type`, `price`) VALUES ('3002', 'false', 'laser', '239');
INSERT INTO `pc`.`printer` (`model`, `color`, `type`, `price`) VALUES ('3003', 'true', 'laser', '899');
INSERT INTO `pc`.`printer` (`model`, `color`, `type`, `price`) VALUES ('3004', 'true', 'ink-jet', '120');
INSERT INTO `pc`.`printer` (`model`, `color`, `type`, `price`) VALUES ('3005', 'false', 'laser', '120');
INSERT INTO `pc`.`printer` (`model`, `color`, `type`, `price`) VALUES ('3006', 'true', 'ink-jet', '100');
INSERT INTO `pc`.`printer` (`model`, `color`, `type`, `price`) VALUES ('3007', 'true', 'laser', '200');
?
?
|