Overview of DBMS, Basic DBMS terminology, data base system v/s file system,
data independence. Architecture of a DBMS
Introduction to data models: entity relationship model, hierarchical model: from
network to hierarchical, relational model, comparison of network, hierarchical and
Data modeling using the Entity Relationship Model: ER model concepts, notation
for ER diagram, mapping constraints, keys, Concepts of Super Key, candidate key,
primary key, Generalization, aggregation, reduction of an ER diagrams to tables,
extended ER model, relationships of higher degree.
Relational model: storage organizations for relations, relational algebra, relational
Normalization: Functional dependencies, normal forms, first, second, third normal
forms, BCNF, inclusion dependencies, loss less join decompositions, normalization
using FD, MVD, and JDs, alternative approaches to database design.
Introduction to SQL: Characteristics of SQL, Advantages of SQL, SQL data types and
literals, Types of SQL commands, SQL operators and their procedure, Tables, views
and indexes, Queries and sub queries, Aggregate functions, insert, update and delete
operations, Joins, Unions, Intersection, Minus in SQL.