drop table if EXISTS Product CASCADE; drop table if EXISTS PC CASCADE; drop table if EXISTS Laptop CASCADE; drop table if EXISTS Printer CASCADE; CREATE TABLE Product ( manufacturer VARCHAR, model VARCHAR PRIMARY KEY, type VARCHAR ); CREATE TABLE PC ( model varchar PRIMARY KEY, speed real, ram real, hd real, screen real, price real, FOREIGN KEY(model) REFERENCES Product(model) ); CREATE TABLE laptop ( model varchar primary key, speed real, ram real, hd real, screen real, price real, FOREIGN KEY(model) REFERENCES Product(model) ); create table printer ( model VARCHAR primary key, color BOOLEAN, type VARCHAR, price real, FOREIGN KEY(model) REFERENCES Product(model) ); INSERT INTO Product VALUES ('hp', 'HP Spectre x360', 'laptop'), ('hp', 'HP Pavilion x360', 'laptop'), ('acer', 'Acer Nitro 5 AN517-41', 'laptop'), ('acer', 'Acer Aspire 5', 'laptop'), ('apple', 'MacBook Pro 13', 'laptop'), ('hp', 'HP ENVY Desktop TE01-1150xt', 'pc'), ('apple', 'Mac Mini', 'pc'), ('asus', 'ASUS Mini PC', 'pc'), ('hp', 'HP Pavilion Gaming TG01', 'pc'), ('hp', 'HP Laser 137fnw', 'printer'), ('epson', 'Epson Ecotank ET-3850', 'printer'), ('hp', 'HP Neverstop laser', 'printer'), ('hp', 'HP OfficeJet 200', 'printer'); INSERT INTO PC VALUES ('HP ENVY Desktop TE01-1150xt', 4.8, 32, 256, 24, 449.99), ('Mac Mini', 3.0, 8, 512, Null, 1279.99), ('ASUS Mini PC', 3.0, 8, 256, Null, 749.99), ('HP Pavilion Gaming TG01', 3.8, 16, 1024, Null, 1499.99); INSERT INTO laptop VALUES ('HP Spectre x360', 3.4, 16, 512, 15, 2999.99), ('HP Pavilion x360', 2.7, 8, 512, 14, 599.99), ('Acer Nitro 5 AN517-41', 3.2, 32, 1024, 14, 2499.99), ('Acer Aspire 5', 2.8, 16, 256, 15, 799.99), ('MacBook Pro 13', 2.9, 8, 256, 13, 1499.99); INSERT INTO printer VALUES ('HP Laser 137fnw', false, 'laser', 229.99), ('Epson Ecotank ET-3850', true, 'inc', 499.99), ('HP Neverstop laser', false, 'laser', 309.99), ('HP OfficeJet 200', true, 'inc', 339.99);