Cashback Offer from 10th to 18th September 2021. Get Flat 10% Cashback credited to your account for a minimum transaction of $80. Post Your Question Today!

Question Details Normal
$ 1.00

Week 6 Assignment - Infrastructure Design

Question posted by
Online Tutor Profile
request

Overview

This is the third in a series of five sequential assignments (the course project) in which you continue to act as the Chief Technology Officer (CTO) of a hypothetical e-commerce start-up company of your design.

You have been working on delivering an information technology project plan in anticipation of the company relocating to a new facility.

  • In the first course project deliverable, you created a project plan inception document and supporting Gantt chart.
  • In the second course project deliverable, you developed the business requirements to be incorporated into the information systems design you are creating. You also updated your original supporting Gantt chart based on major and minor tasks identified in the business requirements document.

In this third course project deliverable, you will create an infrastructure design that considers the key elements of software, hardware, security, and business process flow for your e-commerce startup company. You will also use graphical tools to create a supporting data flow diagram (DFD) for your infrastructure design. The infrastructure design provides an opportunity to visualize the key elements and how they are connected for maximum effectiveness.

This assignment consists of two-parts:

Part 1: Infrastructure Design

You will create an 8–10-page infrastructure design document to include key technical elements for your hypothetical e-commerce company’s information systems infrastructure.

Part 2: Updated Gantt Chart

You will use Microsoft Project to again update the supporting project Gantt chart begun in your first course project deliverable:

  • You are not creating a new Gantt chart, only updating the one you created in the previous assignment with the major and minor tasks uncovered while creating the infrastructure design document.

Part 1: Infrastructure Design

Create an 8–10-page infrastructure design document in which you:

  1. Identify the major hardware and software components of your hypothetical e-commerce company's information systems infrastructure.
  2. Design your e-commerce company's hardware (database and proxy servers, network equipment) and software (analytics, big data, API, content management) from a size, scale, type, and interoperability standards perspective.
  3. Document the potential security vulnerabilities and a security design for your e-commerce company.
  4. Use graphical tools to create a data flow diagram (DFD) for your e-commerce company.
  5. Use three sources to support your writing.
    • Choose sources that are credible, relevant, and appropriate.
    • Cite each source listed on your source page at least one time within your assignment.
    • Access the library or review library guides for help with research, writing, and citation.
    • Part 2: Updated Gantt Chart
    • Use Microsoft Project to update the previously created Gantt chart with the major and minor tasks identified in the infrastructure design document.

      Formatting

      This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions. Note the following:

    • The preferred method is for the infrastructure design portion of your assignment to be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
    • Include a cover page containing the assignment title, your name, your professor's name, the course title, and the date. The cover page is not included in the required page length.
    • Include a source list page. Citations and references must follow SWS format. The source list page is not included in the required page length.
Available Answers
$ 35.00

[Solved] Assignment - Database Infrastructure Design

  • This solution is not purchased yet.
  • Submitted On 20 May, 2021 01:19:59
Answer posted by
Online Tutor Profile
solution
Table of Contents Section 1: Design Document............................................................................................................................4 Introduction.........................................................................................................................4 Creation of Database Schema.............................................................................................5 Explanation of Database Schema...................................................................................... 5 Supplier Details................................................................................................................. 6 Product Details.................................................................................................................. 6 Inventory Details............................................................................................................... 6 Purchase Details................................................................................................................ 6 Customer Details............................................................................................................... 6 Creation of Database Tables............................................................................................. 7 Identification of Foreign Keys and Primary Keys............................................................ 8 Fulfillment of Referential Integrity in Database Table..................................................... 9 Database Normalization.................................................................................................... 9 Supplier Details Database Table....................................................................................... 9 Normalized Form in 3NF.................................................................................................. 9 Product Details Database Table........................................................................................10 Normalized Form in 3NF..................................................................................................10 Inventory Details Database Table.....................................................................................10 Normalized Form in 3NF..................................................................................................11 Purchase Details Database Table......................................................................................11 Normalized Form in 3NF..................................................................................................11 Customer Details Database Table.....................................................................................12 Normalized Form in 3NF..................................................................................................12 Entity-Relationship Diagram............................................................................................12 Rationale for ERD............................................................................................................12 DFD..................................................................................................................................13 Rationale for DFD............................................................................................................13 Sample Queries................................................................................................................13 Query for Customer Table Creation................................................................................13 Query for Data Entry into Customer Table.....................................................................13 Screen Layout…………………………………………………………………………..13 Layout for Database Creation………………..................................................................13 Layout for Data Entry into Database………...................................................................14 Conclusion.......................................................................................................................14 Reference List..................................................................................................................15 Appendices.....
Buy now to view the complete solution

The benefits of buying study notes from CourseMerit

Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton
Only 45 characters allowed.
closebutton

$ 629.35