Comprehensive Data Analysis Report: Orinoco.com Database & Excel

This report analyzes data from Orinoco.com, covering database management using MS Access, Excel-based sales calculations, and information systems. It includes the creation of database tables, queries linking customer, order, and product data, and the generation of a monthly sales report. The report uses Excel to calculate total and average sales, predict future sales based on growth rates, and create graphs visualizing sales trends. Additionally, it describes the application of different information systems, including DSS, MIS, TPS, and KBS, at different organizational levels. The analysis provides insights into data organization, reporting, and the use of information systems for business decision-making.

Research & database

Table of Contents
INTRODUCTION...........................................................................................................................3
Question : 1......................................................................................................................................3
A) Access and create field for these tables using the MS Access database packages................3
B) Create two suitable queries and linking two or more tables. ................................................4
C) Create a monthly report based on one of these queries and how this report would be
useful..........................................................................................................................................6
Create two graphs which shows the ...........................................................................................8
1. a predicated general sales increases in 2019 of 2% per quarter. ............................................8
2. sales increased of 3% per quarter for CD1 and CD2, 4% for DVD1 and 5% for DVD2.......8

INTRODUCTION
Database management system is technique for collecting all information effectively and
efficiently. This report will discuss about the Orinoco.com website that maintain all information
related the order, customer and product, delivery etc. It also creates table or field by using MS
Access database tools and also generate queries with the help of database tables.
Question : 1
A) Access and create field for these tables using the MS Access database packages
Ms access is tool that help for creating an effective data in proper manner. It is database
management system from the Microsoft that combine with the relations in Microsoft database
engine. It is useful platform for directly linked with the data that stored in the applications.
Customer database table
Product database table

Order database table
B) Create two suitable queries and linking two or more tables.
There are two tables linked together for creating a relationship between them. Customer and
order are connected to each other because customer_id is a primary key that shows as foreign
key in the another order_table. Foreign key always creates relationship between two tables.
I
llustration 1: customer and order relationship

Queries:
There are two databases that connected to each other. In this figure :5, order_id is a primary key
that connected with another table product_table. Order_id shows as foreign key in product_table
because both are connected to each other.
I
llustration 2: order and product relationship

Queries:
C) Create a monthly report based on one of these queries and how this report would be useful.
These report is useful for managing the entire business operations and functions. The
organization uses the database concept that help for designing an effective database system. In
this way, all informations are managed by the concept
Question: 2 use the excel Spreadsheet to record sales figures for the different products.
a). Use the formulas and function by using Excel software to calculate the total number of sales
of each product during 2018., it also calculates the average sales of each product for the year and
values of sales in the each quarter based on the product price. In this way, calculate the overall
sales of years.
b). create set of formulas to calculates the predicated values of sales in 2019 based to the genera;
sale of 2%.
Pro Quarter- 1 Quarter-2 Quarter-3 Quarter-4 Total
CD1 $ 12.99 4000 7000 4240 2680 17920
CD2 $ 15.99 7200 8000 10240 9442 34882
DVD1 $ 16.99 2220 10820 11100 10500 34640
DVD2 $ 18.99 3220 12670 12340 14350 42580
Total sales 130022
Pro Quarter- 1 Quarter-2 Quarter-3 Quarter-4 Total Avergae Sales
CD1 $ 12.99 4000 7000 4240 2680 17920 4480
CD2 $ 15.99 7200 8000 10240 9442 34882 8720.5
DVD1 $ 16.99 2220 10820 11100 10500 34640 8660
DVD2 $ 18.99 3220 12670 12340 14350 42580 10645
Total sales 130022

Quarter- 1 Quarter-2 Quarter-3 Quarter- 4 Total
$ 51,960.00 $ 90,930.00 $ 55,077.60 $ 34,813.20 $ 232,780.80
$ 115,128.00 $ 127,920.00 $ 163,737.60 $ 150,977.58 $ 557,763.18
$ 37,717.80 $ 183,831.80 $ 188,589.00 $ 178,395.00 $ 588,533.60
$ 61,147.80 $ 240,603.30 $ 234,336.60 $ 272,506.50 $ 808,594.20
Total Sales $ 2,187,671.78
Predict value of sales
Quarter- 1 Quarter- 2 Quarter-3 Quarter- 4 total
CD1 4080 7140 4324.8 2733.6 18278.4
CD2 7344 8160 10444.8 9630.84 35579.64
DVD1 2264.4 11036.4 11322 10710 35332.8
DVD2 3284.4 12923.4 12586.8 14637 43431.6
3% increase each quarter
1 2 3 4 TOTAL
CD1 4120 7210 4367.2 2760.4 18457.6
CD2 7416 8240 4367.2 2760.4 22783.6

Create two graphs which shows the
1. a predicated general sales increases in 2019 of 2% per quarter.
2. sales increased of 3% per quarter for CD1 and CD2, 4% for DVD1 and 5% for DVD2
4% increase each quarter
1 2 3 4 TOTAL
DVD 1 2308.8 11252.8 11544 10920 36025.6
DVD2 3348.8 13176.8 12833.6 14924 44283.2

3. According to survey, it can conclude that all the information and details are divided according
to the need and requirement. Different customer purchased product that interconnected to each
other. This database system will help for determine the entire need and requirement of
orinoco.com website that collecting all information and details in proper manner. This
organization will record all the details. ,
Question : 3 Research and produce a report to describe the information system required in three
different level of organizations structure.
Information system is type of software that analyse and organize the data in proper
manner. This is an effective process in the organization because it is useful for turn the raw data
into the particular information that help for taking the decision regarding the business process.
There are different types of information system applicable in the different level of organization.
DDS (Decision support system)- Decision support system is also useful in the top level
organization for analysing the data and generate the statical projection. This information system
support the manager to improve the quality of decision.
MIS (management information system)- Management information system is part of system
that useful for collecting the data by the transaction process. The data is applicable for creating
reports in proper manner. This information system support the middle level structure of
organization.
TPS (Transaction processing system)- A transaction processing system is the best way to
provide the process, store, display, cancel the transaction and modify. Many systems allow the
multiple transaction process. This process will use the information system of lower level
organizational structure.
KBS (Knowledge- based system)- It is computer based system that solve the complex and
difficult problem. It is required for manager to have knowledge about the technical skill that help
for improve the entire business operations and function in effective manner.
How its useful for organizations-
 Knowledge based system is useful for organization to solve the complication in the
business process.
 It can easily transfer and codified to another people.
 It can be stores and sorts the knowledge.