Database Management Systems (CMPR106)
The main aim of the lecture is to teach students how to model the data at the conceptual level and finally implement the model in SQL. The emphasis of the lectures is on practical aspects of data modeling such as creating entity relationship diagrams and normalization. SQL is taught in the laboratories using Oracle. Main topics covered: Database terminology and concepts, componenets of Database Management System (DBMS), data modeling using Data-Relationship Model, converting data-relationship model to relations, normalization, querying, SQL