Database System Development

The retail store has experienced significant growth in the recent months. The customers have expressed an interest in being able to purchase the retail store’s products electronically. Currently the retail store has a simple Web site but it is not clear that the system can support dynamic interaction on the Web site or online purchases. The main database system that is used in the physical store has not been working correctly however and this is an issue. The retail store wants to be able to eventually integrate an online database system with the current entry system that is used to support sales made in the local store. The retail store also needs the database system to enforce the rules that have been established for their business practices. What can be done to support the goals and objectives for meeting the needs of their customers? Examples are provided here to help with this assignment. It is assumed that Microsoft SQL Server Express Edition (with management tools) was chosen as the database platform. It can be downloaded for free at this Web site.You have been asked to develop a solution in the form of a Database System Development Plan for your retail store using the following format: Each week you will add a section to this Database System Development and Implementation Plan and submit it for grading. As a preview each section will contain the following:

Requirements: 30 pages + presentation | .doc file

Database System Development and Implementation PlanUse Microsoft WordTitle pageCourse number and nameProject nameYour nameDateTable of contents (TOC)Use auto-generated TOCMaximum of 3 levels deepBe sure to update the fields of the TOC so it is up-to-date before submitting your project.Section headings (create each heading on a new page with TBD as content except for sections listed under new content below) Use Microsoft Word Title pageCourse number and nameProject nameYour nameDate Course number and name Project name Your name Date Table of contents (TOC)Use auto-generated TOCMaximum of 3 levels deepBe sure to update the fields of the TOC so it is up-to-date before submitting your project. Use auto-generated TOC Maximum of 3 levels deep Be sure to update the fields of the TOC so it is up-to-date before submitting your project. Section headings (create each heading on a new page with TBD as content except for sections listed under new content below) Database System Overview Entity Relationship Model Structured Query Language (SQL) Scripts Database Administration Plan Future Database System Implementation Plan