About This Course

This course is designed as an introduction to relational database management systems (RDBMS) focusing on the efficient design, implementation and optimization of an RDBMS. Topics covered will include the advantages and disadvantages of DBMS, database architecture, data modeling using ER and EER models, relational integrity constraints, relational schema mapping from ER/EER, indexing, hashing and normalization. SQL Query formulation will be extensively practiced in both the theoretical and laboratory components of the course. The course includes a compulsory 3 hour laboratory work each week as CSE370L. Students must complete several hands-on SQL assignments and a group project for the laboratory work. The group project will involve the design and implementation of a complete database system including a user interface.