Evaluate and describe how to connect a Web application sales database and inventory database and validate payment database in an $N-$tier architecture. Then, address the following:

$-$ Create a network diagram using Microsoft Visio or your favorite charting software tool to depict a three$-$tier $($or N$-$tier$)$ network chart, and explain the key

components for a Web App and the information flow between various $N-$tier components.

$-$Describe how a Java Web tWeb$-$typeype application would access securely $($connect$)$ the sales database using Java and SQL statements to extract data from the Order table

for those customers that have pending fulfillment orders due to unavailability of inventory. An example will be appropriate. Assume the Order table as follows: