Skip to main content
User Image

Alaaeldin Hafez

Professor

Professor of Information Systems

علوم الحاسب والمعلومات
bldg 31
course

Introduction to Database Systems

In this course, students should study the following topics: characteristics and advantages of the database management systems (DBMS), database concepts and architecture; data models, database schemes and instances, DBMS and the concept of program-data independence, database languages and interfaces, database models, relational data model and relational algebra, relational model constraints; domains, keys, and integrity constraints, the structured query language (SQL); data definition, queries, update, statements, and views in SQL, database design; functional dependencies, normal forms. 
Textbook(s) and/or Other Required Materials:
 
Primary:           R. Elmasri and S. Navathe, “Database Systems: Models, Languages, Design, and Application Programming”, 6th Edition, Pearson, ISBN-10:0-13-214498-0, ISBN 13: 978-0-13-214498-8, Published 2011.
 
Supplementary: Thomas Connolly and Carolyn Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition, Addison-Wesley, ISBN-10: 0132943263 • ISBN-13: 9780132943260, Published 01/08/2014  

course attachements