SQL Database w/queries and ERD diagram

The final project for this course is the creation of a database and a report explaining the choices you made in the creation of your database based on the scenario outlined in the Final Project Document.

There are total of three deliverables assigned: two milestones and the database and report. The database requires the use of Microsoft SQL.

Prompt: In Module Two, submit a project proposal and its overview. Submit this deliverable as a Word document. This milestone will be graded using the Milestone One Rubric found on the following page. The milestone should include the following:

· Title page

· Include project title, your name, and date (and other information as you see fit)

· Overview

· General description of the project and supporting database

· Justification

· Why would you do this project?

· What problem will this database solve?

· What happens if you do not do this project?

· Requirements

· For each major feature:

· Describe it

· Explain why you need it

· Design considerations

· In this section, include:

· All the tables and their relationships. For each table, include:

· Table name

· All attributes (field names and their data type)

· Keys (primary, foreign, etc.) Note: This could be a diagram depicting the listed items as well

· If appropriate, include a process diagram