The course introduces the concepts of database management systems to students, focusing on basics such as the importance and significance of a database, data model, schema creation and normalization.
At the end of the course, students should be able to:
Introduction: Introduction to database, relational data model, DBMS architecture, data independence and data abstraction, DBA, database users, end users, front end tools.
Data Modelling: Entity types, entity set, attribute and key, relationships, relation types, ER diagrams, database design using ER diagrams.
Relational Data Model: Relational model concepts, relational constraints, primary and foreign key, candidate key, alternate, composite, super-key.
Data redundancy, Normalization: 1NF, 2NF, 3NF.
Structured Query Language: Introduction to SQL, concepts of Data Definition Language (DDL) and Data Manipulation Language (DML), DDL queries like create a data base, drop a database, create table, drop table, alter table, DML queries like inserting data in a table, update in a table, delete data from a table, filter data.
Structured Query Language (continued..): Create relationships between database tables, auto increment, check, Null values, aggregate functions – min, max, count, average, sum, nested sub-queries, group by, having, exists, case, order by. Join operations – inner, left join, right join, natural join and Cartesian product. Overview of forms and reports.