Course Lecturer
Prof. Dr. Slim Abdennadher
Course
Assistants
Mr. Amgad Madkour
Mrs. Neamat
Abdel Hady
Mr. Khalid Ibrahim El
Gazzar
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