Scenario $5$: Customers and Products $(10$ points$)$

XYZ Corporation has customers $($identified by Customer$\_$ID$)$ who are entered into the system when

they place their first order $($Order$\_$ID$).$ XYZ sells six different products $($Product$\_$ID$).$ Each order has a

unique order$\_$id$,$ order date, scheduled transportation date and delivery date. Draw a practical ERD

that can store data accurately for XYZ Corporation$$s customers, products and orders. Use only the

attribute names shown above $($Customer$\_$ID$,$ Order$\_$ID$,$ and Product$\_$ID$)$ to provide all primary keys

in this ERD. Define the order as an associate entity. Each order has only one customer but one to

many products. Products may or may not have orders. do i need ERD draw for this question or not?