Please make a relational schema for the ER diagram that is attached. Please use GRAPHICAL REPRESENTATION to express your relational schema.

a. Show all the tables (relations) you need to create with all the corresponding attributes for each table, including foreign keys.

b. Show the primary keys (underline), foreign keys (dotted underline) and foreign key references (using arrows).

CUSTOMER Customer ID WISH LIST Name Wish List ID (First, Middle, Last) Creates Date_Created Address Type (Street, City, State, Zip, Country) Phone Email Contains SHIPPING COMPANY Shipper ID BOOK Shipper_Name Book ID Contact Name Title (Title, First, Middle, Last) Year Addres ISBN Places (Street, City, State, Zip, Country) Publisher Phone {Author Email (First, Middle, Last, DOB, Birthplace)} Category # Ships Has 8 8 Sale Price PURCHASE ORDER CUSTOMER BOOK INVENTORY Order ID SHIPMENT Inventory_ID Order Date Shipment ID Purchase Cost Order Time Tracking No List Price Est Ship Date Ship Date Requires Condition Contains Est Ship_Time Ship_Time Signed Credit_Card_No Est Arrival_Date Edition Shipping_Method Est Arrival_Time Binding Shipping_Status Act Arrival_Date Order_Status Act Arrival_Time Provides Prepares EMPLOYEE SUPPLIER Employee ID Supplier ID SSN Type Name Contact_Name (First, Middle, Last) (Title, First, Middle, Last) -Processes Address Address (Street, City, State, Zip) (Street, City, State, Zip, Start_Date Country DOB Email Salary Phone Phone