Most figures in the case study reflect user information$/$reporting requirements. For example,

Figure $1-2$ shown below reflects their current paper$-$based Customer Order Form:

Figure $1-2$

Customer Order.

What is the best ERD that would model the data requirements reflected in Figure $1-2?$

I am having a hard time pulling the information out of this to make a ERD Diagram. So far the entities I think are imortant are "Customer" and "Order"

Your database design should be responsive to the following sample queries. Use these queries to

refine$/$verify your design. There is no database or queries to submit $-$ just the ERD.

Query $1$: List complete order details for order #$1008$ placed last September.

Query $2$: List orders with both products M$128$ and M$129$ on them.

$2$

Query $3$: Which products were our top $5$ sellers by quantity ordered in $2019?$

Query $4$: List the top $3$ orders $($based on Total $ Value of order$)$ placed with us so far in $2020.$

Query $5$: List our best $2$ customers $($based on total $ ordered$)$ for each zip code in Texas.

Submit your ERDPlus design files in the Moodle drop box.

Please make sure your name appears in a label on your ERD diagram.