CREATE TABLE Produkt(
    modell INTEGER NOT NULL,
    hersteller VARCHAR(30),
    typ VARCHAR(30),
    preis FLOAT,
    PRIMARY KEY(modell)
);

CREATE TABLE PC(
    modell INTEGER NOT NULL,
    speed INTEGER NOT NULL,
    ram INTEGER NOT NULL,
    hd FLOAT,
    cd INTEGER NOT NULL,
    PRIMARY KEY(modell),
    FOREIGN KEY(modell) REFERENCES Produkt(modell)
);
CREATE TABLE Laptop(
    modell INTEGER NOT NULL,
    speed INTEGER NOT NULL,
    ram INTEGER NOT NULL,
    hd FLOAT,
    bildschirm FLOAT,
    PRIMARY KEY(modell),
    FOREIGN KEY(modell) REFERENCES Produkt(modell)
);

CREATE TABLE Drucker(
    modell INTEGER NOT NULL,
    farbe INTEGER NOT NULL,
    typ VARCHAR(30),
    PRIMARY KEY(modell),
    FOREIGN KEY(modell) REFERENCES Produkt(modell)
);

INSERT INTO Produkt (modell, hersteller, typ, preis)
    VALUES (1100,'C', 'PC', 2499);

INSERT INTO PC (modell, speed, ram, hd, cd)
    VALUES (1100, 240, 32, 2.5, 12);

DELETE FROM PC WHERE hd<2;

UPDATE Produkt SET hersteller='A' WHERE hersteller= 'B' ;

DELETE FROM Produkt WHERE typ='PC'
    AND modell NOT IN(SELECT modell FROM PC);

UPDATE PC SET ram = 2*ram+ 1;