Data Warehouse Management System

Running head: DATA WAREHOUSING
Data Warehouse Management System
Name of the Student
Name of the University
Author Note

DATA WAREHOUSING1
Table of Contents
Introduction................................................................................................................................2
Data Warehousing......................................................................................................................2
System Requirements.............................................................................................................2
Diagrams................................................................................................................................3
Conclusion..................................................................................................................................6
References:.................................................................................................................................7

DATA WAREHOUSING2
Introduction
Data ware housing is very simplified way managing the data which are not present in
single place (Pang & Chan, 2017). Jack and Daniel are having auto-parts business. They want
to upgrade the current warehouse system for better dynamic results. The intended design of
the system in this report is supposed to fulfil their needs. In the later section of this report, the
functional and non-functional requirements are discussed with the help of use case, domain
model class diagram and event wise partitioned system model.
Data Warehousing
Data warehousing is technique in which data is collected from varied places and
managed to gain efficiency (Cravero, Mazón & Trujillo, 2013). According to the current
scenario of Jack and Daniel, the analysis of requirements is needed to be done. Then the
design comes in play where this system is supposed to deliver tasks like managing and seeing
a warehouse of auto parts with order details, shipment details, documentation and system
status like warnings and stock available.
System Requirements
The requirements for this intended system can be categorized in to two section which
are functional and non-functional requirements. Functional requirements has system tasks to
provide an efficient interface to manage the warehouse of auto parts (Abai, Yahaya &
Deraman, 2013). The inventory is manipulated and analysed by various functions which have
some set of rules. The system keeps a track of orders, its processing state, packaging process,
order pickup and management of load in orders. The system can also generate the invoices
for the each orders along with the crystal report. On another hand, non-functional
requirements: The system is designed to give accurate inventory details to user as a real-time
operation (Khouri et al., 2014). The system can add new items in the orders from the