The
Foundation Module Courses
Database
Fundamentals
Course
Objectives
Students learn, in a comprehensive approach,
the concepts of design and implementation of database systems.
They acquire the knowledge of the advanced topics in database
management systems. Students improve their design and development
skills and they can make right design decisions on the database
structures for particular applications. In addition, they are
introduced to the most recent advances in database technologies.
Course
Description
Part
(1): Database System Concepts and Architecture (2 Lectures)
1.
Purpose of Database Systems
2. DBMS Architecture and Data Independence
3. Catalogs for relational DBMS
4. Data Dictionary
5. View of Data
6. Data Models
7. Data Definition Language
8. Data Manipulation Language
9. Transaction Management
10. Storage Management
11. Database Administrator
12. Database Users
13. Overall System Structure
14. Concurrency Control
15. Database Recovery
16. Database Security and Authorization
PART
(2) : DATAMODELS
*
Entity-Relationship Model ( 2 Lectures)
1.
Basic Concepts
2. Entities
3. Keys
4. Design Issues
5. Entity-Relationship Diagram
6. Weak Entity Sets
7. Extended E-R Features
8. Design of an E-R Database Schema
9. Reduction of an E-R Schema to Tables
10. Relational Database Design Using ER-to-Relational Mapping
11. Mapping EER Model Concepts to Relations
Part(3):
SQL- The Relational Database Standard Language(2 Lectures +
4 Labs)
1. Data Definition, Constraints
2. Basic Queries in SQL
3. More Complex SQL Queries
4. Insert, Delete and Update Statements in SQL
5. Views (Virtual Tables) in SQL
6. Indexes
*
Normalization(2 Lectures)
1. Functional Dependencies
2. First Normal Form
3. General Definitions of Second and Third Normal Forms
4. Boyce–Codd Normal Form
5. Fourth Normal Form
6. More Normal Forms
Part (4) DATABASE SYSTEM ARCHITECTURE( 1 Lecture)
1.
Centralized and Client–Server Architectures
2. Parallel Systems
3. Distributed Databases
Part(5) Advanced Databases and New Applications( 1 Lecture)
1.
Object Oriented Databases
2. Spatial and Geographic Data
3. Multimedia Databases
4. Data Warehousing
5. Datamining & OLAP
References
Elmasri/Navathe, "Fundamentals of Database Systems"
, The Benjamin/Cummings Publishing Company, Inc., 1994.
Total
Hours
Theoretical 30 hrs.
Practical 12 hrs.
