For this project, you will be continuing to enhance your course project. Data is an important part of many applications, and it is now time to add data connectivity to your application

For this project, you will be continuing to enhance your course project. Data is an important part of many applications, and it is now time to add data connectivity to your application. During this step, you will create a database and connect it to your application in a meaningful way. You will be using SQL Express to create the database and data-bound controls in your ASP.NET application to connect to the data.

Step 1 is to create your database using SQL Express. Visual Studio allows you to create the database directly from within the IDE. Refer back to your original project requirements to create a database that will be appropriate for your application. Be sure to add some sample data to your database. The database may be a single table, or you may want to strive for excellence in the project with a multi-table database with related tables. The second step of the project will be to add data-bound controls to your application to allow you to view and edit the data in the database.

The following are the project deliverables:

• Application Design Document
  • Use MS Word
  • Title Page
    • Course number and name
    • Project name
    • Student name
    • Date
  • Add a “Database Design” section to your design document.
    • Briefly describe your database.
    • Provide a diagram showing your database tables and content. This can be an entity relationship diagram or a data dictionary.
  • Name the document “yourname_ITSD425_IP2.doc.”
• Application Updates
  • Create a database with sample data that you will use for your application. Basic requirements are a single table, and a multi-table database with relations will be regarded as a higher achievement in the assignment.
  • Add a database connection to your application to connect to your newly created database.
  • Either modify existing pages or add new pages to your ASP.NET Web application, and use data-bound ASP.NET controls and other necessary controls to perform the following:
    • View all data in the database in a grid.
    • View individual records in the database.
    • Add, delete, and modify records in the database.
  • Any code necessary for the project should be C# and documented with good comments.
  • Be sure to include a thorough description of the changes made for this assignment in a “PROJECT_UPDATE.DOCX” in the project folder. This document will identify the areas of the application that demonstrate the satisfaction of each of the requirements.
• The project folder should be zipped to a file called “ITSD425_IP2.ZIP.” The file should include the design document and all project files. Submit the zip file for grading