Database Management Systems (ITEC212)

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

Related Programs

• Management Information Systems Undergraduate Program
• Information Technology Undergraduate Program
• Information and Communication Technologies in Education Master's Program (without Thesis)
• Information and Communication Technologies in Education Master's Program (with Thesis)
• Information and Communication Technologies in Education Doctoral Program
• Information Technology - Management Information Systems Double Major Program
• Management Information Systems - Information Technology Double Major Program