$4.$ Database review $1-$ Review $1$ will cover the concepts covered in Module $5.$ Create a Database for the Final called Final$23.$ Once the database is created you will want to create $2$ tables. Table one will be the customer table it will contain the customer ID$,$ Customer name, Customer address, Customer Zip, Customer phone number and customer email address. You will need to create $10$ unique records in this database, the second table will be an orders table, this table will contain Order ID$,$ Customer ID$,$ date of purchase, shipped date, and total amount spent. For this table I want $30$ unique records. You can have multiple for one user but I require at least $7$ users

to have at least $1$ order tied to them. For the DB creation you must submit the SQL scripts you use to create the tables and data or you will lose all points for the DB sections of the final. $(10$ Points$)$

Once the database is created you will then create the Database Review $1$ page, connect the database to visual studio, install the SQLServer and tools packages $($Make sure you select version $8-$ MS released $\backslash (9.$ x $\backslash )$ and it VS now defaults to it$)$ and then use the database scaffold command to create the Model and DBContext files as well as configure it to use authentication.

I want you to display all the customer information on the load of the page. There will also be a radio button on each customer row so that the user can select the customer and view the orders placed by the customer. Below the customer records, when the page first loads, you will have a message indicating $"$No orders available to view!!!!" and this will stay till a customer is selected.

When a customer is selected it will display all the orders from that customer below the customer list. All information about each order should be displayed on the page. $(20$ Points$)$