Data Warehousing: Requirements, SQL, Design and Demonstration

Running head: DATA WAREHOUSING
Data Warehousing
Name of the Student
Name of the University

1DATA WAREHOUSING
Table of Contents
1. Requirements:..............................................................................................................................2
2. SQL..............................................................................................................................................3
3. Design:.........................................................................................................................................5
4. Demonstration:..........................................................................................................................11
Bibliography:.................................................................................................................................13

2DATA WAREHOUSING
1. Requirements:
Current and Future Decision Making Needs:
i. Providing benefits to the general physicians refers most of the patients. The
decision will be made by management and will have many conditions.
ii. The side effects of the medications, provided to the patients. The organization
may want to identify the date of the medicine started from. This will provide an
idea to the organization about the negative impacts of the medications on the
patients.
iii. The medical condition of a client is a crucial information. This will provide an
insight of the client condition. The patient care system can provide suggestion for
improving patient care.
iv. The organization will be analysing the orders made in a single day. The
information of orders provides insight of business core activities. The
management of Vigour will access the reports of medications expenses and make
various decisions.
v. The business depends on the clients. The system will create report on which
patient has paid how much for the service they have taken. This will allow the
organization to improve business infrastructure by providing better offers to loyal
customers.
The information requirements are as following.
i. Patient Information: patient information is crucial for business. The organization
will be promoting various offers based on the client they want to attract. The

3DATA WAREHOUSING
phone number and email id will be used for communicating with the clients and
promoting business.
ii. Treatment Information: The information of the patient’s medical conditions and
the improvement in their conditions are important for care management. The
organization will be providing treatment to the patients based on their medical
condition.
iii. Medication and Side Effects: The doctors will be proscribed various medications
to the patients. All the information will be stored in the database. The medication
and side effects of the information is crucial as the doctor will change the
medication if the side effects are severe.
iv. Bill: The payment accepted from the patients are the main source of business
profit. The information of payment is crucial for business decision making.
v. Employee Details: The information of the employees is also an important part of
the business. The organization will need to be in touch of the employee at all
times. The information will provide better understanding of an employee. This
will offer an opportunity to Vigour for improving the working atmosphere.
vi. Consultation: The information of the consultation for each of the patient will be
recorded and used later. The outcome of each consultation is provided to the
management in the form of report. The date of consultation, consultant name,
patient name, duration, outcome and many more information is presented through
that report.