This course is designed as a database design and use of database management systems for applications. Topics include database architecture, comparison to file-based systems, historical data models, conceptual model; integrity constraints and triggers; functional dependencies and normal forms; relational model, algebra, database processing and Structured Query Language (SQL).
The learning outcomes of this course are:
- Understanding the different issues involved in the design and implementation of a database system
- Studying the physical and logical database designs, database modeling, relational, hierarchical, and network models
- Understanding and using data manipulation language to query, update, and manage a database
- Developing an understanding of essential DBMS concepts such as: database security, integrity, concurrency, distributed database, and intelligent database, Client/Server (Database Server), Data Warehousing
Pre-Requisites: ICTM 602
Textbook: Fundamentals of Database Systems, 6th ed., Elmasri & Navathe, Addison-Wesley, 2011, ISBN: 978-013-608620-8