Fluent Essays

Week 10 Final Project Submission Click the link above to submit your assignment. Students, please view the Submit a Clickable Rubric Assignment in the Student Center. Instructors, training on how to grade is within the Instructor Center. Final Project: Project Plan Due Week 10 and worth 300 points This assignment consists of three (3) sections: a written project plan, a revised Gantt chart or project plan, and a project plan PowerPoint presentation. You must submit the three (3) sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment. While taking all business and project parameters into consideration, make quality assumptions to support the following requirements. Section 1: Written Project Plan You are now in the final stage of the project plan development. All previous documentation will be combined into one (1) document that will serve as the statement of work for the project. Your goal is to have the project approved by the executive team and the venture capital group. The project plan is very detailed which is appropriate to accomplish the monumental task of implementation. However, the executive team is only interested in a ten (10) minute summation. Therefore, you also must create a compelling executive summary that is supported by your detail that convinces the executive group that your solution is optimal. 1. Write an eight to ten (8-10) page executive summary in which you provide a high-level technical overview of your project where you address the following: a. a. Describe the scope of the project and control measures. b. Describe the goals and objectives of the project. c. Give a detailed, realistically estimated cost analysis of the entire project. d. Relate the value of the project plan solution to the competitive advantage that information technology will afford your organization. e. Provide all aspects of the information technology implementation into the project plan. f. Use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements: · This course requires use of  Strayer Writing Standards (SWS) . The format is different than other Strayer University courses. Please take a moment to review the SWS documentation for details. · Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. · Include charts or diagrams created in MS Visio and MS Project as appendix of the Word document. Make reference of these files in the body of the Word document. Section 2: Revised Gantt Chart / Project Plan Use Microsoft Proje1 OnBuy E-Commerce Project: Infrastructure and Security Policy Document Tom Anderson Professor Urimindi February 28, 2021 OnBuy E-Commerce Project: Infrastructure and Security Policy Document a. Logical and Physical Typographical Layout of the Network Table 1 Logical Diagram Table 2 Physical Network Typographical Diagram b. Possible Placement of Servers The e-commerce platform will utilize multiple servers to provide products and services on the internet. The utilization of many servers plays an integral role in improving the performance and robustness of a network system (Sahoo et al., 2016). Therefore, the number, location, and distribution of the servers significantly influence the performance and reliability of the e-commerce platform. In this case, the server placement will be determined based on the need to distribute service requests to the servers according to the measured response time of each server. As the internet is projected to grow phenomenally in the next few years, the increasing number of services on the internet will become indispensable to the company’s clients. Thus, the organization will provide its products and services on the internet using multiple servers in order to improve performance and robustness. For that reason, server placement will be an important factor in the quality of the firm’s services. While the best-server selection will be assumed for the firm’s server placement, it will not necessarily be the case for many services that the company will use, such as the Domain Name System. Thus, different selection mechanisms will inform the process of placing servers. For all the user groups to receive good performance, it will be important to place servers close to them since some servers could be very far on the internet. Additionally, the availability of services will be increased by enabling the users to switch to an alternative server if needed. In case the nearest server fails, or its performance declines, the users will need to choose another server to continuously receive the services in good quality. The organization will collaborate with internet service providers to provide effective system-wide performance. Load-sharing among the servers will also be considered an important part of the server placement process than the performance from the administrator’s perspective. Thus, there will be a need to take an additional server to minimize the load of heavily loaded servers. The location of the new servers will be selected in a way that distributes the service load appropriately. Moreover, it will be necessary to take into consideration the potential impacts of the placement on the performance as perceived by the users as well. This implies that the server placement process will not sacrifice the overall system’s performance due to the loading distribution. The placement process will be guided by server selection algorithms. When sets of servers for the organization areDATABASE AND PROGRAMMING DESIGN 1 Database and Programming Design Tom Anderson Professor Urimindi February 14, 2021 Table of Contents A. Database Schema That Supports the Company’s Business and Processes…………………..3 B. Explanation of the Database Schema………………………………………………………...3 C. Database Tables……………………………………………………………………………....4 D. Normalize the Database Tables to Third Normal Form (3NF)………………………………9 E. Create an Entity-Relationship (E-R) Diagram………………………………………….……10 F. Explaining Rationale behind the Design of the E-R Diagram……………………….………11 G. Data Flow Diagram (DFD)……………………………………………………………….….12 H. Explaining the Rationale behind the Design of the DFD……………………………………13 I. Two (2) Sample Queries……………………………………………………………………...13 J. Two (2) Screen Layouts ……………………………………………………………………...14 K. References………………………………………………………………………………...….15 Part One: Database and Programming Design a. Database Schema that Supports the Company’s Business Processes b. Explanation of the Database Schema The process of developing OnBuys e-commerce website may encounter challenges due to a lack of database standards that define the design and application of the database systems. To avoid the challenge of a lack of database, this particular project will be guided by a database schema based on the Database Task Group (DBTG) standards. Therefore, the above database schema comprises three major components: a database schema, a subschema, and a database management language. A schema refers to the databases conceptual organization as viewed by the Database Administrator (Angrish et al., 2017). It includes a definition of the database name, the type of each record, and the components, which are the fields or columns that make up the records. The above database schema has entities and their respective attributes. Entities refer to the essential items in any data model. It is a thing or an object in the real world that can be distinguished from all other objects. Entities can be viewed as the real-world atomic item. For example, in the above schema, entities include an invoice, address, credit card, and user account. Each of the uniquely identifiable instances of an entity type in the diagram is an entity occurrence or entity instance. Each entity has a name and a list of properties, as indicated in Figure 1. For instance, the properties of credit card include credit card number, holder’s name, and the expiry date. Therefore, while each entity type of attributes, they will alcove their values for each attribute. Additionally, each entity will have relationships with others. For instance, the relationship between invoice and user satisfaction allows the system to compute the purchasing rates, which include the number of sessions that emerge from the invoice, and eventually, an actual order. c. Database Tables with Appropriate Field Naming Conventions A database table refers to a collection of stored data that are managed by the database management syOnBuy E-COMMERCE PROJECT 2 OnBuy E-COMMERCE PROJECT PROPOSAL Tom Anderson Professor Urimindi February 1, 2021 Contents DEFINITONS 3 PROJECT SCOPE 4 Project Justification 4 Product Scope 4 Business Objectives and Project Goals 6 PROJECT SCOPE CONTROL 7 RISKS 9 CONSTRAINTS 9 SYSTEM INTEGRATION 10 Data Integration 10 Network and Security Integration 11 References: 12 DEFINITIONS · API: Application Programming Interface-a computer application that facilitates the interaction between software intermediaries · CMS: Content Management System is a software that facilitates the management of the information and data on the website, as well as the creation of new websites · Data Integration: It is the process of combining a database, or several databases with an already built website · Database Management System: A system software used in the management of data, including the process of cataloging, running queries, storage, and retrieval of data · Interface Design: the process of modeling and building the interaction outlook of software, or an application · LAN: Local Area Network- a system of interconnected computer nodes within a defined location, such as a building PROJECT SCOPE Project Justification OnBuy is an eCommerce business startup aiming at the sale of goods through an online platform. The eCommerce starts up intends to develop an online platform that will facilitate the sale of goods. OnBuy will adopt a business to consumer and business to a business model. The placing of orders and the sale of goods will be to other businesses and consumers, respectively. The businesss primary requirements will involve the development of a website with an online catalog, the design and the development of a database, and the necessary networking infrastructure to support the business. Additionally, there will be a need for physical stores facilitating warehousing services; and effective supply chain management to deliver the goods to the customers. For the above reasons, OnBuy is transitioning its services to an online platform, which will harbor its information systems. This fit will be achieved through three tiers in the project. The first will involve the design, creation, and installation of a database management system, which will serve as the central point of management for the eCommerce business. The second will involve creating an onsite information management system composed of a detailed and extensive graphical interface designed to support all the required eCommerce services. The third tier will include developing network infrastructure and security policy that will sustain the information management system. Product Scope The database management system will be the primary transitioning of the startup business. The necessitated online platform will require an information management system, and the central focus for the information management system is the database. This involves the method and infrastructure definition for Running head: PROJECT PLAN INCEPTION 1 PROJECT PLAN INCEPTION 2 OnBuy Information Systems Report Tom Anderson Professor Urimindi January 17, 2021 OnBuy is an e-commerce startup group that requires to set up its offices and network structure to ensure that it can effectively dive into the task of making commodity available to its consumers. The startup intends to move into a new environment and set up its business premises to ensure that customers diverse needs. Below is a description of the information systems required by OnBuy to be able to undertake its required task within the community efficiently. Databases play a crucial role in allowing customers to place orders complemented by the virtual shop successfully. Nonetheless, databases ensure that the system operates optimally in utilizing the business logic that ensures that all the various relationships between the objects are addressed to facilitate effective reporting and data analytics. The database structure should ensure that the database structure is simple and components ability to exist individually. Nonetheless, the database design entails normalization of the tables to ensure that data redundancy is maintained, resulting in better results due to the utilization of a well-structured database. Nonetheless, various architectures play a vital role in ensuring that some of the database updates are efficiently undertaking the event-driven placing of an order using the shopping cart. A well-structured database will ensure that the organizational inventory can perform analytics reports regarding which commodities are highly purchased by the customers. System analysis entails ensuring that the software can be successfully deployed into the organizations operations to ensure that the customers diverse business wants are satisfied (Duran, 2018). Therefore, it is efficient for various components of the organization to be devolved to ensure that there is a database administrator and system administrator. The database administrator will allow the respective authorization to employees of the organization based on the roles they are intended to achieve while working for the organization. Equally, he is responsible for producing reports suggesting which areas of concern need to be addressed. On the other hand, the system admin will monitor the system resources and restrict access to some system and organizational resources based on the assigned employee roles by the human resources department. System security and data security are vital in a digital era where cybercrime and denial of service attacks are rising. Therefore, as the CTO of OnBuy, I will ensure that high levels of security are maintained by ensuring that the ICT policy is constantly updated and utilizes various levels of firewalls to ensure that organizational data and customer information are securely stored. To eliminate security threats at the point of entry of the internet into the organization, a firewall is p