Explain the activities associated with initiating a
data warehouse project.
Explain two main data warehouse development
methodologies (i.e., CIF and BDL)
Determine the main principles and stages
After studying this chapter you should be able to:
1. Determine how to develop conceptual data models from
2. Understand UML notations for conceptual data modeling.
3. Explain relationship characteristics
Overview of Database Design
Week 1 Learning Objectives
Students will be able to:
explain the purpose of database
define main components of database
explain the functions of DBMS
define main phases of database design
Using the Hotel schema, draw a relational algebra tree (RAT) for the following query
and use the heuristic rules to transform the query into a more efficient form:
SELECT g.guestNo, g.guestName, r.roomType
FROM Room r, Hotel h, Booking b, G
Exercise 1 Conceptual Design of Tiny College
Tiny College (TC) is divided into several schools (e.g., school of business, applied
sciences). Each school is administered by a dean who is a professor. Each dean can
administer only one school.
Each school is
Driver License Issues
Road Transport Department (RTD) administers driving tests and issues driver's
licenses. Any driver who wants a driver's license must first take a
computerized examination at any branch of
Exercise Conceptual and Logical Database Design
Suppose you are involved in developing a database system for the Sales Department of a company. The operation
of the Department can be described as follows:
The company has a file of products that they provi
COLLEGE OF ART AND SCIENCE
SCHOOL OF COMPUTING
STID3024 SYSTEM ANALYSIS AND DESIGN
SECOND SEMESTER SESSION 2016/2017
TOPIC : SEQUENCE DIAGRAM
: NURAINI SYAFIQAH BINTI MOHD JAFAR
: DR. JUHAIDA BIN
Data: The New
Fundamentals of Database Management Systems,
Mark L. Gillenson, Ph.D.
University of Memphis
John Wiley & Sons, Inc.
Dr. Hussein Mohammed Abu Al-Rejal
2003 Major in Bach
study Problem 5c (part 2)
1.Th e HEIGHT orporation has just paid a dividend of RM2.50 per share. The dividend of is company
grows at a steady rate of 6 percent per year. Based on this information, what ill the dividend be in?
a) 1 years b) 2
DATA DEFINITION LANGUAGE (DDL)
1. Show all databases.
2. Create a new database.
create database cafe;
3. Delete a database.
drop database cafe;
4. Start using the database.
5. Create a table.
create table FOOD
FoodID int(3) not