This course broadly introduces database systems, including the relational data model, query languages,
database design, index and file structures, query processing and optimization, concurrency and recovery,
and transaction management. Students acquire hands-on experience in working with database systems
and in building web-accessible database applications. Credits: 3
Learning Outcomes
By the end of this course, students will be able to:
- Describe the reasons and purpose of using a database
- Apply queries in relational algebra to retrieve data
- Explain the conceptual foundation of the relational model for databases
- Apply queries in SQL to create, read, update, and delete data in a database
- Apply the concepts of entity integrity constraint and referential integrity constraint
- Describe the normal forms of a relation
- Advanced topics in database systems, including optimization, concurrency, and recovery
Textbook
- Database System Concepts, Seventh edition, Abraham Silberschatz, Henry Korth, S. Sudarshan
- Fundamentals of Database Systems, Seventh edition, Ramez Elmasri, Shamkant N. Navathe
Syllabus
Offered
Fall odd years