Project Deliverable 3: Database and Data Warehousing Design Thisassignment consi

Project Deliverable 3: Database and Data Warehousing Design Thisassignment consists of two (2) sections: a design document and arevised project plan. You must submit both sections as separatefiles for the completion of this assignment. Label each file nameaccording to the section of the assignment it is written for.Additionally you may create and / or assume all necessaryassumptions needed for the completion of this assignment. One ofthe main functions of any business is to transform data intoinformation. The use of relational databases and data warehousinghas gained recognition as a standard for organizations. A qualitydatabase design makes the flow of data seamless. The databaseschema is the foundation of the relational database. The schemadefines the tables fields relationships views indexes andother elements. The schema should be created by envisioning thebusiness processes and workflow of the company. Since yourcompany is an innovative Internet-based company movement towarddata warehousing seems to be one of the most viable options to giveyour company a competitive advantage; however these concepts mustbe explained to the executive board in a manner to garner support.Section 1: Design Document Write a six to ten (6-10) page designdocument in which you: Support the need for the use of relationaldatabases and data warehousing. From a management standpoint itmay be important to show the efficiencies that can be gained forexecutive oversight. Create a database schema that supports thecompanys business and processes. Explain and support the databaseschema with relevant arguments that support the rationale for thestructure. Note: The minimum requirement for the schema shouldentail the tables fields relationships views and indexes. Identify and create database tables with appropriate field-namingconventions. Then identify primary keys and foreign keys andexplain how referential integrity will be achieved. Normalize thedatabase tables to third normal form (3NF). Identify and createan Entity-Relationship (E-R) Diagram relating the tables of thedatabase schema through the use of graphical tools in MicrosoftVisio or an open source alternative such as Dia. Note: Thegraphically depicted solution is not included in the required pagelength but must be included in the design document appendix.Explain your rationale behind the design of the E-R Diagram. Identify and create a Data Flow Diagram (DFD) relating the tablesof your database schema through the use of graphical tools inMicrosoft Visio or an open source alternative such as Dia. Note:The graphically depicted solution is not included in the requiredpage length but must be included in the design document appendix.Explain the rationale behind the design of your DFD. Illustratethe flow of data including both inputs and outputs for the use of adata warehouse. The diagram should map data between source systemsoperational systems data warehouses and specified data marts.Note: The graphically depicted solution is not included in therequired page length. Your assignment must follow these formattingrequirements: Be typed double spaced using Times New Roman font(size 12) with one-inch margins on all sides; citations andreferences must follow APA or school-specific format. Check withyour professor for any additional instructions. Include a coverpage containing the title of the assignment the students namethe professors name the course title and the date. The coverpage and the reference page are not included in the requiredassignment page length. Include charts or diagrams created in MSVisio or Dia as an appendix of the design document. All referencesto these diagrams must be included in the body of the designdocument. Section 2: Revised Project Plan Use Microsoft Project to:Update the project plan (summary and detail) template from ProjectDeliverable 2: Business Requirements with three to five (3-5) newproject tasks each consisting of five to ten (5-10) subtasks. Thespecific course learning outcomes associated with this assignmentare: Describe the methods and best practices in implementingprocess change in IT organizations. Describe the role and methodsof technology-induced process improvement in organizations. Usetechnology and information resources to research issues ininformation systems. Write clearly and concisely about leadershipissues and strategic insight of the Information systems domainusing proper writing mechanics and technical style conventions.Grading for this assignment will be based on answer quality logic/ organization of the paper and language and writing skills. Clickhere to access the rubric for this assignment. Click here to reviewthe Capstone Project Overview.