CSE370 Database Management Systems

Undergraduate course, BRAC University, Department of Computer Science and Engineering, 2024

Taught CSE370 Database Management Systems during Fall 2024. Delivered lectures and labs on relational database management systems (RDBMS), focusing on data modeling (ER/EER models), relational schema mapping, normalization, indexing, and SQL query formulation. Guided students through a group project to design and implement a complete database system.

Course Objectives

  • Explained advantages and disadvantages of DBMS over file-based systems.
  • Taught data modeling using ER and EER models and relational integrity constraints.
  • Covered indexing, hashing, and normalization for efficient database design.
  • Focused on SQL for data storage, manipulation, and retrieval.

Course Materials

  • Fundamentals of Database Systems by Elmasri and Navathe, 7th Edition, Pearson.
  • Database Systems: A Practical Approach by Connolly and Begg, 6th Edition, Pearson.
  • Lecture slides, lab handouts, and SQL assignments provided via buX.