Project Deliverable 3: Database and Data
Warehousing Design
Due Week 6 and worth
120 points
This assignment
consists of two (2) sections: a design document and a revised 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 it
is written for. Additionally, you may create and / 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 of
relational 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 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. Since your company is an innovative Internet-based
company, movement toward data warehousing seems to be one of the most viable
options to give your company a competitive advantage; however, these concepts
must be explained to the executive board in a manner to garner support.
Section 1: Design
Document
Write a six page
design document in which you:
1. Support the
need for the use of relational databases and data warehousing. From a
management standpoint, it may be important to show the efficiencies that can be
gained for executive oversight.
2. Create a database
schema that supports the company’s business and processes. 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.
3. 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).
4. Identify and
create an Entity-Relationship (E-R) Diagram relating the tables of the database
schema 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. Explain your rationale behind the design of the E-R
Diagram.
5. Identify and
create a Data Flow Diagram (DFD) relating the tables of your database schema
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. Explain the rationale behind the design of your DFD.
6. Illustrate the
flow of data including both inputs and outputs for the use of a data warehouse.
The diagram should map data between source systems, operational systems, data
warehouses and specified data marts. Note: The graphically depicted solution is
not included in the required page length.
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
Project Plan
Use Microsoft Project
to:
1. Update the
project plan (summary and detail) template, from Project Deliverable 2:
Business Requirements, with three to five (3-5) new project tasks each
consisting of five to ten (5-10) subtasks.
The specific course
learning outcomes associated with this assignment are:
·
Describe the methods and best practices in implementing process
change in IT organizations.
·
Describe the role and methods of technology-induced process
improvement in organizations.
·
Use technology and information resources to research issues in
information systems.
·
Write clearly and concisely about leadership issues and
strategic insight of the Information systems domain using proper writing
mechanics and technical style conventions.
business_requirement_project_deliveable_2.docproject_deliverable_1_complete.docxProject Deliverable 2: Business Requirements
Otis Norton
Professor Gregory S. Hart, PhD
CIS 590 Directed Research Project
January 31, 2016
1
BUSINESS REQUIREMENTS
Reference number:
2
Document Control
Change Record
Date
Author
Version
Change Reference
28th January
2016
Otis
Norton
1.0
1.0.1
Reviewers
3
Name
Position
XXXX
YYYY
Table of Contents
Document Control ………………………………………………………………………………………………………………………… 3
1
4
Business Requirements …………………………………………………………………………………………………………… 5
1.1
Project Overview ……………………………………………………………………………………………………………. 5
1.2
Background including current process ………………………………………………………………………………. 5
1.3
Scope ……………………………………………………………………………………………………………………………. 6
1.3.1
Scope of Project ………………………………………………………………………………………………………. 6
1.3.2
Constraints and Assumptions ……………………………………………………………………………………. 7
1.3.3
Risks ……………………………………………………………………………………………………………………… 7
1.3.4
Scope Control …………………………………………………………………………………………………………. 8
1.3.5
Relationship to Other Systems/Projects ………………………………………………………………………. 8
1.3.6
Definition of Terms (if applicable) …………………………………. Error! Bookmark not defined.
1
1.1
Business Requirements
Project Overview
The project is to merge two companies together. An Internet based
company with revenue of $35 million has decided to merge with other
company. The project is to strategically integrate these two firms. The
company would be expanding from one floor to three floors in six
months. The project is to develop the IT and other infrastructure that can
support the operations of both the companies. It is expected that the
information technology (hardware and software) must be redesigned to
meet organizational needs
1.2
Background including current process
Describe the background to the project, (same section may be reused in
the Quality Plan) include:
Background: The organization is an Internet based company with focus
on innovation and growth. The company has a good growth rate and it
has decided to merge with a multinational company.
Current Processes: In the current environment, the company uses
operational systems and relational databases. The company is able to
manage its business operations and business activities with relational
database
This project is to merge two companies together. An Internet based
company with revenue of $35 million has decided to merge with other
company. The project is to strategically integrate these two firms. The
current employee strength of the company is 25. It is expected that this
employee strength would increase to 60 after the merger.
The project goal is to ensure that the merger is achieved without any
hindrance.
The IT role for this project is to design the IT infrastructure that could
meet the needs of organization after the merger. The Information
Technology should be a common function across the merged
organization that could provide support to varied technologies.
5
1.3
Scope
1.3.1 Scope of Project
The company would have three options to manage the infrastructure in
the new system. The first solution is hosted solution, the second option is
on-site solution and the third option is hybrid model. The scope of the
project is to explore these areas and recommend the suitable solution to
the company.
Applications
In order to meet the target production date,
only these applications will be
implemented: web portals of the company,
internal applications of the company, and
business critical applications.
Sites
These sites are considered part of the
implementation: customer facing sites, and
business critical sites
Process Re-engineering
Re-engineering will focus on to
reengineer the internal IT operations of the
company to a cloud-based model
6
Customization
Customizations will be limited to the
implementation of a cloud-based system.
Interfaces
the interfaces included are: all the
interfaces required to support the cloud
implementation.
Architecture
Application and Technical Architecture
will be moved to a cloud base system
Conversion
Only the following data and volume will
be considered for conversion: operational
systems and relational databases would to
expand into data warehousing
Testing
Testing will include only: Unit Testing,
System Testing, System Integration
Testing, and UAT (User Acceptance
Testing)
Funding
Project funding is limited to $100,000
Training
Training will be given to all the employee
of the company
Education
Education will include training and
development
1.3.2 Constraints and Assumptions
The following constraints have been identified:
•
One of the constraints would be the cost constraint. An effective
budget would be required to overcome this constraint
•
Another constraint would be time constraint
•
To provide training to 65 to 70 employees would also be a constraint
The following assumptions have been made in defining the scope, objectives and
approach:
•
It is assumed that employees of both the firms would cooperate to
support the development of new IT system.
•
It is assumed that cloud based system is best for the firm
•
It is assumed that change management would be minimal
•
It is assumed that tools and technologies, infrastructure, hardware
and software would be made available. The time would not be wasted
in these trivial tasks.
•
It is assumed that business stakeholders would be available to explain
the business flows
•
It is assumed that all the dependencies on business SME would be
resolved within three working days
1.3.3 Risks
The following risks have been identified as possibly affecting the project during
its progression:
7
•
Social Risks: In this project, two organizations would be merged to a
new entity. The change management risk would be one of the biggest
risk in this project. There is always a possibility that the employees of
both the organizations may not accept the other employees and the
change.
•
Political and Legal Risks: It is crucial that the merger should adhere
to all the political and legal guidelines in the system. The merger may
be incomplete if it lacks adherence to any legal guideline or political
regulations.
•
Financial Risks: It is assumed that the budget for this project
would be $100,000. The financial risks is always a big risk in
these kinds of project as future is always uncertain.
•
Technological Risks: It is assumed that a cloud-based
implementation would be done as part of this project. The cloudbased solutions and hosting on cloud would be a new thing for the
company. There is always a possibility that this strategy may fall
back.
1.3.4 Scope Control
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 cost or timeline for the
project. It is expected that all the approvals from come from CEO.
1.3.5 Relationship to Other Systems/Projects
It is the responsibility of the business unit to inform IT of other business
initiatives that may impact the project. The following are known business
initiatives: business strategy development of merger of two
organizations, strategy for future growth, and the future vision of merged
company.
8
2 References
Dawson, P., Spedding, T., Sohal, A., Daniel, L., & Clements, M. (2012). Information
technology decisions, operations management and change: RFID and supply chain
collaboration.
Mithas, S., Tafti, A. R., Bardhan, I., & Goh, J. M. (2012). Information technology and
firm profitability: mechanisms and empirical evidence. Mis Quarterly, 36(1), 205-224.
Prajogo, D., & Olhager, J. (2012). Supply chain integration and performance: The effects
of long-term relationships, information technology and sharing, and logistics
integration. International Journal of Production Economics,135(1), 514-522.
9
Project Deliverable 1: Project Plan Inception
Otis Norton
Professor Gregory S. Hart, PhD
CIS 590 Directed Research Project
January 15, 2016
Introduction
With time, Information Technology has emerged as an important organizational function
and today; organizations are expected to manage ITPM (Information Technology Project
Management) to gain efficiency and effectiveness in the business (Clements, 2012). An Internet
based company with revenue of $35 million has decided to merge with other company. It is
assumed that I am the CIO (Chief Information Officer) of this Internet based company and I have
the responsibility to develop a project plan to strategically integrate all systems, including
databases and infrastructure. The CEO is expecting me to integrate different technologies from
different solution providers and incorporate industry best practices in connection with the
development of technological systems. The objective of this paper is to document the current and
the present state of the Internet based organization. It is assumed that the project would start
from 1st Feb 2016. A brief organizational background can be discussed as:
Organizational background
The organization is an Internet based company with focus on innovation and growth. The
company has a good growth rate and it has decided to merge with a multinational company. I
have the responsibility to develop the information technology project plan in 60 days. There
would be structural and other changes in the company. The size of the company would increase
in terms of number of employees and the area of the company would increase from one floor to
three floors. The business activities of the company can be discussed as:
Business activities of the company
The company is an Internet based company that provides digital services to its clients.
This business is a growing business as there is number of opportunities in the market. It is
expected that market would continue to grow in this area as more and more clients adapt
digitization. The business activities of the company also include providing cloud solutions to its
clients as it operates in the field of Internet. In order to manage its business activities, the
company can use outsourcing, offshoring or in-house development. The outsourcing and
offshoring for this company can be discussed as:
Outsourcing and Offshoring opportunities
Whenever a company expands or its merged with other company, the management of the
company has to take an important decision with respect to outsourcing and offshoring. It is
recommended that the core business activities of the company should not be outsourced and the
support activities of the company should be outsourced. The offshoring could be a risky area for
the company, as it would have a direct impact to manage its operations if it uses offshoring
(Bardhan, 2012). It is also important that outsourcing should be minimal in the initial period of
the merger. In a gradual manner, the company should include its emphasis on outsourcing. Once
the company has a defined outsourcing strategy, and then it should start to focus on offshoring.
The decision of outsourcing and offshoring would also depend on the current information
systems used in the company. The current information systems used in the company can be
discussed as:
Current information systems in the company
In the current environment, the company uses operational systems and relational
databases. The company is able to manage its business operations and business activities with
relational database. In the future state, the company wants to use data warehousing. In order to
bring about this change in the company, the existing hardware and software should be changed.
The company would have three options to manage the infrastructure in the new system. The first
solution is hosted solution, the second option is on-site solution and the third option is hybrid
model.
It is recommended that the company should use cloud system to manage its operations. In
this era, organizations have started to focus on cloud-based solutions. There are various benefits
of cloud-based solutions. The initial set up cost would be less in cloud-based solution. The
integration of different technologies would also be easy in cloud-based solutions. It is important
that the company should also focus on virtualization. There could be two levels of virtualization,
product virtualization and service virtualization. It is recommended that the company should
focus on both product virtualization and service virtualization. It is correct to say that there
would be certain issues associated with cloud computing and virtualization. However, these
security issues could be overcome with the use of encryption and firewalls. The security issues
could be avoided with the use of a private cloud. It is recommended that the company should
have a dedicated and private cloud.
Conclusion
The above paper discussed the current state of organization, prior to any development or
enhancements. The plan to develop the new system or to transition into the new system should
have four major phases (Olhager, 2012). The first phase would be the assessment phase; this
would be the blueprinting phase in which the blueprinting of entire project would be done. The
next phase would be framework development phase. In this phase, the high level plan is
developed and inputs from various stakeholders are collected. The third phase would be actual
implementation phase in which actual implementation would done. The last phase would be
continuous improvement phase. The objective in this phase would be to continuously improve IT
infrastructure and operations.
References
Dawson, P., Spedding, T., Sohal, A., Daniel, L., & Clements, M. (2012). Information technology decisions,
operations management and change: RFID and supply chain collaboration.
Mithas, S., Tafti, A. R., Bardhan, I., & Goh, J. M. (2012). Information technology and firm profitability:
mechanisms and empirical evidence. Mis Quarterly, 36(1), 205-224.
Prajogo, D., & Olhager, J. (2012). Supply chain integration and performance: The effects of long-term
relationships, information technology and sharing, and logistics integration. International Journal of
Production Economics,135(1), 514-522.
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.