$4.$ Database review $-$ Create a Database in MSSQL Server called Midterm $($your local SQL$)$ and create a script that will create a table called Customers that has the following fields:

$-$ Customer ID $($int$)$

$-$ FirstName $(25$ characters max$)$

$-$ LastName $(35$ characters max$)$

$-$ Street Address $(50$ characters MAX$)$

$-$ Date of Birth $($Date$)$

You will then needs to script the addition of $10$ records to be added to the database for the Midterm table. $(10$ points$)$

Once the database is created you will then create the DatabaseReview page, connect the database to visual studio, install the SQLServer and tools packages and then use the database scaffold command to create the Model and DBContext files.

After completing the setup output all the records onto the page. You will need to make sure you have formatted the page and provided proper headers for the fields. $(20$ Points$)$