Database and Data Warehousing Design

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 DocumentRead the attached PDF file and Write a six to ten (6-10) 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 format. Include a cover page containing the title of the assignment, the student?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 PlanUpdate the attached project plan (summary and detail) template with three to five (3-5) new project tasks each consisting of five to ten (5-10) subtasks.
database_and_data_warehousing_design_pdf.pdf

revised_project_plan.xls

Don't use plagiarized sources. Get Your Custom Essay on
Database and Data Warehousing Design
Just from $13/Page
Order Essay

Unformatted Attachment Preview

Running Head: PROJECT PLAN INCEPTION
1
Project Plan Inception
Introduction
Project planning is the core of a project’s lifecycle which reveals to everyone involved the
roadmap towards specific goals of a project and the means by which the goals and objectives of
the project will be achieved. Project planning is crucial for the purposes of creating a set of plans
to provide guidance in the entire phases of implementation and closure of a project.
Alternatively, plans created help in the effective management of costs, time, risks, changes and
quality. Besides preventing project creep, project planning enables efficient control of human
resource and external suppliers so that a project is delivered within the budget estimates and
within schedule.
Therefore, the purpose of this paper is to clearly outline a project plan for Cyton
Financial Services which deals with providing financial solutions to end users, whose operations
are innovative and internet-based. The project plan includes the background information of
Cyton Financial Services and the daily business activities that the company is involved in.
Besides the offshoring and outsourcing activities of the company, a detailed description of the
information systems that the company currently has to support the business will be provided.
Background Information on the Company
Cyton Financial Services is an innovative internet based company which provides
financial solutions to various end users. By the use of financial control and automation platforms,
Cyton Financial Services serves a large network of clients as well as manages internal
communication among its employees. Cyton Financial Services provides services related to
financial trading and saving to clients. Furthermore, the company provides advice on effective
management of finances and possible investments individuals can venture in, both in the short
PROJECT PLAN INCEPTION
2
term and long term. Cyton Financial Services has a matrix organizational structure headed by a
Chief Executive Officer and a Chairperson. Besides there are various departments such as
Communications department, Operations, and Customer Service Department, Treasury and
Forex Management department, Risk Management department, Inspection Department and the
Human Resource Department.
Details Regarding the Business Activities the Company is Involved in
The business activities of Cyton Financial Services on a daily basis include; suggestions
to customers on financial savings and investments to venture in the short and long term. These
suggestions are provided in an attempt to help their clients set financial goals. Furthermore,
Cyton Financial Services provides suggestions related to trading to its end users. In so doing, it
engages its clients in the buying and selling of securities and other financial instruments. The
company has an online role of providing financial advice that is designed to facilitate business
operations to its end users in various aspects such as; equity offerings, capital expenditure,
brokerage for investors and the management of mergers and acquisitions (Georgescu & Jeflea,
2015).
The company provides the most frequent and commonly recognized financial services in
the storage of finances, making payments and providing loans to its clients. It is also a mandatory
obligation for the company to provide assistance to its clients in the efficient and effective
management of their portfolio through which clients manage to execute the activities earlier
mentioned (Georgescu & Jeflea, 2015). Lastly, being a financial institution with a wide network
of resources, part of the daily business activities is to manage both the human and information
resources which contribute to the overall performance of the company (Georgescu & Jeflea,
2015). Daily business activities of Cyton Financial Services are highly dependent on Information
PROJECT PLAN INCEPTION
3
technology as executed by Human Resource. Therefore, the Communications Officer and
Human Resource Manager oversee this respectively.
Outsourcing and Offshoring Opportunities
Being an innovative internet based company that provides financial solutions to its end
users; Cyton Financial Services outsources a variety of its resources to promote its daily business
activities. Most importantly, the company outsources information resources while striving to
meet requirements of corporate governance. Besides financial and cost benefits, Cyton Financial
Services outsources its information resources to reduce uncertainties and risks associated with
the management of its own technology. Specialization, which guarantees the access to services
of higher quality, is an additional inspiration for outsourcing information technology resources
by Cyton Financial Services (Akram, 2011).
Cyton Financial Services also outsources its systems. This includes the enhancement and
maintenance of software package, database and data warehouse systems as well as cloud
computing. With the implementation of the current database systems, there is an improvement in
data access just by running simple queries. For instance, to identify a specific task performed on
a particular day, the database system easily identifies this type of information. Furthermore,
improvement in the sharing of data and minimization in data inconsistencies are potential
opportunities for the company’s outsourcing activities. There is a valid reduction in duplication
of data which maintains the integrity of data with fewer inconsistencies (Georgescu & Jeflea,
2015). This has helped to enhance customer trust and satisfaction, which positively contributes to
the overall performance of Cyton Financial Services. Outsourcing database systems guarantee
the ability of multiple users to simultaneously access data upon modifications. This corresponds
to an improvement in the levels of data sharing within the company.
PROJECT PLAN INCEPTION
4
Description of Current Information Systems the Company Has to Support the Business
Owing to the variety of business activities currently provided by Cyton Financial
Services, Currently, Cyton Financial Services has a Business Intelligence information system
which operates on a single mainframe computer. This information system is internet-based and
tracks the activities of customers and employees within the organization. The implementation of
the aforementioned database systems in Cyton Financial Services contributed to the
improvement of decision-making processes (Akram, 2011).
The availability of consistent data that positively influence decision-making processes in
Cyton Financial Services has so far made the entire company manageable and upfront. The
productivity of end users is enhanced by the Business Intelligence information system, which
allows customers to easily perform various functions in inserting, updating or deleting data
through simple questions. A significant improvement in data manipulation is evident in Cyton
Financial Services owing to current information systems. End users can access data in a fast and
timely basis whose integrity is well maintained (Akram, 2011).
Conclusion
This paper critically analyzed the background information of Cyton Financial Services
and the daily business activities the Company engages in. Furthermore, it provided details on the
current information system the company has which supports its business activities. The
description of the business activities and current information systems of Cyton Financial
Services reveals the level to which the current businesses within the organization are supported
by the information systems. Information systems need to support the business-related activities
of organizations if goals and objectives must be attained. However, the company can perform
PROJECT PLAN INCEPTION
better should there be an improvement in the Information Technology resources as later
addressed in this project.
5
PROJECT PLAN INCEPTION
6
References
Akram J. K., (2011). The Significance of Management Information Systems for Enhancing
Strategic and Tactical Planning. Available at
http://www.scielo.br/pdf/jistm/v8n2/v8n2a11.pdf Accessed on 14/1/2018.
Georgescu M., and Jeflea V., (2015). The Particularity of the Banking
Information System. Procedia Economics and Finance. Available at
https://www.researchgate.net/publication/273578876_The_Particularity_of_the_Banking
_Information_System. Accessed on 14/1/2018
Organization: (Enter Company, Division, Department, Group, Team
etc)
Description: (Enter Brief Description of requested work)
Estimator: (Enter name of Estimator(s))
Date Required By: (Enter Date Estimate is needed by)
Completion Date: (Enter date you completed estimate)
Work Estimation Details
Activity/Task
SDLC Phases
Name: (Enter Project, Initiative,Title, Name etc)
ID No: (Enter Project or Time Tracking Number, etc)
Estimate Valid For: (Enter nnn days, weeks or months)
Purpose: (Enter Information about estimate purpose; Feasibility, Business Case, Scheduled Project etc)
Authorizer: (Enter Name, Title, Phone and Email address)
Requestor: (Enter Name, Title, Phone and Email address of Requestor)
Requested Date: (Enter Requested Date)
Optimistic
Effort Hrs
Most Likely Pessimistic Confidence
Effort Hrs
Effort Hrs
5.0
3.0
4.0
Status Meetings
7.0
8.0
6.0
Status Reporting
4.0
6.0
8.0
Requirements/Scope Review
8.0
6.0
19.0
Resource Requirements Review
3.0
5.0
17.0
14.0
16.0
15.0
13.0
16.0
19.0
16.0
18.0
21.0
Application Impact Analysis
2.0
34.0
32.0
Technical Design Development
5.0
3.0
4.0
Logical Database Design
7.0
8.0
6.0
Prototype Presentation
4.0
6.0
8.0
18.0
Initiation/Administration
Factor
75%
85%
95%
99.5%
Supporting Document Links: (Enter Links to Requirements,
Confidence Confidence Confidence Confidence Specifications, or other supporting documents in this column)
-0.17
-0.17
0.67
3.50
7.50
6.00
3.33
7.33
6.67
3.17
7.17
7.33
3.00
7.00
8.00
1.83
2.33
8.50
6.67
10.33
9.00
12.17
11.33
14.00
13.67
0.17
15.50
15.67
15.83
16.00
1.00
0.83
5.00
16.00
18.17
28.33
17.00
19.00
33.33
18.00
19.83
38.33
19.00
20.67
43.33
-0.17
-0.17
0.67
3.50
7.50
6.00
3.33
7.33
6.67
3.17
7.17
7.33
3.00
7.00
8.00
1.67
-0.50
0.17
1.50
1.33
2.00
8.33
3.83
5.50
5.17
8.00
9.33
10.00
3.33
5.67
6.67
9.33
11.33
11.67
2.83
5.83
8.17
10.67
13.33
13.33
2.33
6.00
9.67
12.00
15.33
0.67
-1.50
0.67
-1.50
-1.83
21.67
17.17
21.67
17.17
21.83
22.33
15.67
22.33
15.67
20.00
23.00
14.17
23.00
14.17
18.17
23.67
12.67
23.67
12.67
16.33
1.50
1.33
2.00
5.17
8.00
9.33
6.67
9.33
11.33
8.17
10.67
13.33
9.67
12.00
15.33
0.67
-1.50
21.67
17.17
22.33
15.67
23.00
23.67
12.67
328.17
346.67
351.00
383.67
Planning
Assumptions and Constraints Specification
Analysis
Functional Impact Analysis
Process Model Review and Update
Functional Requirements Specification
Design
Design Acceptance
8.0
6.0
Coding
3.0
5.0
Unit Testing
Construction
4.0
6.0
5.0
Test Plan Updates
3.0
4.0
12.0
Test Data Validation
8.0
6.0
16.0
6.0
8.0
18.0
Test Environment Setup
13.0
25.0
17.0
Test Plan Finalization
24.0
16.0
15.0
QA Testing
13.0
25.0
17.0
Documentation Validation
24.0
16.0
15.0
Integration Testing
23.0
24.0
12.0
Final Documentation Review
3.0
4.0
12.0
Deployment Dress Rehearsal
8.0
6.0
16.0
Internal Staff Training
6.0
8.0
18.0
Post Production Warranty Support
13.0
25.0
17.0
Post Implementation Reviews
24.0
16.0
15.0
271.00
329.00
382.00
Software Configuration Management
Release/Build Updates
Technical Documentation
User Documentation
Testing
Performance Testing
Implementation
Deployment Support
Support
Work Estimate Totals
Estimate Assumptions: (Enter Assumptions here and number them)
Estimate Constraints: (Enter Constraints here and number them)
Estimate Risks:
(Enter Risks here and number them)
Notes:
(Enter Special Instructions, Notes, etc here)
20180208185120revised_project_plan.xls
Generated by
W A Holscher Consulting Inc

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP