Course Lecturer

Prof. Dr. Slim Abdennadher
 

Course Assistants

Mr. Amgad Madkour
Ms. Amira Thabet

I. Course Description

In this course, the students will learn the basic theories of database systems as well as basic skills to operate a database so that they can design, implement, and operate an application database. The major topics covered in this course include high-level conceptual database design using ER and EER models; relational database concepts, relational database design by ER- and EER-to-Relational mapping, and basic SQL programming.

From a course project running through the entire semester, the students will learn to design simple database applications using ER model, implement them on a relational database management system, and write queries to extract information from the database.

II. Course Objectives

1. Learning state-of-the-art database concepts, theories, techniques, and tools that are directly applicable to a Computer Engineering career, including:

-  Database system concepts and system architecture.
-  Relational database design, modeling and implementation.
-  Relational database query (SQL) and Object-Relational extensions
-  Multi-user and distributed data systems management.
-  Hands-on practice with client-server DBMS (such as SQL Server, Oracle, Access).

2.  To strengthen professional communication and collaboration skills:

-  Learning to actively participate in class discussion and lab sessions in a professional manner.
-  Practice public presentation skills by presenting ideas and project results.
-  Working in groups to practice project planning, leadership and interpersonal communication skills.

Topics covered in the course

Basic Concepts of Database Systems
The Entity Relationship Diagram
Relational Algebra
Database Design & Normalization
Structured Query Language (SQL)
Storing Data and File Organization
 

Recommended Textbook

Fundamentals of Database Systems, 4th edition
Ramez Elmasri and Shamkant B. Navathe. 
ISBN 0-321-12226-7