Use the tables that you have created for Assignment 5 and create an ERD diagram. Use the following figures for reference. (4-10, 4-13, 4-20). Make sure you use the Crows foot notation and include the attributes. All many to many (N:M) diagrams should be broken down into Associative entities. Hint: Remember to use the normalized tables that you have created with primary keys and foreign keys. All many to many (N:M) diagrams should be broken down into Associative entities.

help!! i have created an ERD but do not know if it is correctly done or what I can do to improve it to meet the assignment requirements. I am not even sure if alll of the tables need to be connecting.

AGENT_ID is the primary key in the table AGENT.

CUSTOMER_ID is the primary key in the table CUSTOMER.

AGENT_ID is the foreign key referencing AGENT in the table CUSTOMER.

PRODUCT_ID is the primary key in the table PRODUCT,

STORE_INVENTORY_ID is the primary key in the table STORE_INVENTORY.

PRODUCT_ID is the foreign key referecing PRODUCT in the table STORE_INVENTORY.

here are the queries as well: create database relational_database; CREATE TABLE AGENT ( AGENT_ID INT AUTO_INCREMENT PRIMARY KEY, Agent_FNAME VARCHAR (50), AGENT_LNAME VARCHAR (50), AGENT_PHONE VARCHAR(50) ); INSERT INTO AGENT (AGENT_FNAME, AGENT_LNAME, AGENT_PHONE) VALUES ('George', 'Jones', '6152439887'), ('Jane', Smith', '6153426778'), ('Peter', 'Robinson', '6152431124'), ('Franklin', 'Johnson', '9041234445'), ('Tom', 'Cat', '6152434287'), ('Robbie', 'Wheeler', '6158894255'), ('Dan', 'Grissom', '6156141544'), ('Lanie', 'Drewon', '6152433321'), ('Deborah', Thompson', '615243323'), ('Ricky', Billard', '6152434485'); CREATE TABLE CUSTOMER ( CUSTOMER_ID INT AUTO_ INCREMENT PRIMARY KEY, CUSTOMER_ NAME VARCHAR (50), CUSTOMER_ZIP VARCHAR (50) , AGENT_ID INT, FOREIGN KEY (AGENT_ID) REFERENCES AGENT (AGENT_ID) ); INSERT INTO CUSTOMER (CUSTOMER NAME, CUSTOMER_ZIP, AGENT_ID) VALUES ('Walker', '32145', 3), ('Adares', '32145', 1), ('Rakowski', '34129', 2), ('Rodriguez', '37134', 1), (Smithson', 37134, 4), ('Vanloo', '32145', 3), (Davis', '32145', 4), (Kristoff, 37134, 2), (Mills', 37134, 3), (White', '32145, 1);

CREATE TABLE PRODUCT ( PRODUCT_ID INT AUTO_INCREMENT PRIMARY KEY, PRODUCT_DESCRIPTION VARCHAR(50), PRICE NUMERIC(7,2) ); INSERT INTO PRODUCT (PRODUCT_DESCRIPTION, PRICE) VALUES ('Flashlight', 5.26), ('Lamp', 25.15), ('Box Fan', 5.26), ('9v Battery', 10.99), ('Powerdrill', 34.99), ('100w Bulb', 1.47), ('Microwave', 160.00), ('Dishwasher', 500.00), ('Toaster', 24.99), (Blender, 32.50);

CREATE TABLE STORE INVENTORY ( STORE_INVENTORY_ID INT AUTO_ INCREMENT PRIMARY KEY, PRODUCT_ID INT, STORE VARCHAR (50), AISLE VARCHAR (50), SHELF VARCHAR (50), FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT (PRODUCT_ID) ); INSERT INTO STORE_ INVENTORY (PRODUCT_ID, STORE, AISLE, SHELF) VALUES (1, '23', 'W', '5), (2, '24, K', '9), (3, '25', 'Z', '6'), (4, '26', 'F', '5), (5, '27' , 'H', '4'), (6, '28', 'W', '3'), (7, '29', 'X', '3'), (8, '30', Y, 8), (9, '31 , 'C', 2), (10, '32 , 'J', '1);

AGENT AGENT_ID INT AGENT_FNAME VAROHAR(50) AGENT_LNAME VARCHAR(50) AGENT_PHONE VARCHAR(50) Indexes CUSTOMER CUSTOMER_ID INT CUSTOMER_NAME VARCHAR(50) CUSTOMER_ZIP VARCHAR(50) AGENT_ID VAROHAR(50) Indexes STORE_INVENTORY STORE_INVENTORY_ID INT PRODUCT_ID VARCHAR (45) STORE VARCHAR (50) AISLE VARCHAR(50) SHELF VARCHAR (50) Indexes PRODUCT PRODUCT_ID INT PRODUCT_DESCRIPTION VARCHAR (50) PRICE VARCHAR(50) Indexes