(Copy and paste into your mysql database to get the tables)

CREATE DATABASE Relational_Database_A5; USE Relational_Database_A5;

CREATE TABLE AGENT( AGENT_CODE varchar(50), AGENT_PHONE varchar(50) );

INSERT INTO AGENT VALUES('125','6152439887'); INSERT INTO AGENT VALUES('167','6153426778'); INSERT INTO AGENT VALUES('231','6152431124'); INSERT INTO AGENT VALUES('333','9041234445');

/* -- */

CREATE TABLE CUSTOMER ( CUS_CODE varchar(50), CUS_LNAME varchar(50), CUS_ZIP varchar(50), AGENT_CODE varchar(50) );

INSERT INTO CUSTOMER VALUES('1132445','Walker','32145','231'); INSERT INTO CUSTOMER VALUES('1217782','Adares','32145','125'); INSERT INTO CUSTOMER VALUES('1312243','Rakowski','34129','167'); INSERT INTO CUSTOMER VALUES('1321242','Rodriguez','37134','125'); INSERT INTO CUSTOMER VALUES('1542311','Smithson','37134','421'); INSERT INTO CUSTOMER VALUES('1657399','Vanloo','32145','231');

/* -- */

/* -- */

CREATE TABLE STUDENT ( STU_FNAME varchar(50), STU_LNAME varchar(50) );

INSERT INTO STUDENT VALUES('George', 'Jones'); INSERT INTO STUDENT VALUES('Jane', 'Smith'); INSERT INTO STUDENT VALUES('Peter', 'Robinson'); INSERT INTO STUDENT VALUES('Franklin', 'Johnson'); INSERT INTO STUDENT VALUES('Martin', 'Lopez');

/* -- */

CREATE TABLE EMPLOYEE ( EMP_FNAME varchar(50), EMP_LNAME varchar(50) );

INSERT INTO EMPLOYEE VALUES('Franklin', 'Lopez'); INSERT INTO EMPLOYEE VALUES('William', 'Turner'); INSERT INTO EMPLOYEE VALUES('Franklin', 'Johnson'); INSERT INTO EMPLOYEE VALUES('Susan', 'Rogers');

/* -- */

CREATE TABLE PRODUCT ( P_CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric(6,2) );

INSERT INTO PRODUCT VALUES('123456','Flashlight','5.26'); INSERT INTO PRODUCT VALUES('123457','Lamp','25.15'); INSERT INTO PRODUCT VALUES('123458','Box Fan','10.99'); INSERT INTO PRODUCT VALUES('213345','9v battery','1.92'); INSERT INTO PRODUCT VALUES('311452','Powerdrill','34.99'); INSERT INTO PRODUCT VALUES('254467','100W bulb','1.47'); INSERT INTO PRODUCT VALUES('345678','Microwave','160'); INSERT INTO PRODUCT VALUES('345679','Dishwasher','500'); INSERT INTO PRODUCT VALUES('123458','Box Fan', '10.99');

/* -- */

CREATE TABLE CODES ( P_CODE varchar(50), CUS_CODE varchar(50) );

INSERT INTO CODES VALUES('123456', '10400'); INSERT INTO CODES VALUES('123456', '11501'); INSERT INTO CODES VALUES('123456', '10030'); INSERT INTO CODES VALUES('123456', '12550'); INSERT INTO CODES VALUES('234567', '12350'); INSERT INTO CODES VALUES('234567', '10040'); INSERT INTO CODES VALUES('234567', '10500'); INSERT INTO CODES VALUES('234567', '10030'); INSERT INTO CODES VALUES('234567', '12550'); INSERT INTO CODES VALUES('345678', '10400'); INSERT INTO CODES VALUES('345678', '11630'); INSERT INTO CODES VALUES('345678', '12550'); INSERT INTO CODES VALUES('456789', '11630'); INSERT INTO CODES VALUES('567890', '10600'); INSERT INTO CODES VALUES('567890', '10030'); INSERT INTO CODES VALUES('567890', '12550'); INSERT INTO CODES VALUES('678901', '11500'); INSERT INTO CODES VALUES('678901', '10400'); INSERT INTO CODES VALUES('678901', '11630');

/* -- */

CREATE TABLE LOCATION ( STORE varchar(50), AISLE varchar(50), SHELF varchar(50) );

INSERT INTO LOCATION VALUES('23','W','5'); INSERT INTO LOCATION VALUES('24','K','9'); INSERT INTO LOCATION VALUES('25','Z','6');

/* -- */

=================================================================

(Problem)

Create E-R diagram with table names, comumns,primary key, and foregin key. also add relation lines please!

(use correct naming convention - capital lettersm underline, etc)

Thank you!