Prince Sultan University
College of Computer and Information Sciences
Department of Information Systems
Spring Semester 2011
- 20112
IS 223 Database
Management Systems
COURSE OUTLINE
|
Course Credits:
3 Cr. Hrs
(3,1,0). Pre-requisite(s): IS
201 Semester/Session:
Spring 2011-2012 Time & Location: Sat, Sun, Tue, Wed. 10:00 – 11:00, Rm. Lab-G Instructor:
Dr. Suleiman Hussein Mustafa. Bani-Bakr E-Mail address: sbakr@psu.edu.sa Office Hours: SAT, Sun, Mon,
Tue 10:00 – 11:00 Office Location: IS Chairman’s
Office |
|
|
Management
of an organization's data needs. Emphasis is on management and implementation
issues pertinent in a business information systems environment. Topics include
data access methods; relational, hierarchical, and, network database management
systems; query languages; database design and performance; data administration;
and, data dictionaries.
After completing this
course, students will be expected to demonstrate the ability to:
|
Knowledge
·
Define
the basic concepts and terms used in the area of database management systems. ·
Outline
the process of developing a database. ·
Identify
the components of a database and the elements of database environment. ·
Describe
the importance of data management in modern organizations. ·
Describe
the process of capturing data requirements. ·
Describe
the procedure and techniques used to produce a conceptual schema using the ER
modeling language. ·
Describe
the procedure and techniques used to transform a conceptual schema into a
relational schema using the relational model. ·
Describe
the procedure and techniques to transform the relational schema into physical records and fields. |
|
|
Cognitive Skills
·
Analyze
data to identify entities and relationships between entities. ·
Explain
the difference between different database management models. ·
Apply
data modeling techniques, using entity relationship (ER) diagrams, to
database design problems. ·
Apply
the rules for transforming the conceptual schema as represented by ER models
into a relational schema. ·
Normalize
data structures and recognize why non-normalized data structures are
undesirable with respect to dependencies and maintenance. ·
Show
how performance affects database design during implementation. ·
Evaluate
the different possibilities for partitioning, merging, and denormalization of relations for increasing
performance. ·
Use
the SQL language and a given database development environment and design
tools. ·
Apply
the database development lifecycle in real-life settings. ·
Apply
the various relational query operations using SQL for retrieving data. ·
Apply
the knowledge and skills acquired throughout the course to simple, real-life
business applications. |
|
|
Interpersonal Skills & Responsibility·
Comply
with the rules of fruitful group discussions through the review questions and
exercises. ·
Make
use of the principles underlying team projects. ·
Perform
a good presentation in front of a group of people. ·
Recognize
the responsibility of managing, maintaining, securing, and providing access
to data. |
|
|
|
Numerical & Communication Skills
|
III.
Course Content
|
Topics |
Weeks |
Contact
Hours |
|
Unit 1: Background 1. Introduction
to the course 2. Introductory
Terminology 3. The
Database Approach 4. Database
Applications 1. The
Client-Server Environment 2. The
Internet Database Environment 3. Data
Warehouses |
wk 1 - Wk 2 |
6 |
|
Unit 2:
Database Development Process 1. Database
Planning and Scope Definition 2. Data
Requirements Capturing and Analysis a. User
Views b. Data
Usage Analysis 3. Database
Design a. Conceptual
Database Design b. Logical
Database Design c. Physical
Database Design 4. Implementation
and Testing 5. Monitoring and Tuning
the Operational System 6. Database
Design within the System Development Process |
wk 2 - Wk 3 |
4 |
|
Unit 3: Data
Modeling 1. What
is Data Modeling? 2. Business
Rules as a Source for Modeling 3. The
Entity-Relationship (ER) Model 4. Modeling
Entities and Attributes 5. Modeling
Data Relationships 6. Enhanced
Entity-Relationship Modeling a. Representing
Generalizations and Specializations b. Specifying Constraints |
wk 3 - Wk 7 |
12 |
|
Unit 4: Relational
Database Approach 1. Introducing
Database Models
(Relational, Hierarchical, Relational, Object-Oriented) 2. The
Relational Model 1. Relations 2. Primary
and Foreign Keys 3. Integrity
Constraints 3. Transforming
ER Diagrams into Relations 2. Normal
Forms (1st, 2nd, 3rd, and Boyce-Cod) |
wk 8- Wk 10 |
10 |
|
Unit 5: Physical
Database Design and Performance 1. Designing
fields and Physical Records 2. Using
and Selecting Indexes 3. Performance
Considerations a. Partitioning
of Entities b. Denormalization |
wk 10 - Wk 11 |
4 |
|
Unit 6: Relational
Query Languages |
wk 11- Wk 14 |
14 |
|
Unit 7: Data
Management 1. Database
Administration 2. Data
Quality, Integrity, Recovery, Security, and Control 3. Data
Dictionaries |
wk 15 |
4 |
|
Major
Exams and Team Project Presentations |
Wk 7, wk 12, wk15 |
6 |
|
|
15 |
60 |
IV. Course Components (Total contact hours within the semester)
|
Component |
Contact
Hours |
|
Lecture |
34 |
|
Tutorial |
12 |
|
Practical (Lab Work) |
12 |
V.
Teaching Strategies
|
Domain |
Strategy |
|
Knowledge |
Lectures
and Student Homework |
|
Cognitive
Skills |
Lectures,
Case analysis, Exercises, and Practical Work |
|
Interpersonal
Skills & Responsibility |
Team
Work in Tutorials, Lab Sessions, and Projects. |
|
Numerical
& Communication Skills |
Exercises,
Discussions, Project Written Reports, and Individual Presentations |
VI. Course Requirements (Specify the
requirements of the course - reports, examinations, projects).
Project
Each
group of students will work on a project throughout the semester. It
involves the design of the database, forms, reports and a switchboard for a
‘real life’ system of their choice. It is a team project where groups of 2 to 4
students develop a ‘simple' database system utilizing a DBMS. Each group will
submit a report by the end of the semester (Last Day in Week 14) accompanied
with the electronic material of the executable database developed by the group.
Individual presentations will be required. The project phases are as follows:
|
Project
Phase |
Weeks |
Product |
Date
of Completion |
|
Project selection and teams
formulation |
Wk.1 |
List of projects and teams |
Wk. 2 (first class) |
|
Project objectives and scope |
Wk. 2 |
Document outlining project objectives and scope |
Wk. 3 (first class |
|
Requirements and needs assessment |
Wks. 3 - 6 |
Requirements document |
Wk. 7 (first class) |
|
Database design |
Wks. 7 - 10 |
Design document |
Wk. 10 (last class) |
|
Implementation
and testing |
Wks. 11 - 13 |
Running system |
Wk. 14 (first class) |
|
Project submission |
Wk. 14 |
Project document (hard
copy) and project CD including: project document in MS Word , running system
in ACCESS, and pp. presentation slides |
Wk. 14 (first day) |
|
Project presentation |
Wk. 14 |
Presentations |
Wk. 14 (3rd class) |
Quizzes
and Participation
There
may be announced or unannounced quizzes. Attendance is REQUIRED for
the course, especially for the tutorial and lab sessions. Engaging in a conversation with others is one
of the best ways to learn. Not attending a class
means that you will lose chance to learn, participate and get a good grade. Note, if you miss
a quiz, you will not be given another chance to do it. Note also, if
you miss a class for whatever reason, one mark will be subtracted from the
attendance bonus.
The Database Lab (Place: IT Center Lab-I)
This is a 3-credit hours course,
with 4 contact hours, which include a lecture and a mandatory tutorial and lab
section which provides hands on exercises for reinforcing the lecture material.
One or two of the contact hours per week will be allocated for tutorial and lab
sessions. Students use the lab primarily to work on the material as specified
below and to work on tutorial exercises. The practical material is designed to
walk you through many of the features of DBDesigner,
Microsoft Access, and Oracle SQL Server. You will be asked to prepare the
material covered in the lab session at home. During each tutorial or lab session
you will be expected to complete the given exercises. Your work and progress will be reviewed and
evaluated.
VII. Student Assessment
A. Assessment Task
|
Domain |
Assessment Task |
|
Knowledge |
Quizzes
and Exams |
|
Cognitive
Skills |
Exams,
Quizzes, Exercise, and Projects |
|
Interpersonal
Skills & Responsibility |
Group
projects and Participation |
|
Numerical
& Communication Skills |
Group
Projects and Individual Presentations |
B. Schedule of
Assessment
|
Assessment |
Assessment Task |
Week Due |
Proportion of Final
Assessment |
|
1 |
Exam
1 (Written and Practical) |
7 |
20% (15% + 5%) |
|
2 |
Exam
2 (Written and Practical) |
12 |
20%(15% + 5%) |
|
|
Final
Exam (Written and Practical) |
16 |
40% (30% + 10%) |
|
3 |
Quizzes |
5 % |
|
|
5 |
Team
Project |
15 |
15% |
|
6 |
Attendance
Bonus |
|
5 % |
VIII.
Learning Resources
A. References
Main Textbook:
- Modern Database Management by J. A.
Hoffer, M.B. Prescott, and F. R. McFadden. 9th ed.
Prentice-Hall/Pearson, Latest edition.
(Available in the Bookstore of PSU)
Support Textbooks:
- Database Systems: A Practical
Approach to Design, Implementation, and Management. 4th ed.
Addison-Wesley, 2005.
- Database
Principles, Fundamentals of Design, Implementation and Management, 9th edition Course Technology Cengage learning.
- The
Microsoft Access material will be based on: Microsoft Access 2007
Step-by-Step, Steve Lambert, and others. For the
exercises of each chapter you should have access to the MSP folder.
Course Web Page:
- The course web page includes
all the material needed for the course. This includes the syllabus, the
presentation slides, project requirements, lab material, and any other
support material for the course.
Case
Study:
Cab Renting Company 2 (All Phases)
B.
Facilities required
·
Classroom and/or Computer Lab (IT Center Lab-H)
·
Software:
1. MS Access
Software
2. DBDesigner Software
3. Oracle SQL Server
Course Supplements
Furniture Company Database
SQL
Retrieval
Cab
Renting Database (SQL * PLUS)
Final
Exam – Furniture Company
Cab
Renting Database (MS ACCESS)
Cab Table
(excel)
Create
Form
Registration
Practical
2
Practical
3