zzi52Jr2

1/*
2 * Author:  Julius Osagiede
3 * Created: Oct 23, 2018
4   Solution to HW 4
5 */
6
7-- Why isn't my script running? I tried to write the correct syntax for variables, but nothing seems to work. I give up! I am a student
8
9DROP DATABASE IF EXISTS PE1;
10CREATE DATABASE PE1;
11USE PE1;
12
13CREATE TABLE LOCATIONS (
14    VARIABLE_NAME VARCHAR(15) NOT NULL,
15    VALUE_ASSIGNED INT(15) NOT NULL
16);
17
18CREATE GLOBAL VARIABLE LOCATION1_X INT;
19SET GLOBAL LOCATION1_X = 123;
20
21CREATE VARIABLE LOCATION1_Y INT;
22SET GLOBAL LOCATION1_Y = 456;
23
24CREATE VARIABLE LOCATION2_X INT;
25SET GLOBAL LOCATION2_X = 987;
26
27CREATE VARIABLE LOCATION2_Y INT;
28SET GLOBAL LOCATION2_Y = 567;
29
30CREATE VARIABLE LOCATION3_X INT;
31SET GLOBAL LOCATION3_X = 345;
32
33CREATE VARIABLE LOCATION3_Y INT;
34SET GLOBAL LOCATION3_Y = 652;
35
36INSERT INTO LOCATIONS(VARIABLE_NAME, VALUE_ASSIGNED)
37VALUES('LOCATION1_X', LOCATION1_X);
38
39INSERT INTO LOCATIONS(VARIABLE_NAME, VALUE_ASSIGNED)
40VALUES('LOCATION1_Y', LOCATION1_Y);
41
42INSERT INTO LOCATIONS(VARIABLE_NAME, VALUE_ASSIGNED)
43VALUES('LOCATION2_X', LOCATION2_X);
44
45INSERT INTO LOCATIONS(VARIABLE_NAME, VALUE_ASSIGNED)
46VALUES('LOCATION2_Y', LOCATION2_Y);
47
48INSERT INTO LOCATIONS(VARIABLE_NAME, VALUE_ASSIGNED)
49VALUES('LOCATION3_X', LOCATION3_X);
50
51INSERT INTO LOCATIONS(VARIABLE_NAME, VALUE_ASSIGNED)
52VALUES('LOCATION3_Y', LOCATION3_Y);
53
54CREATE VARIABLE D1_2 INT;
55SET D1_2 = 'The distance between Location 1 and Location 2 is ' + SQRT(POWER((LOCATION2_X - LOCATION1_X), 2) + ((LOCATION2_Y - LOCATION1_Y), 2)) + ' meters';
56
57CREATE VARIABLE D1_3 INT;
58SET D1_3 = 'The distance between Location 1 and Location 3 is ' + SQRT(POWER((LOCATION3_X - LOCATION1_X), 2) + ((LOCATION3_Y - LOCATION1_Y), 2)) + ' meters';
59
60CREATE VARIABLE D2_3 INT;
61SET D2_3 = 'The distance between Location 2 and Location 3 is ' + SQRT(POWER((LOCATION3_X - LOCATION2_X), 2) + ((LOCATION3_Y - LOCATION2_Y), 2) + ' meters';
62
63SELECT D1_2 AS 'DISTANCE 1', D1_3 AS 'DISTANCE 2', D2_3 AS 'DISTANCE 3' FROM LOCATIONS;
64SELECT 'Julius Osagiede juliusosagiede@yahoo.com' AS 'My Email';