TkWu3TMT

1DROP TABLE IF EXISTS Location;
2DROP TABLE IF EXISTS SandS;
3DROP TABLE IF EXISTS Crime;
4DROP TABLE IF EXISTS Witness;
5DROP TABLE IF EXISTS Criminal;
6DROP TABLE IF EXISTS Officer;
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28CREATE TABLE Criminal
29(
30 Criminal_ID VARCHAR(11) UNIQUE NOT NULL,
31 Criminal_F_Name VARCHAR(20) NOT NULL,
32 Criminal_L_Name VARCHAR(20) NOT NULL,
33 Criminal_DOB VARCHAR(20) NOT NULL,
34 Criminal_Address VARCHAR(30) NOT NULL,
35 Suspect_Ethnicity VARCHAR(30) NOT NULL,
36 Suspect_Gender CHAR (3) DEFAULT 'N/A' ,
37 PRIMARY KEY(Criminal_ID)
38 
39);
40
41CREATE TABLE Officer
42(
43 Officer_ID VARCHAR(11)  UNIQUE NOT NULL,
44 Officer_F_Name VARCHAR(20) NOT NULL,
45 Officer_L_Name VARCHAR(20)NOT NULL,
46 Officer_DOB VARCHAR(9) NOT NULL,
47 Assigned_County VARCHAR(15) NOT NULL,
48 Officer_Ethnicity VARCHAR(15) NOT NULL,
49 Officer_Gender CHAR(3) DEFAULT 'N/A' ,
50 PRIMARY KEY(Officer_ID)
51 
52);
53
54
55CREATE TABLE Witness
56(
57 Witness_ID VARCHAR(11)  UNIQUE NOT NULL,
58 Witness_Name VARCHAR(50) NOT NULL,
59 Witness_Contact_Details VARCHAR(11) NOT NULL,
60 Witness_Gender VARCHAR(25)
61 
62);
63 
64
65 
66
67 
68CREATE TABLE SandS
69(
70 s_and_s_ID VARCHAR(11) UNIQUE NOT NULL,
71 Type_Of_Search VARCHAR(8)NOT NULL,
72 Date_of_Search VARCHAR(11)NOT NULL,
73 Legislation VARCHAR(20)NOT NULL,
74 Outcome_Type VARCHAR(25)NOT NULL,
75 Removal_Of_Basic_Clothing VARCHAR(150),
76 Officer_ID VARCHAR(25)NOT NULL,
77 PRIMARY KEY(s_and_s_ID),
78 FOREIGN KEY (Officer_ID) REFERENCES Officer(Officer_ID)
79 
80);
81
82CREATE TABLE Crime
83(
84 Crime_ID VARCHAR(11) UNIQUE NOT NULL,
85 Officer_ID VARCHAR(11) NOT NULL,
86 Criminal_ID VARCHAR(11) UNIQUE Null,
87 Type_Of_Crime VARCHAR(25) NOT NULL,
88 Age_Range VARCHAR(25) NOT NULL,
89 County_Reported_In VARCHAR(8) NOT NULL,
90 Month_Committed VARCHAR(10) NOT NULL,
91 Witness_ID VARCHAR(11) NOT NULL,
92 Location VARCHAR(30) NOT NULL,
93 Fall_Within_County VARCHAR(15) NOT NULL,
94 Outcome_Of_Search VARCHAR(30)NOT NULL,
95 PRIMARY KEY(Crime_ID),
96 FOREIGN KEY (Officer_ID) REFERENCES Officer(Officer_ID),
97 FOREIGN KEY (Witness_ID) REFERENCES Witness(Witness_ID),
98 FOREIGN KEY (Criminal_ID) REFERENCES Criminal(Criminal_ID)
99 
100
101 );
102 
103CREATE TABLE Location
104(
105 LSAO_Code VARCHAR(20) DEFAULT 'No Location entered' NULL,
106 LSAO_Name VARCHAR(20) DEFAULT 'No Location entered' NULL,
107 Longitude VARCHAR(20) DEFAULT 'No Location entered' NOT NULL,
108 Latitude VARCHAR(20) DEFAULT 'No Location entered' NOT NULL,
109 Crime_ID VARCHAR(11) NOT NULL,
110 PRIMARY KEY(LSAO_Code),
111 FOREIGN KEY (Crime_ID) 
112 REFERENCES Crime(Crime_ID)
113 ON DELETE NO ACTION
114 ON UPDATE CASCADE
115);
116
117
118 
119 
120 
121 
122 
123 
124 
125 
126 
127 
128 
129 
130 
131 
132INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
133VALUES ('a0000000001','Tom','  Erichsen', 'CHECK', '105 crim st WN9 9DF', 'WHITE BRITISH', 'M');
134INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
135VALUES ('a0000000002','Tim','  Eddie', 'CHECK', '10 crimson st WN7 9RF', 'WHITE BRITISH', 'M');
136INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
137VALUES ('00000000003','Jim','Doodson', 'CHECK', '181 Enstone  WN8 6AS', 'WHITE BRITISH', 'M');
138INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
139VALUES ('00000000004','phil','Davies', 'CHECK', '1 Innocent st WN5 7LF', 'BRITISH ASIAN', 'M');
140INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
141VALUES ('00000000005','Adam','Johnson', 'CHECK', '22 truscot RD WN4 0WR', 'WHITE AMERICAN', 'M');
142INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
143VALUES ('00000000006','Meg','Parkinson', 'CHECK', '89 Apple Pie st AP9 7PF', 'MIXED', 'F');
144INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
145VALUES ('00000000007','Dan','Parker', 'CHECK', '174 Milk st WN9 9DF', 'WHITE BRITISH', 'M');
146INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
147VALUES ('00000000008','conceula','  Jones', 'CHECK', '36 candle AVE WP7 2LF', 'MIXED', 'F');
148INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
149VALUES ('00000000009','Julie','  Applebea', 'CHECK', '10 litchfield AVE SP7 B54', 'WHITE BRITISH', 'F');
150INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
151VALUES ('00000000010','Fiona','  Chuckles', 'CHECK', '65 River AVE SU8 B54', 'British Indian', 'F');
152INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
153VALUES ('00000000011','Arthur','Johnson', 'CHECK', '22 truscot RD WN4 0WR', 'WHITE AMERICAN', 'M');
154INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
155VALUES ('00000000012','Mildred','Johnson', 'CHECK', '89 Apple Pie st AP9 7PF', 'MIXED', 'F');
156INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
157VALUES ('00000000013','Alex','Smith', 'CHECK', '174 Milk st WN9 9DF', 'WHITE BRITISH', 'M');
158INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
159VALUES ('00000000014','Chloe','Davies', 'CHECK', '36 Boog AVE LP7 NN3', 'MIXED', 'F');
160INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
161VALUES ('00000000015','Ben','Anderson', 'CHECK', '10 Tiger AVE N7D B54', 'WHITE BRITISH', 'M');
162INSERT INTO Criminal (Criminal_ID, Criminal_F_Name, Criminal_L_Name, Criminal_DOB, Criminal_Address, Suspect_Ethnicity, Suspect_Gender )
163VALUES ('00000000016','Louise','Pique', 'CHECK', '65 swan AVE SU8 B54', 'British Indian', 'F');
164 
165 
166 
167 
168 
169 
170INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
171VALUES ('0000000001','Louise','Pique', 'CHECK', 'Lancashire', 'British Indian', 'F');
172INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
173VALUES ('00000000001','Tom','  Erichsen', 'CHECK', 'Lancashire', 'WHITE BRITISH', 'M');
174INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
175VALUES ('00000000002','Tim','  Eddie', 'CHECK', 'Lancashire', 'WHITE BRITISH', 'M');
176INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
177VALUES ('00000000003','Jim','Doodson', 'CHECK', 'Greater Manchester', 'WHITE BRITISH', 'M');
178INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
179VALUES ('00000000004','phil','Davies', 'CHECK', 'Lancashire', 'BRITISH ASIAN', 'M');
180INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
181VALUES ('00000000005','Adam','Johnson', 'CHECK', 'Lancashire', 'WHITE AMERICAN', 'M');
182INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
183VALUES ('00000000006','Meg','Parkinson', 'CHECK', 'Lancashire', 'MIXED', 'F');
184INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
185VALUES ('00000000007','Dan','Parker', 'CHECK', 'Lancashire', 'WHITE BRITISH', 'M');
186INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
187VALUES ('00000000008','conceula','  Jones', 'CHECK', 'Lancashire', 'MIXED', 'F');
188INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
189VALUES ('00000000009','Julie','  Applebea', 'CHECK', 'Lancashire', 'WHITE BRITISH', 'F');
190INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
191VALUES ('00000000010','Fiona','  Chuckles', 'CHECK', 'Lancashire', 'British Indian', 'F');
192INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
193VALUES ('00000000011','Arthur','Johnson', 'CHECK', 'Greater Manchester', 'WHITE AMERICAN', 'M');
194INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
195VALUES ('00000000012','Mildred','Johnson', 'CHECK', 'Greater Manchester', 'MIXED', 'F');
196INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
197VALUES ('00000000013','Alex','Smith', 'CHECK', 'Lancashire', 'WHITE BRITISH', 'M');
198INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
199VALUES ('00000000014','Chloe','Davies', 'CHECK', 'Lancashire', 'MIXED', 'F');
200INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
201VALUES ('00000000015','Ben','Anderson', 'CHECK', 'Lancashire', 'WHITE BRITISH', 'M');
202INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
203VALUES ('00000000016','Louise','Pique', 'CHECK', 'Lancashire', 'British Indian', 'F');
204INSERT INTO Officer (Officer_ID, Officer_F_Name, Officer_L_Name, Officer_DOB, Assigned_County, Officer_Ethnicity, Officer_Gender )
205VALUES ('00000000017','Louise','Pique', 'CHECK', 'Lancashire', 'British Indian', 'F');
206 
207INSERT INTO Crime (Crime_ID, Officer_ID, Criminal_ID, Type_Of_Crime, Outcome_Of_Search, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
208VALUES ('00000000001','00000000015',' 00000000001','Anti-social behaviour','Suspect charged', '14-18', 'Lancashire', '07/17', '','Lancashire');
209INSERT INTO Crime (Crime_ID, Officer_ID, Type_Of_Crime, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
210VALUES ('00000000002','00000000012',' 00000000002','Public order','Suspect charged', '14-18', 'Lancashire', '07/17', '','Lancashire');
211INSERT INTO Crime (Crime_ID, Officer_ID, Type_Of_Crime, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
212VALUES ('00000000003','00000000011',' 00000000005','Anti-social behaviour','Suspect charged', '14-18', 'Lancashire', '07/17', '','Lancashire');
213INSERT INTO Crime (Crime_ID, Officer_ID, Type_Of_Crime, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
214VALUES ('00000000004','00000000001',' 00000000004','Vehicle crime','Suspect charged', '14-18', 'Lancashire', '08/16', '','Lancashire');
215INSERT INTO Crime (Crime_ID, Officer_ID, Type_Of_Crime, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
216VALUES ('00000000004','00000000001',' 00000000007','Vehicle crime', 'Suspect charged', '14-18', 'Lancashire', '08/16', '','Lancashire');
217INSERT INTO Crime (Crime_ID, Officer_ID, Type_Of_Crime, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
218VALUES ('00000000006','00000000006',' 00000000003','Anti-social behaviour', 'Suspect charged', '14-18', 'Lancashire', '07/17', '','Lancashire');
219INSERT INTO Crime (Crime_ID, Officer_ID, Type_Of_Crime, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
220VALUES ('00000000007','00000000008',' 00000000011','Burglary', 'Suspect charged','14-18', 'Lancashire', '07/17', '','Lancashire');
221INSERT INTO Crime (Crime_ID, Officer_ID, Type_Of_Crime, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
222VALUES ('00000000008','00000000012',' 00000000012','Anti-social behaviour','Suspect charged', '14-18', 'Lancashire', '07/17', '','Lancashire');
223INSERT INTO Crime (Crime_ID, Officer_ID, Type_Of_Crime, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
224VALUES ('00000000009','00000000013',' 00000000015','Public order','Suspect charged', '14-18', 'Lancashire', '07/17', '','Lancashire');
225INSERT INTO Crime (Crime_ID, Officer_ID, Type_Of_Crime, Age_Range, County_Reported_In, Month_Committed, Location, Fall_Within_County )
226VALUES ('00000000010','00000000002',' 00000000008','Burglary', 'Suspect charged', '14-18', 'Lancashire', '07/17', '','Lancashire');
227 
228 
229 
230INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
231VALUES ('00000000001','Deaken Janice','07452365987', 'F');
232INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
233VALUES ('00000000002','Dodgson James','0745645878546', 'M');
234INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
235VALUES ('00000000003','Davies Bradley','07659874589', 'M');
236INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
237VALUES ('00000000004','Brown David','07456985654', 'M');
238INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
239VALUES ('00000000005','Joshua Jones','07458798645', 'M');
240INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
241VALUES ('00000000006','Joshua Norris','07456989878', 'M');
242INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
243VALUES ('00000000007','Blackmore Lewis','07012456987', 'M');
244INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
245VALUES ('00000000008','Kelly Brandon','07456989513', 'M');
246INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
247VALUES ('00000000009','Newcomb Steven','07121147895', 'M');
248INSERT INTO Witness (Witness_ID, Witness_Name, Witness_Contact_Details, Witness_Gender )
249VALUES ('00000000010','Dodgson Susan','07636669855', 'M');
250 
251 
252INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation, Outcome_Type,  Removal_Of_Basic_Clothing, Officer_ID )
253VALUES ('00000000001','Person search', 'CHECK','Misuse of Drugs Act 1971 (section 23)','Nothing found - no further action','No', '00000000001' );
254INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation, Outcome_Type, Removal_Of_Basic_Clothing )
255VALUES ('00000000002','Person and Vehicle search', 'CHECK','Misuse of Drugs Act 1971 (section 23)','Suspect arrested','No', '00000000002' );
256INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation, Outcome_Type, Removal_Of_Basic_Clothing )
257VALUES ('00000000003','Person search', 'CHECK','Police and Criminal Evidence Act 1984 (section 1)','Suspect arrested','No' , '00000000003' );
258INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation, Outcome_Type, Removal_Of_Basic_Clothing )
259VALUES ('00000000004','Person search', 'CHECK','Misuse of Drugs Act 1971 (section 23)','Suspect arrested','No' ,'00000000001');
260INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation, Outcome_Type, Removal_Of_Basic_Clothing )
261VALUES ('00000000005','Person and Vehicle search', 'CHECK','Misuse of Drugs Act 1971 (section 23)','Nothing found - no further action','No' ,'00000000007' );
262INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation, Outcome_Type, Removal_Of_Basic_Clothing )
263VALUES ('00000000006','Person search', 'CHECK','Misuse of Drugs Act 1971 (section 23)','Suspect arrested','No' , '00000000004');
264INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation,Outcome_Type, Removal_Of_Basic_Clothing )
265VALUES ('00000000007','Person search', 'CHECK','Misuse of Drugs Act 1971 (section 23)','Nothing found - no further action','No' ,'00000000008' );
266INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation, Outcome_Type, Removal_Of_Basic_Clothing )
267VALUES ('00000000008','Person search', 'CHECK','Misuse of Drugs Act 1971 (section 23)','Suspect arrested','No' , '00000000011');
268INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation, Outcome_Type, Removal_Of_Basic_Clothing )
269VALUES ('00000000009','Person and Vehicle search', 'CHECK','Misuse of Drugs Act 1971 (section 23)','Suspect arrested','No' ,'00000000010');
270INSERT INTO SandS (S_And_S_ID, Type_Of_Search, Date_Of_Search, Legislation, Outcome_Type, Removal_Of_Basic_Clothing )
271VALUES ('00000000010','Person search', 'CHECK','Misuse of Drugs Act 1971 (section 23)','Local resolution','No', '00000000009' );
272CREATE TABLE SandS
273(
274 s_and_s_ID VARCHAR(11) UNIQUE NOT NULL,
275 Type_Of_Search VARCHAR(8)NOT NULL,
276 Date_of_Search VARCHAR(11)NOT NULL,
277 Legislation VARCHAR(20)NOT NULL,
278 Removal_Of_Basic_Clothing VARCHAR(150),
279 Officer_ID VARCHAR(25)NOT NULL,
280 PRIMARY KEY(s_and_s_ID),
281 FOREIGN KEY (Officer_ID) REFERENCES Officer(Officer_ID)
282 
283);
284
285 
286 
287 
288 
289 
290INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
291VALUES ('E01025182','Pendle 009B', '-2.21414','53.83815', '00000000001' );
292INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
293VALUES ('E01025185','Pendle 013A', '-2.233226','53.835292', '00000000007' );
294INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
295VALUES ('','', '','', '00000000010' );
296INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
297VALUES ('E01024909','Burnley 010F', '-2.254187','53.786319', '00000000005' );
298INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
299VALUES ('E01025368','Rossendale 003B', '-2.203633','53.708489', '00000000004' );
300INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
301VALUES ('','', '','', '00000000004' );
302INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
303VALUES ('E01024911','Burnley 006D', '-2.259135','53.793616', '00000000004' );
304INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
305VALUES ('','', '','', '00000000004' );
306INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
307VALUES ('E01012615','Darwen 017B', '-2.456967','53.689068', '00000000004' );
308INSERT INTO Location (LSAO_Code, LSAO_Name, Longitude, Latitude,Crime_ID )
309VALUES ('','', '','', '00000000004' );
310
311
312UPDATE Criminal
313SET Criminal_Address = '181 Ormskirk Rd WN89EE'
314WHERE Criminal_ID = '00000000001';