Database Management Systems

Unit 1: Introduction to Databases

• Purpose of database system
• Characteristics of database approach
• Data models
• Database management system
• Database system architecture
• Three-schema architecture
• Components of DBMS
• Data independence
• File system approach vs database system approach

Unit 2: Entity Relationship Modeling

• Conceptual data modelling – motivation
• Entities and Types of Entities
• Attributes and Types of Attributes
• Relationships and Types of Relationship
• Constraints on relationship
• Entity Relationship diagram notation

Unit 3: Relation data model

• Anomalies in DBMS
• Relational Data Model – Concept of relations
• Schema-instance distinction
• Types of Keys in DBMS
• Relational integrity constraints
• Referential integrity and foreign keys
• Relational algebra operators and queries

Unit 4: Structured Query Language (SQL)

• Querying in SQL
• DDL to create database and tables
• Table constraints
• Update database-update behaviors
• Data Manipulation Language
• Aggregation functions group by and having clauses
• How to retrieve data from the database
• Generate and query views
• Access and manipulate databases using ODBC
• Basic Database administration SQL commands

Unit 5: Database design

• Mapping an Entity Relationship model to relational database
• Functional dependencies and Normal forms
• First Normal Form (1NF)
• Second Normal Form (2NF)
• Third Normal Form (3NF)
• Boyce Codd Normal Form (BCNF)

Unit 6: File indexing and Transaction Processing

• Data Storage and Indexes: Need of file indexes
• File Organizations
• Index structures
• Single and Multi-Level indexing
• Concurrent execution of transactions
• ACID properties in DBMS
• Need of data recovery and log file