A$3.$ TAL

In this part of the assignment, you are provided with a well$-$designed database in the form of tables. So no design change is needed. Make an ERD for TAL data, and answer the questions included below related to TAL data. Please check your answers carefully before submission. No programming is needed, the reports must be hand calculated$/$tabulated$.$ Price stored in Item should be viewed as List$\_$Price.

Study TAL design carefully. It also illustrates the use of header$/$line table structures found in designs related to multi$-$line business documents $($e$.$g$.,$ Orders, and Order$\_$LinMake an ERD diagram for the given database.

Then submit any $5$ of the following $6$ reports:

$1)$ List ITEM$\_$NUM, DESCRIPTION, and NUM$\_$ORDERED related to orders placed by the customer

$$Almondton General Store$.$

$2)$ For each Postal code, list POSTAL$\_$CODE, CITY and number of customers in it$.$

$3)$ Which item $($List ITEM$\_$NUM, DESCRIPTION, NUM$\_$ORDERED$)$ has the highest NUM$\_$ORDERED

among all the orders placed by the customer $$Almondton General Store$?$

$4)$ For each category $($in ITEM$)$ what is the total inventory value $($as defined by ON$\_$HAND $*$ PRICE$)?$

$5)$ For ORDER$\_$NUM $51617,$ report the total dollar value of discount given based on the difference

in QUOTED$\_$PRICE compared to LIST$\_$PRICE listed in the item table. Show calculations of dollar

value for the order by listing ORDER$\_$NUM, PART$-$NUM, LIST$\_$PRICE, QUOTED$\_$PRICE, ORDER$\_$QTY$,$

TOTAL$\_$DISCOUNT$\_$DOLLARS.

$6)$ What is the total amount that $$Toys Galore$$ spent on all of its orders?e here$).$