1/*
2REM
3REM C-all.sql
4REM
5REM Create yurttas-Bank tables.
6REM
7*/
8
9/*
10REM
11REM
12REM Branch-cre.sql
13REM
14REM
15*/
16
17CREATE TABLE Branch(branchname VARCHAR(16) NOT NULL,
18 assets INTEGER,
19 branchcity VARCHAR(16),
20 PRIMARY KEY(branchname));
21
22
23/*
24REM
25REM
26REM Customer-cre.sql
27REM
28REM
29*/
30
31CREATE TABLE Customer(customername VARCHAR(16) NOT NULL,
32 street VARCHAR(10),
33 customercity VARCHAR(16),
34 PRIMARY KEY(customername));
35
36
37/*
38REM
39REM
40REM Depositor-cre.sql
41REM
42REM
43*/
44
45CREATE TABLE Depositor(branchname VARCHAR(16) NOT NULL,
46 accountnumber INTEGER NOT NULL,
47 customername VARCHAR(16) NOT NULL,
48 balance INTEGER,
49 PRIMARY KEY(accountnumber),
50 FOREIGN KEY(branchname) REFERENCES Branch(branchname),
51 FOREIGN KEY(customername) REFERENCES Customer(customername));
52
53
54/*
55REM
56REM
57REM Borrower-cre.sql
58REM
59REM
60*/
61
62CREATE TABLE Borrower(branchname VARCHAR(16) NOT NULL,
63 loannumber INTEGER NOT NULL,
64 customername VARCHAR(16) NOT NULL,
65 amount INTEGER,
66 PRIMARY KEY(loannumber),
67 FOREIGN KEY(branchname) REFERENCES Branch(branchname),
68 FOREIGN KEY(customername) REFERENCES Customer(customername));
69
70
71/*
72REM
73REM
74REM Client-cre.sql
75REM
76REM
77*/
78
79CREATE TABLE Client(customername VARCHAR(16) NOT NULL,
80 bankername VARCHAR(16) NOT NULL,
81 PRIMARY KEY(customername),
82 FOREIGN KEY(customername) REFERENCES Customer(customername));