1/*
2REM
3REM i-all
4REM
5REM Insert into Company-B database tables.
6REM
7*/
8
9/*
10REM
11REM
12REM Employee-ins.sql
13REM
14REM
15*/
16
17INSERT INTO Employee
18 VALUES('Jeremy', '123-C Front', 'Austin');
19
20INSERT INTO Employee
21 VALUES('Charles', '55 Main', 'Austin');
22
23INSERT INTO Employee
24 VALUES('Jamie', '55 Main', 'Austin');
25
26INSERT INTO Employee
27 VALUES('Casey', '251 Main', 'Austin');
28
29INSERT INTO Employee
30 VALUES('Thomas', '158 Main', 'Houston');
31
32INSERT INTO Employee
33 VALUES('Anthony', '37 North Star', 'Houston');
34
35INSERT INTO Employee
36 VALUES('Benjamin', '414 Union', 'Houston');
37
38INSERT INTO Employee
39 VALUES('Sara', '816 Back', 'Dallas');
40
41INSERT INTO Employee
42 VALUES('David', '816 Back', 'Dallas');
43
44INSERT INTO Employee
45 VALUES('Michael', '816 Back', 'Dallas');
46
47INSERT INTO Employee
48 VALUES('Jennifer', '20 Second', 'Dallas');
49
50INSERT INTO Employee
51 VALUES('Laura', '20 Second', 'Dallas');
52
53/*
54REM
55REM
56REM Company-ins.sql
57REM
58REM
59*/
60
61INSERT INTO Company
62 VALUES('First Bank Corporation', 'Bryan');
63
64INSERT INTO Company
65 VALUES('Small Bank Corporation', 'Houston');
66
67INSERT INTO Company
68 VALUES('Minor Bank Corporation', 'Dallas');
69
70INSERT INTO Company
71 VALUES('Major Bank Corporation', 'Dallas');
72
73/*
74REM
75REM
76REM Works-ins.sql
77REM
78REM
79*/
80
81INSERT INTO Works
82 VALUES('Jeremy', 'First Bank Corporation', 100000);
83
84INSERT INTO Works
85 VALUES('Charles', 'First Bank Corporation', 40000);
86
87INSERT INTO Works
88 VALUES('Jamie', 'First Bank Corporation', 40000);
89
90INSERT INTO Works
91 VALUES('Casey', 'First Bank Corporation', 30000);
92
93INSERT INTO Works
94 VALUES('Thomas', 'Small Bank Corporation', 60000);
95
96INSERT INTO Works
97 VALUES('Anthony', 'Small Bank Corporation', 60000);
98
99INSERT INTO Works
100 VALUES('Benjamin', 'Small Bank Corporation', 80000);
101
102INSERT INTO Works
103 VALUES('Sara', 'Minor Bank Corporation', 50000);
104
105INSERT INTO Works
106 VALUES('David', 'Minor Bank Corporation', 40000);
107
108INSERT INTO Works
109 VALUES('Michael', 'Major Bank Corporation', 30000);
110
111INSERT INTO Works
112 VALUES('Jennifer', 'Major Bank Corporation', 90000);
113
114/*
115REM
116REM
117REM Manages-ins.sql
118REM
119REM
120*/
121
122INSERT INTO Manages
123 VALUES('Jeremy', NULL);
124
125INSERT INTO Manages
126 VALUES('Charles', 'Jeremy');
127
128INSERT INTO Manages
129 VALUES('Jamie', 'Jeremy');
130
131INSERT INTO Manages
132 VALUES('Casey', 'Jeremy');
133
134INSERT INTO Manages
135 VALUES('Thomas', 'Benjamin');
136
137INSERT INTO Manages
138 VALUES('Anthony', 'Benjamin');
139
140INSERT INTO Manages
141 VALUES('Benjamin', NULL);
142
143INSERT INTO Manages
144 VALUES('Sara', NULL);
145
146INSERT INTO Manages
147 VALUES('David', 'Sara');
148
149INSERT INTO Manages
150 VALUES('Michael', 'Jennifer');
151
152INSERT INTO Manages
153 VALUES('Jennifer', NULL);