I need help with the following: The project introduction, Business
Requirements, and Gantt Chart (project plan) that I submitted for this
project are attached in the zip file.I need help with coming up a design document and revise the Gantt chart. The requirements are below. No plagiarism. Thanks.This assignment consists of two (2) sections: a design document and a revised Gantt chart or project plan. You must submit both 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.One (1)
of the main functions of any business is to transform data into
information. The use of relational databases has gained recognition as a
standard for organizations and business transactions. A quality
database design makes the flow of data seamless. The database schema is
the foundation 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.Section 1: Design Document1. Write a five to ten (5-10) page design document in which you:a. Create a database schema that supports the company’s business and processes.b. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.c.
Create database tables with appropriate field-naming conventions. Then,
identify primary keys and foreign keys, and explain how referential
integrity will be achieved.d. Normalize the database tables to third normal form (3NF).e.
Create an Entity-Relationship (E-R) Diagram through the use of
graphical tools in Microsoft Visio or an open source alternative such as
Dia. Note:The graphically depicted solution is not
included in the required page length but must be included in the design
document appendix.f. Explain your rationale behind the design of your E-R Diagram.g.
Create a Data Flow Diagram (DFD) through the use of graphical tools in
Microsoft Visio or an open source alternative such as Dia. Note: The
graphically depicted solution is not included in the required page
length but must be included in the design document appendix.h. Explain your rationale behind the design of your DFD.i. Create at least two (2) sample queries that will support the organizational reporting needs.j. Create at least two (2) screen layouts that illustrate the interface that organizational users will utilize.Your assignment must follow these formatting requirements:Be
typed, double spaced, using Times New Roman font (size 12), with
one-inch margins on all sides; citations and references must follow APA
or school-specific format. Check with your professor for any additional
instructions.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 or Dia as an appendix of the design document. All
references to these diagrams must be included in the body of the design
document.Section 2: Revised Gantt Chart / Project PlanUse Microsoft Project or an open source alternative, such as Open Project, to:2.
Update the Gantt chart or project plan (summary and detail) template,
from Project Deliverable 2: Business Requirements, with all the project
tasks.
file_1.docx
file_2.docx
20160809023424proect_plan.pdf
20160809023517proect_plan_chart.zip
Unformatted Attachment Preview
Running Head: Business Requirements
Business Requirements: Initial Version
1
BUSINESS REQUIREMENTS
2
BUSINESS REQUIREMENTS
Reference number:
XDOC11213
Document Control
Change Record
BUSINESS REQUIREMENTS
Date
3
Author
Version
Change Reference
1
Original Version
Reviewers
Name
Position
BUSINESS REQUIREMENTS
Table of Contents
Document Control ………………………………………………………………………………………………… 3
1 Business Requirements …………………………………………………………………………………… 5
1.1 Project Overview ……………………………………………………………………………………… 5
1.2 Background including the current process …………………………………………………… 5
1.3 Scope ……………………………………………………………………………………………………… 6
1.3.1 Scope of Project …………………………………………………………………………………. 6
1.3.2 Constraints and Assumptions……………………………………………………………….. 9
1.3.3 Risks……………………………………………………………………………………………….. 10
1.3.4 Scope Control…………………………………………………………………………………… 11
1.3.5 Relationship to Other Systems/Projects ……………………………………………….. 12
1.3.6 Definition of Terms (if applicable) ……………………………………………………… 13
4
BUSINESS REQUIREMENTS
1
Business Requirements
1.1
Project Overview
5
The project underway is to come up with a new automated system for ABC Adventures
that is capable of managing the firm’s information system efficiently and effectively. The new
system will be more robust in terms of performance since the current system that the company
uses is not more efficient and effective as per the requirement of the company. The automated
system for the company will include the combination of all the company’s computer hardware,
software and all firmware that will be configured and integrated to in order to make the
company’s information system more efficient and effective. The new system will also be able to
facilitate better information handling operation, including communication, computation, process
and storage of the company’s information. The overall service will be a hosted solution which
will encompass software as a service (SaaS), Platform as a Service (PaaS) as well as
Infrastructure as a service (IaaS). The combination of these systems basically will enable high
network capacity, which will efficiently support the company’s operations (Cassidy, 2016).
Since the company operates an online platform, the project will definitely enable smooth
operation of the company since incorporates rapid application and scrum.
1.2
Background including current process
The project is to develop a new information system that runs across multiples platforms
and user friendly. Since the beginning, the company has had inefficient information system that
was not able to handle multiple information overload of the company and this prompted the
company to come up with a new system that is able to handle the company’s information system
efficiently and effectively (Cassidy, 2016).
BUSINESS REQUIREMENTS
6
The goal of the project is to facilitate the operation of the company’s information system by
coming up with a more robust system. The system is also expected to be more advanced in terms
of usage and application of new technologies. Since most consumers of web portals are more
concerned about social sites such as Facebook, Twitter and other commonly used social
websites, the new system has a goal of integrating the new system with social sites such as
Facebook and Twitter.
The new project also aims at improving competitiveness of the company as well; it aims at
improving the productivity of the company through easy navigation by clients and prospective
customers in multiple user environments. Cost is also an important element not only for ABC but
also other companies (Holcombe & Ipate, 2012). The project goal, therefore, is to reduce costs
through automation of the company’s information system and other business process. It is
imperative to note that offering customer self support systems within the company website in
areas such as integration of the website with other social network platforms reduces costs in
terms of time and efficiency.
The IT role in this project is to oversee on the implementation and behavior of the new
system and ensure information system architecture is incorporated within the current system and
their compatibility is evaluated to improve on the performance and efficiency.
1.3
Scope
1.3.1 Scope of Project
Scope refers to a project management process that entails the requirements and objectives
necessary for the completion of a project. Defining the scope of a project allows the chief
information officer (CIO) and the project manager to approximate the costs and the time required
BUSINESS REQUIREMENTS
7
to complete the project. The project scope is a component of the project planning process that
entails identifying and documenting a list of the project objectives, deliverables, costs, tasks and
deadlines (Holcombe & Ipate, 2012). The goal of the project scope describes the boundaries of a
project, develops responsibilities for each team member and sets policies and procedures to be
followed for the completion of the project. In addition, the project scope provides the project
manager with guidelines to be followed when making decisions regarding change requests
throughout the project. When documenting the project’s scope, the relevant stakeholders should
be as precise as possible so as to avoid the occurrence of scope creep, a situation where one or
more project parts end up requiring more resources, work or time because of miscommunication
or poor planning.
The scope of this project includes;
1. Applications
These are programs designed to perform specific functions or tasks for the benefit of the
computer user. Therefore, in order for the CIO and the project team members to meet the
production date, they should implement mobile app, Rapid application and Scrum. ABC
Adventure should develop a mobile application which can be installed on user’s mobile
devices (Holcombe & Ipate, 2012). In addition the implementation of Rapid application
and Scrum will enable the company to adjust its project requirements with a lot of ease and
flexibility.
2. Sites
BUSINESS REQUIREMENTS
8
Social network sites like Facebook and Twitter will be incorporated in the project
implementation. Therefore, the designed information systems should effectively
incorporate with these two sites.
3. Process Re-engineering
Process re-engineering entails drastic redesign of a project’s processes in order to achieve
quality and provide more value to clients. It involves the evaluation and redesign of
workflows between enterprises so as to maximize end-to-end- processes. Process reengineering will involve identifying the processes and prioritizing them based on the
urgency (Huang & Benyoucef, 2013). Furthermore, the process entails integrating
information into real work.
4. Customization
Customization will be limited to HTML5 and Java Script. The designed information system
will only use HTML5 and Java platform. HTML5 is a language used for presenting content
on the website. Java Scrip will be used as the programming language of HTML5.
5. Interfaces
These are shared boundary between separate components of computer exchange
information. The interfaces included are user and software interfaces. The applications of
the designed information system will interface oriented programs. User interface refers to
the interaction between the computer and the user. With the designed information system,
the users will find it easy to create their own their profile.
6. Architecture
BUSINESS REQUIREMENTS
9
The application and technical architecture to be used will be CISCO packet tracer used for
designing the company’s CISCO routers and Wireless Linksys routers for creating the
company’s Wi-Fi connections.
7. Conversion and Testing
The following data and volume will be considered for conversion; user interface data, user
profile data and security data. Testing will entail verifying the data format that can be
converted into another data format.
8. Funding, training and education
Project funding is limited to $ 1 million. The company’s employees and other relevant
stakeholders will be trained in the usage and application of the designed information
systems. ABC Adventure will offer a wide range of training and learning/education
programs.
1.3.2 Constraints and Assumptions
Project constraints
The following constraints have been identified within the project, which has been seen as some of
the reasons that may hinder smooth operation of the project and final implementation and adoption.
Limited venture capital to facilitate the full implementation and operation of the new
system.
Short duration for completion of the project
Limited resources to enable the smooth transition into the new system.
Limited skills to facilitate smooth transitioning to the new system.
BUSINESS REQUIREMENTS
10
Project Assumptions
Before the initiation of any project, the project owners must reach as stand point to identify the
various assumptions that are able to produce a shared understanding of the project success. This is
an important element as it will reduce the project failure rate and provide an efficient foundation
for developing strategies for mitigating the various risks identified within the project an as well it
will help in coming up with the contingency plan. The following assumptions have been identified
in defining the project scope, objects and approach:
New hardware and software is functional
The project scope will not be modified
All the project staff will remain in their current roles within the company
All the IT new infrastructure will be compatible with the customer needs
The project will meet the current and emerging Information technology needs within the
market today.
Application and database modification will be properly scheduled.
The budget allocation for the project will be adequate.
1.3.3 Risks
Risks are those that may affect the project and prevent it from implementation and final
completion. Within the Information technology project, there are varied risks some of which are
preventable while some are unpreventable. It is important to note that risks are inherent virtually
in all technology projects and as such our project is not excluded. In this case, these risks occur in
three primary areas, namely planning phase, people and technology environment. The following
BUSINESS REQUIREMENTS
11
risks, therefore, have been identified as possibly affecting the project in the course of its
progression.
User involvement
Schedule flaws
Specification breakdown
Technology and uncertainty
Staff turnover
Uncontrolled requirement inflation
Lack of executive support
Unrealistic expectations
Changing requirements
Incomplete requirements
The business unit has the sole responsibility to inform the IT of any business initiative that may
impact on the project. Below are some of the business initiatives that may impact on the project.
Venturing into other projects before the final completion of the project started can impact
on the current project of the company.
Setting unrealistic business goals for the project
Failure of the finance function to fully provide the needed resources for the efficient and
effective operation of the project from initiation till completion.
1.3.4 Scope Control
Scope control refers to the process of avoiding and incorporating changes into the project’s
scope baseline. It entails the project management process of monitoring the progress of the
BUSINESS REQUIREMENTS
12
project, determining whether the deliverables will meet the desired requirements, and controlling
the project scope baseline changes. If the project is changed, then the cost and timeline will also
be affected. Scope can be controlled, if the CIO and project team members compare the current
state of the project against the baseline information. If variations are found, then preventive or
corrective actions should be identified and implemented.
Furthermore, scope control ensures that the project is delivered on time, and scope creep is
prevented and avoided. Therefore, in order to control the scope, the actual results should be
compared to the scope requirements and baseline so as to ensure that all the documented scope is
being delivered (Venkatesh, Morris, Davis & Davis, 2003). In this case, therefore, scope control
is important because it thwarts scope change request from crushing the project and ensure that all
the progresses are handled properly. The control of changes to the scope identified in this
document will be managed through the Change Control, with business owner representative
approval for any changes that affect the cost or timeline for the project.
1.3.5 Relationship to Other Systems/Projects
The company is planning to develop an automated and sophisticated information system that will
enable it to manage its operations more effectively and efficiently. The CIO, the project manager
and other team members are planning to develop and install the system that will integrate well
with other existing systems, technologies and software. The developed system should effectively
integrate and fit with other database and interface design (s). The role of the database and
interface design is to import metadata regarding tables, queries and store policies and procedures
for the information stored in relational databases. Therefore, the developed design should
BUSINESS REQUIREMENTS
13
integrate with this system so as to enable it to easily identify features of objects in order to
achieve the mapping and execution requirements, like database triggers and update keys. In
addition, the developed information system should meet all the requirements related to
maintaining its security and networking. Policies and procedures should be put in place so as to
prevent the occurrence of security breaches on the developed design. Furthermore, a wide range
of practices should be adopted in order to manage and prevent unauthorized access,
modification, misuse and/or denial of a system network and other network-accessible resources.
1.3.6 Definition of Terms
• Scope baseline – this is the documented deliverables expected from the designed project.
• Project schedule – this is the tool that shows what work needs to be done, which
resources will be used and the time frame for completion.
• Software – these are programs and other computer applications used by the computer
• Hardware – these are the physical aspects of the computer and other computing devices
• Data – these are information that has been processed by the computing device and has
been translated into a form that is more convenient.
References
Cassidy, A. (2016). A practical guide to information systems strategic planning. CRC press.
BUSINESS REQUIREMENTS
14
Holcombe, M., & Ipate, F. (2012). Correct systems: building a business process solution. Springer
Science & Business Media.
Huang, Z., & Benyoucef, M. (2013). From e-commerce to social commerce: A closer look at
design features. Electronic Commerce Research and Applications, 12(4), 246-259.
Satzinger, J. W., Jackson, R. B. & Burd, S. D., 2010. Systems Analysis & Design in a changing
world, s.l.: Cengage Learning.
Scott Ambler, 2014. The Agile System Development Life Cycle (SDLC), s.l.: Ambysoft..
Venkatesh, V., Morris, M. G., Davis, G. B., & Davis, F. D. (2003). User acceptance of information
technology: Toward a unified view. MIS quarterly, 425-478.
Running Head: Project Introduction
Project Introduction: Section1
1
NETWORK DESIGN
2
ABC Adventures is an innovative e-Commerce, start-up company that a venture capital
group has funded. Currently the company has a semi-automated system through which the firm
manages its information needs. At present the has merely one computer and stand alone
application and the system experiences a set of problems. Therefore the firm hired CIO to carry
out analysis and submit a project plan to upgrade the systems. Thus, the aim of this report is
accurate to carry out this analysis and clearly propose the project plan for the system.
The Object of this report is to help ABC Adventures to remove the problems faced by them, with
the help of the new system. For this, proper specifications for a new automated information
system would be developed and implemented by the new system. As the Chief Information
Officer (CIO) of the company, I have been asked by The CEO to submit my plan well within
sixty (60) days to deliver an information technology project plan in anticipation of the company
acquiring the new systems. Since this is a start-up company, there is currently no building or
technology infrastructure to support the business. All information technology (hardware and
software) must be implemented in either a hosted solution, on-site solution or a hybrid model.
The CEO is expecting you to integrate different technologies from different partners and
incorporate industry best practices in connection with the development of technological systems.
The new facility is a two-story stand-alone building. The company currently consists of ten (10)
employees with revenues of $5 million, but is expected to grow to thirty (30) employees with
revenue of $30 million over the next two (2) years.
At the moment the company is involved in travel booking using the online web based
application. Along with this the company plans to launch a mobile app which can be installed on
the client’s Smartphone or a mobile device. In this mode the company wishes to do the business
as it is always easier and convenient from the client’s standpoint. With this the company wishes
NETWORK DESIGN
3
to do the business as the market survey reveals that having an eCommerce website tends to
increase the number of business transactions, especially for the companies in the travel business.
The company has asked the CIO to develop a very innovative plan for the new application so
that the company has a definite competitive edge and the application should be very user friendly
and ergonomically designed.
CIO wishes to propose the new plan for the system which is not only advanced, in terms of
usage of modern and innovative new technologies, but, also most advanced design methodology
like Rapid application and Scrum. It is also well known that nowadays, usually the sites are
linked to the Social sites like Facebook & Twitter, so the new web design must integrate well
with these sites. At times users are more likely to login to the eCommerce sites with their
Facebook credentials and in that case they have to remember the less number of passwords. So
these features will be accommodated in the new system design plan. With the advent of smart
ways to attack through the security of a system, safe and secure design considerations will be
undertaken in the development. Users’ inputs like their personal profiles, any bank related
information and trip related details need to be maintained with utmost security and privacy.
As a senior IT Resource person, the CIO is well aware that the convention databases are
unable to support huge data and the volume in which the data arrives. With lots of analytics used
by the companies, as well as multiple formats of the data like multimedia formats, vi …
Purchase answer to see full
attachment
Recent Comments