Yurttas/PL/DBL/mssql/F/01/PC/C-all.sql

 1/*
 2REM
 3REM c-all.sql
 4REM
 5REM Create PC database tables.
 6REM
 7*/
 8
 9/*
10REM
11REM
12REM Product-cre.sql
13REM
14REM
15*/
16
17CREATE TABLE Product(maker VARCHAR(6) NOT NULL,
18                     model VARCHAR(6) NOT NULL,
19                     type VARCHAR(8) NOT NULL,
20         PRIMARY KEY(model));
21
22
23/*
24REM
25REM
26REM PC-cre.sql
27REM
28REM
29*/
30
31CREATE TABLE PC(model VARCHAR(6) NOT NULL,
32                speed INTEGER NOT NULL,
33                ram INTEGER NOT NULL,
34                hd FLOAT NOT NULL,
35                cd VARCHAR(4) NOT NULL,
36                price INTEGER NOT NULL,
37   PRIMARY KEY (model));
38
39
40/*
41REM
42REM
43REM Laptop-cre.sql
44REM
45REM
46*/
47
48CREATE TABLE Laptop(model VARCHAR(6) NOT NULL,
49                    speed INTEGER NOT NULL,
50                    ram INTEGER NOT NULL,
51                    hd FLOAT NOT NULL,
52                    screen FLOAT NOT NULL,
53                    price INTEGER NOT NULL,
54        PRIMARY KEY(model));
55
56
57/*
58REM
59REM
60REM Printer-cre.sql
61REM
62REM
63*/
64
65CREATE TABLE Printer(model VARCHAR(6) NOT NULL,
66                     color VARCHAR(6) NOT NULL,
67                     type VARCHAR(8) NOT NULL,
68                     price INTEGER NOT NULL,
69         PRIMARY KEY(model));