The course educates students about the foundation concepts and principles relevant to designing a database. It aims to enable them to apply such concepts/principles in the development of a relational database that is based on the information requirements of an organization. Focuses are on database systems, data models, the relational database model, entity relationship modeling, advanced data modeling, normalization, and an introduction to structured query language.
Towards the end of this course, the students shall: analyze and compose business rules confined within a specific problem domain; convert a set of business rules into equivalent conceptual model and use it in creating the corresponding database with normalized tables and data dictionary; and perform basic data manipulation tasks using SQL.