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

 1/*
 2REM
 3REM c-all.sql
 4REM
 5REM Create Company-B database tables.
 6REM
 7*/
 8
 9/*
10REM
11REM
12REM Employee-cre.sql
13REM
14REM
15*/
16
17CREATE TABLE Employee(employeename VARCHAR(16) NOT NULL,
18                      street VARCHAR(24),
19                      city VARCHAR(16),
20          PRIMARY KEY(employeename));
21
22/*
23REM
24REM
25REM Company-cre.sql
26REM
27REM
28*/
29
30CREATE TABLE Company(companyname VARCHAR(24) NOT NULL,
31                     city VARCHAR(16),
32         PRIMARY KEY(companyname));
33
34/*
35REM
36REM
37REM Works-cre.sql
38REM
39REM
40*/
41
42CREATE TABLE Works(employeename VARCHAR(16) NOT NULL,
43                   companyname VARCHAR(24) NOT NULL,
44                   salary INTEGER,
45       PRIMARY KEY(employeename, companyname),
46       FOREIGN KEY(employeename) REFERENCES Employee(employeename),
47       FOREIGN KEY(companyname) REFERENCES Company(companyname));
48
49/*
50REM
51REM
52REM Manages-cre.sql
53REM
54REM
55*/
56
57CREATE TABLE Manages(employeename VARCHAR(16) NOT NULL,
58                     managername VARCHAR(16),
59         PRIMARY KEY(employeename),
60         FOREIGN KEY(employeename) REFERENCES Employee(employeename),
61         FOREIGN KEY(managername) REFERENCES Employee(employeename));