Introduction to Database Systems; Advantages of DBMS, File processing system, Data Abstraction, Schemas and instances, Data Independence, Database languages, Role of DBA, Database users, Data models, Risk of Database approach, Components of database environments, DBMS system structure; Entity Relationship Modeling; Logical Database Design and Relational Model; Normalization; Relational Algebra; Structured Query Language. Basic SQL statements, data manipulation language, data definition language, simple queries, nested queries, different types of joins, constraints, aggregate functions, views.

Credit: 3/Lab
Prerequisite: CSC 1203