a design document and a revised project plan. One of the main functions of any business is to transform data into information.

Hello I need this IT paper done in APA. Here are the instructions and please follow them. The last one i did not do very good on because nobody does not follow the instructions.

Part One: Please add appropriate examples. Use charts and diagrams via Microsoft Visio within the written part of this Assignment. Add in-text citations as well. The instructions are under the attachment "Week 6 Writing Assignment doc".

Part Two: This is the Plan Project that is continued on Microsoft Project from the previous Microsoft Project assignment under the Business Requirement Project. Just add 3 to 5 new project tasks consisting of 5 to 10 sub-tasks. Note: I attached the Business Requirements Project Plan from the previous assignment will also be attached so you can add to it.

If you have any questions please ask. I cannot afford to fail.

• Attachment 1
• Attachment 2
• Attachment 3

Due Week 6 and worth 120 pointsThis assignment consists of two (2) sections: a design document and a revised project plan. Youmust submit both sections as separate files for the completion of this assignment. Label each filename according to the section of the assignment it is written for. Additionally, you may createand / or assume all necessary assumptions needed for the completion of this assignment.One of the main functions of any business is to transform data into information. The use ofrelational databases and data warehousing has gained recognition as a standard for organizations.A quality database design makes the flow of data seamless. The database schema is thefoundation of the relational database. The schema defines the tables, fields, relationships, views,indexes, and other elements. The schema should be created by envisioning the business,processes, and workflow of the company. Since your company is an innovative Internet-basedcompany, movement toward data warehousing seems to be one of the most viable options to giveyour company a competitive advantage; however, these concepts must be explained to theexecutive board in a manner to garner support. 1.2. 3.4. 5. 6. Section 1: Design DocumentWrite a six to ten (6-10) page design document in which you:Support the need for the use of relational databases and data warehousing. From amanagement standpoint, it may be important to show the efficiencies that can be gained forexecutive oversight.Create a database schema that supports the company’s business and processes. Explainand support the database schema with relevant arguments that support the rationale for thestructure. Note: The minimum requirement for the schema should entail the tables, fields,relationships, views, and indexes.Identify and create database tables with appropriate field-naming conventions. Then,identify primary keys and foreign keys, and explain how referential integrity will be achieved.Normalize the database tables to third normal form (3NF).Identify and create an Entity-Relationship (E-R) Diagram relating the tables of thedatabase schema through the use of graphical tools in Microsoft Visio or an open sourcealternative 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 your rationalebehind the design of the E-R Diagram.Identify and create a Data Flow Diagram (DFD) relating the tables of your databaseschema through the use of graphical tools in Microsoft Visio or an open source alternative suchas Dia. Note: The graphically depicted solution is not included in the required page length butmust be included in the design document appendix. Explain the rationale behind the design ofyour DFD.Illustrate the flow of data including both inputs and outputs for the use of a datawarehouse. The diagram should map data between source systems, operational systems, datawarehouses and specified data marts. Note: The graphically depicted solution is not included inthe required page length. Your assignment must follow these formatting requirements: Be typed, double spaced, using Times New Roman font (size 12), with one-inch marginson all sides; citations and references must follow APA or school-specific format. Check withyour professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, theprofessor’s name, the course title, and the date. The cover page and the reference page are notincluded in the required assignment page length.Include charts or diagrams created in MS Visio or Dia as an appendix of the designdocument. All references to these diagrams must be included in the body of the design document.