EC 351 – Database Management Systems

Course lecturer :

Dr. Emad Saad

Course assistant :

  • Eng. Khaled Mousa
  • Eng. Karim Soliman

Course objectives :

The students will, upon completion of the course, be able to model and implement a simple database. Further on, the students will be able to formulate queries, using SQL, to search information in such databases. Finally, the students will have basic knowledge in the use of decision support systems (data warehouses). This implies that the students should be able to: • Understand the functions and architecture of a database system, • Be able to model and structure data according to actual constraints • Be able to use a query language to formulate queries • Use a simple decision support system

Course description :

Overview of file techniques: organization and access techniques. Introduction to DBMS architecture and environment, structured top down database development lifecycle, data modeling and data flow diagrams. Database organizations: hierarchical, network and relational, relational algebra, ANSI SQL, relational database design, integrity and security of database systems, recovery and concurrency control, query optimization, tuning of physical database design, introduction to Object Oriented DBMS, current trends in DBMS.

Course assessment :

Assessment form Grade % Class works including drop quizzes and solving assignment problems 15 Mini-Projects 15 Mid Term Written Exam 20 Final Written Exam 50

Recommended text books :

Fundamentals of database systems; Elmasri &Navathe; 6th Edition; Pearson Education; 2010

Recommended refrences :

[1] Database System Concepts : Silberschatz , Korth, andSudarshan ; 4th Edition ; McGraw-Hill 2002 [2] Database Management System; Raghu Ramakrishnan & Johannes Gehrke; 2nd Edition; McGraw-Hill 2000 [3] R. krishnan and Gehrke, \”Database Management Systems\”, 3rd edition, McGraw-Hill Publishers.