Coding and design

Create a database with a table called tblNames and tblLogin. The tblNames table should have the following columns.

SSN - of type text. Set this as the Primary Key.
FirstName - of type Text.
LastName - of type Text.
The tblLogin table should have the following columns.

ID - this is the Primary Key. It type is autonumber.
UserName - of type Text. It should be set to a unique value
Password - of type Text.Add several records to this table. Use Visual Studio.NET 2005 to create an ASP.NET application with three aspx forms.
The first form is a login page that contains a Login control. Users cannot view the other forms until they have successfully logged onto the application.
The second form contains a GridView control. The GridView control will allow the user to (1) view the entries in the database table and (2) update the first name and last name entries.
The last form contains three TextBox controls labeled "Social Security Number," "First Name," and "Last Name," a Button control, and a Label control. When the user presses the button, their entry is added to the database.
Use a RegularExpressionValidator control to confirm the user entered a properly formatted social security number. Use RequiredFieldValidator controls to confirm the user entered a string in the other textboxes. Use Try…Catch to display an error message in the Label control, if the user tries to enter a social security number already stored in the database.

The name of your Visual Studio project should be based on your last name. For example, if your last name is Jones, then assign the name, Jones_IP3.