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