Create a flow chart from the given information

1. Login to portal.azure.com

2. Select Extensions > phpMyAdmin extension > Select Browse

3. phpMyAdmin will be displayed in the browser and you should be automatically logged in.

4. Left click on your database name in the left menu to select it

5. Click on SQL in the top menu

6. We will now run SQL and create a new database table called tblCDA3315C a. Copy/Paste SQL below into Query box CREATE TABLE tblCDA3315C (ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID), FIRST_NAME VARCHAR(30), LAST_NAME VARCHAR(30), TELEPHONE VARCHAR(30))

7. Click on the GO button located near the bottom middle right side.

8. You should see the tblCDA3315C table in the database folder on the left

9. Done

APPENDIX C

1. Activate the phpMyAdmin extension as you have done previously through the Azure Web App.

2. Select your database on the left.

3. Click on SQL at the top.

4. We will now create a new table called tblUSERS. Copy the following query into the SQL window and click Run. CREATE TABLE tblUSERS (USERS_ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(USERS_ID), FIRST_NAME VARCHAR(30), LAST_NAME VARCHAR(30), MIDDLE_NAME VARCHAR(30), TELEPHONE VARCHAR(30), FAX_NUMBER VARCHAR(30), STATUS VARCHAR(1), CREATED_BY VARCHAR(30), CREATED_DATE DATE, MODIFIED_BY VARCHAR(30), MODIFIED_DATE DATE)

5. Run the new query below to create a new table called tblADDRESSES CREATE TABLE tblADDRESSES (ADDR_ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(ADDR_ID), USERS_ID INT, ADDRESS1 VARCHAR(30), ADDRESS2 VARCHAR(30), CITY VARCHAR(30), STATE VARCHAR(30), ZIPCODE INT, STATUS VARCHAR(1), CREATED_BY VARCHAR(30), CREATED_DATE DATE, MODIFIED_BY VARCHAR(30), MODIFIED_DATE DATE)

6. Run the new query below to insert a new record into the tblUSERS table INSERT INTO tblusers (USERS_ID, FIRST_NAME, LAST_NAME, MIDDLE_NAME, TELEPHONE, STATUS, CREATED_BY, CREATED_DATE, MODIFIED_BY, MODIFIED_DATE) VALUES (1, 'JOHN', 'DOE', 'LITE', '123-456-7890', 'A', 'STUDENT', CURDATE(), 'STUDENT', CURDATE())

7. Run the new query below to insert a new record into the tblADDRESSES table INSERT INTO `tbladdresses`(`ADDR_ID`, `USERS_ID`, `ADDRESS1`, `ADDRESS2`, `CITY`, `STATE`, `ZIPCODE`, `STATUS`, `CREATED_BY`, `CREATED_DATE`, `MODIFIED_BY`, `MODIFIED_DATE`) VALUES (1, 1, '1700 Clean Ave.', 'n/a' , 'TOPEKA', 'FL.', '10011', 'A', 'DEAN',CURDATE(), 'DEAN',CURDATE() )

8. Run the following query to verify that the tables can talk to each other SELECT tblB.FIRST_NAME, tblB.LAST_NAME, tblB.TELEPHONE, tblA.ADDRESS1, tblA.CITY, tblA.STATE, tblA.ZIPCODE FROM tbladdresses tblA JOIN tblusers tblB ON tblB.users_id = tblA.users_id WHERE tblB.USERS_ID = 1 AND tblA.STATUS = 'A' AND tblB.STATUS = 'A'

9. Results from the query

10. Done