1/*
2REM
3REM I-all.sql
4REM
5REM Insert into yurttas-Bank database tables.
6REM
7*/
8
9/*
10REM
11REM
12REM Branch-ins.sql
13REM
14REM
15*/
16
17INSERT INTO Branch
18 VALUES('Downtown', 9000000, 'Brooklyn');
19
20INSERT INTO Branch
21 VALUES('Redwood', 2100000, 'Palo Alto');
22
23INSERT INTO Branch
24 VALUES('Perryridge', 1700000, 'Horseneck');
25
26INSERT INTO Branch
27 VALUES('Mianus', 400000, 'Horseneck');
28
29INSERT INTO Branch
30 VALUES('Round Hill', 8000000, 'Horseneck');
31
32INSERT INTO Branch
33 VALUES('Pownal', 300000, 'Bennington');
34
35INSERT INTO Branch
36 VALUES('North Town', 3700000, 'Rye');
37
38INSERT INTO Branch
39 VALUES('Brighton', 7100000, 'Brooklyn');
40
41
42/*
43REM
44REM
45REM Customer-ins.sql
46REM
47REM
48*/
49
50INSERT INTO Customer
51 VALUES('Jones', 'Main', 'Harrison');
52
53INSERT INTO Customer
54 VALUES('Smith', 'North', 'Rye');
55
56INSERT INTO Customer
57 VALUES('Hayes', 'Main', 'Harrison');
58
59INSERT INTO Customer
60 VALUES('Curry', 'North', 'Rye');
61
62INSERT INTO Customer
63 VALUES('Lindsay', 'Park', 'Pittsfield');
64
65INSERT INTO Customer
66 VALUES('Turner', 'Putnam', 'Stamford');
67
68INSERT INTO Customer
69 VALUES('Williams', 'Nassau', 'Princeton');
70
71INSERT INTO Customer
72 VALUES('Adams', 'Spring', 'Pittsfield');
73
74INSERT INTO Customer
75 VALUES('Johnson', 'Alma', 'Palo Alto');
76
77INSERT INTO Customer
78 VALUES('Glenn', 'Sand Hill', 'Woodside');
79
80INSERT INTO Customer
81 VALUES('Brooks', 'Senator', 'Brooklyn');
82
83INSERT INTO Customer
84 VALUES('Green', 'Walnut', 'Stamford');
85
86
87/*
88REM
89REM
90REM Depositor-ins.sql
91REM
92REM
93*/
94
95INSERT INTO Depositor
96 VALUES('Downtown', 101, 'Johnson', 500);
97
98INSERT INTO Depositor
99 VALUES('Mianus', 215, 'Smith', 700);
100
101INSERT INTO Depositor
102 VALUES('Perryridge', 102, 'Hayes', 400);
103
104INSERT INTO Depositor
105 VALUES('Round Hill', 305, 'Turner', 350);
106
107INSERT INTO Depositor
108 VALUES('Perryridge', 201, 'Williams', 900);
109
110INSERT INTO Depositor
111 VALUES('Redwood', 222, 'Lindsay', 700);
112
113INSERT INTO Depositor
114 VALUES('Brighton', 217, 'Green', 750);
115
116INSERT INTO Depositor
117 VALUES('Downtown', 105, 'Green', 850);
118
119
120/*
121REM
122REM
123REM Borrower-ins.sql
124REM
125REM
126*/
127
128INSERT INTO Borrower
129 VALUES('Downtown', 17, 'Jones', 1000);
130
131INSERT INTO Borrower
132 VALUES('Redwood', 23, 'Smith', 2000);
133
134INSERT INTO Borrower
135 VALUES('Perryridge', 15, 'Hayes', 1500);
136
137INSERT INTO Borrower
138 VALUES('Mianus', 93, 'Curry', 500);
139
140INSERT INTO Borrower
141 VALUES('Round Hill', 11, 'Turner', 900);
142
143INSERT INTO Borrower
144 VALUES('Pownal', 29, 'Williams', 1200);
145
146INSERT INTO Borrower
147 VALUES('North Town', 16, 'Adams', 1300);
148
149INSERT INTO Borrower
150 VALUES('Downtown', 18, 'Johnson', 2000);
151
152INSERT INTO Borrower
153 VALUES('Perryridge', 25, 'Glenn', 2500);
154
155INSERT INTO Borrower
156 VALUES('Brighton', 10, 'Brooks', 2200);
157
158
159/*
160REM
161REM
162REM Client-ins.sql
163REM
164REM
165*/
166
167INSERT INTO Client
168 VALUES('Turner', 'Johnson');
169
170INSERT INTO Client
171 VALUES('Hayes', 'Jones');
172
173INSERT INTO Client
174 VALUES('Johnson', 'Johnson');