Unit 1 - Individual Project View Assignment Details for Unit 1 - Individual Project as PDF Assignment OverviewAssignment: Unit 1 - Individual ProjectType: Individual Project Unit: Fundamentals of Database Systems Due Date: Wed,11/25/20 Grading Type: Numeric Points Possible: 100 Points Earned: Points Earned not available Deliverable Length: Word document of 4–5 pages (excluding references and cover page) View objectives for this assignment Go To:Assignment DetailsScenarioLearning MaterialsReading AssignmentMy Work: Online Deliverables: Submissions Looking for tutoring? Go to SmarthinkingDetailsScenarioLearnRead My Work Online Deliverables:SubmissionsAssignment DetailsAssignment DescriptionThe 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 order 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:Database System Development and Implementation Plan Use Microsoft Word Title page Course number and name Project name Your name Date Table of contents (TOC) 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) 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:Database System Overview (Week 1 IP) Entity Relationship Model (Week 2 IP) Structured Query Language (SQL) Scripts (Week 3 IP) Database Administration Plan (Week 4 IP) Future Database System Implementation Plan (Week 5 IP) Database System Overview (4–5 pages)The project deliverables are as follows:Describe the general business environment for the case study organization. Include a database system goals and objectives statement. Include a narrative that discusses how the proposed database system addresses the presenting business problem(s). Include a narrative that demonstrates how the proposed system aligns to the mission statement and strategic goals of the organization. Identify the mission and goals of the case study retail store, and provide your analysis as to how this part of the project fulfills the mission and/or goals of the case study organization. All sources should be cited both in-text and in References using APA format. Name the document "yourname_CS660_IP1.doc." Submit the document for grading. Please submit your assignment.For assistance with your assignment, please use your text, Web resources, and all course materials.

Read case, Forondo Artist Management Excellence Inc.(FAME). 1. Create a memo (Email Letter) describing your initial analysis of the situation at FAME as it relates to the design of the database application. Write this as  you are writing a reply back to Martin Forondo. a. Your approach to addressing the problem at hand (for example, specify the systems development life cycle) b. What will the new system accomplish? What functions will it perform? Which organizational goals will it support? c. What will be the benefits of using the new system? Use concrete examples to illustrate this. Outline general categories of costs and resources needed for the project and implementation of the ultimate system. d. Questions, if any, you have for Mr. Forondo for which you need answers before you would be willing to begin the project 2. Create an enterprise data model that captures the data.  You should identify  at least 7 entities and appropriate relationship among entities. Insert the screenshot of the Enterprise Model in the same document.