Designing a Data Warehouse
By Michael Haisten
In my white paper Planning For A Data Warehouse, I covered the essential issues of the data warehouse planning process.1
This time I move on to take a detailed look at the topic of warehouse design. In this di
Data Model Basic Building Blocks
Entity: A person, place or thing physical or abstract. E.g. Customers and Flight
Attribute: Equivalent to field names. E.g. First name, last name, phone number.
1. One-to-many (1:*): A painter paints
What are the roles of CIO, CTO, CSO, CPO and CKO?
The chief information officer (CIO) is responsible for (1) overseeing all uses of
information technology and (2) ensuring the strategic alignment of IT with
business goals and objectives. The CIO often rep
Chapter 8 Supply Chain Management
List and describe the components of a typical supply chain.
A supply chain consists of all parties involved, directly or indirectly, in the procurement of a
product or raw material.
Supply chain management (SCM) involves
Chapter 1 The Database approach Answers to Textbook Questions
1. Data: Data are raw facts. Raw facts that have not been processed to reveal its
true nature. Data have little meaning unless they have been processed in a
Field: A character o
Chapter 1: The Database Approach
1. What is the difference between data and information?
Data are raw facts. Raw facts that have not been processed to reveal its true
Information is the result of processing raw data to reveal its meaning.
Answers to Review Questions
1. Discuss the importance of data modeling.
A data model is a relatively simple representation, usually graphical, of a more complex real world
object event. The data models main function is to help us und
A database environment is a habitat, if you will, in which the database for a business
resides consists of the hardware and operating system platform on which the database
resides. A database environment also in
KAMAU SAMMY MUGO
SQL*Plus: Release 18.104.22.168.0 Production on Sun Jun 30 18:15:07 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect system /as sysdba
Consider the following (part of a) report:
Mgt Info Systems 00001
Day of the week
Object Oriented Analysis and Design
Sammy M/ Email: [email protected]
This course builds on the programming sk
Database Management Systems Labs
Question & Answers
Instructions to Candidates:
Answer ALL questions in Section A and Any other TWO from Section B.
Write your registration number on all sheets of the answer book used.
Use a NEW PAGE FOR EVERY QUESTION att
2011 University of South Africa
All rights reserved
Printed and published by the
University of South Africa
Study unit 1: Conceptualising the virtual off
Running Head: PERFORMANCE MANAGEMENT
Background of Performance Management
Organizational psychology is basically the study of the organizational behavior alongside
Earned Value Exercises
You company has a project scheduled to be completed in 12 hours, but 12 hours
have been spent and the estimate to complete is 3 additional hour. The project
should have been completed already. The value is R300 per hour. Use the