King Fahd University of Petroleum and Minerals
Department of System Engineering
Semester 2008-2009 (081)
ISE 361 Fundamentals of Database Systems (
(Sections 01, 51)
1. Instructor
Name Ejaz
Ahmed
E-mail eahmed@kfupm.edu.sa
Office 22/124-6
Phone 1141
Class ISE361-01: U T 11:00 - 11:50
pm 24/104
ISE361-51: U 02:10 - 05:10 pm (Lab)
2. Course
Course Objectives
1.
[Basic
Concepts & Features of Database Systems]
To understand the basic concepts of databases, RDBMS and database
theory.
2.
[Database Design
Models & Methodology]
To understand database design, development, and implementation.
3.
[Advanced
topics]
To
introduce advanced topics like query processing & optimization,
concurrency, and recovery.
4.
[Practice with
A Real Database Management System]
Get an experience to work in a
team environment.
Catalog Description
Basic database concepts.
Conceptual modeling. Relational data modeling, capturing business rules. Normalization,
database system development processes, transaction processing, distributed
processing, data warehouses, and databases on web. Concepts and tools will be
integrated in a small group project designing and implementing an actual
information system.
Course
Learning Outcomes
1. Upon completion of the course, students will be able
to:
2. Explain the basic database, DBMS concepts and implementation.
3. Understand and develop relational/ conceptual data
model.
4. Use and apply database programming languages.
5. Understand the basics of enterprise database
processing, concurrency controls and database recovery.
6. Gain work experience in a lab project as a team member
or leader.
Prerequisite: ICS 101
– Computer Programming
Textbook
Recommended:
“Database Processing:
Fundamental Design & Implementation” by David M. Kroenke 10th edition, Printice
Hall, ; ISBN:0-13-167267-3
Reference:
Quizzes ---------------------------- 10 %
Home Work ---------------------------- 10 %
Exam I ---------------------------- 15% (20-NOV-2008 Thursday)
Exam II ---------------------------- 15 % (30-DEC-2008 Tuesday)
Final Exam ----------------------------- 25% (Total
Marks: 75, plus 25 Lab work)
|
S# |
Topic |
Chapter |
# Of
Lectures/ Week |
Exam |
Quiz |
HW |
|
1 |
Basic Database Concepts and Database Architecture, DBMS & Applications |
[1, 2] |
(Week-2) |
|
1 |
|
|
2 |
The Relational Data Model, SQL |
[3], [7], [8] |
(Week-3) |
1 |
1 |
1 |
|
3 |
Data Modeling (ER) |
[5], [6] |
(Week-3) |
|
|
1 |
|
4 |
Normalization , RDBMS Implementation & Application Design |
[3], [4], [Notes] |
Week-2 |
|
|
|
|
5 |
Managing Multi-user Databases |
[9], [10] |
Week-2 |
1 |
1 |
|
|
6 |
|
[15] |
Week-2 |
|
1 |
|
|
7 |
Revision |
|
Week-1 |
|
|
|
|
|
|
|
|
|
|
|
3. General Policies
Attendance
·
Regular attendance is the university requirement. Attendance will be
taken in the beginning of every class.
·
Whenever the number of unexcused absences exceeds 20% of the held classes, the grade DN will be reported without any
formal warning.
·
Final exam will be selective comprehensive.
Home Work Submission
·
The home work can be submitted in a class on the due date.
·
Any late submission will not be accepted.
Class Discussion
·
Participation in class discussion is very much encouraged. Asking
questions during lectures helps both the instructor and the student. The
instructor gets the feedback and the students get the point clarified. Active
learning will be a part of it.
Grading Issues
·
All the grading issues must be resolved within a week after the return
of graded material.
·
Exam grades will be submitted a week after the exam date.
·
Only 4 quizzes will be considered in the final grade.
Make Ups
·
No make up exams will be given.
Software Applications’
Standards
·
Oracle 9i/ 10g, MS Access, MS SQL & Oracle SQL standards (ANSI
standards)