King Fahd University of Petroleum & Minerals

College of Computer Sciences and Engineering

Information and Computer Science Department

ICS 324: Database Systems (3-3-4)

Syllabus - Second Semester 2017-2018 (172)

Website: Blackboard learn 9.1

Class Time, Venue and Instructor Information:

Sec.	Time	Venue	Instructor	Office Hours
01	UTR 8:00-8:50AM	22-334	Mr. Yahya Garout Office: 22-320 Phone: 013-860-4296 E-mail: garout@kfupm.edu.sa	MW 15:20–17:10PM or by appointment
02	UTR 9:00-9:50AM
51	Open
52	Open

Course Catalog Description

Basic database concepts; conceptual, logical, and physical database design; relational theory and languages; introduction to

query processing and optimization, and introduction to object and object relational databases.

Pre-requisites: ICS 202

Assesment Plan:

Assesment Tool	Weight
Attendance	5 %
Assignments	10 %
Quizzes	10 %
SQL Exam	10 %
Project	15 %
Midterm Exam	25 %
Final Exam (7:00 PM, Saturday, May 5, 2018)	25 %

Tentative Schedule & Major Topics:

Week#	Topic
1	Databases and Database Users
2	DB System Concepts and Architecture
3	Data Modeling Using The Entity-Relationship (ER)
4	The Relational Data Model
5	SQL
6	SQL
7	SQL
8	Relational Algebra and Relational Calculus
9	Relational Database Design
10	Introduction to SQL programming
11	Basics of Functional Dependencies and Normalization
12	Disk Storage and Basic File Structures and Hashing
13	Indexing Structures for Files and Physical DB design
14	Algorithms for Query Processing & Optimization
15	Algorithms for Query Processing & Optimization

Best of luck!!