Database Management Systems - I (BTBS217)
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. Main topics covered: Database terminology and concepts, components of Database Management System (DBMS), data modeling using Data-Relationship Model, converting data-relationship model to relations, normalization. The course covers key components of SQL including data definition, data manipulation, data querying, and security features such as data integrity constraints and access control using GRANT and REVOKE.