DBMS

Unit No.

CONTENT

1

Introduction ⇗:

• An overview of database management system, Database System Vs File System, Database system concepts, data models. Advantages of DBMS, Schema and instances, Three schema architecture, data independence. Data base languages and interfaces, Disadvantages of DBMS.

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, specialization and aggregation, reduction of an ER diagrams to tables, extended ER model, relationships of higher degree.

2

Relational Data Model and Relational Algebra ⇗:

• Relational data model concepts, integrity constraints: entity integrity, referential integrity, Key constraints, Domain constraints. Relational algebra, Operations of relational algebra, queries in relational algebra.

3

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, Insert, update and delete operations, Queries and sub queries, Scalar and Aggregate functions, Joins, Unions, Intersection, Minus.

4

High Level Data Base Design & Normalization ⇗:

• Functional dependencies, normal forms, first, second, third normal forms, BCNF, inclusion dependencies, loss less join decompositions, normalization using FD, MVD, and JDs.

5

Transaction Processing Concepts ⇗:

• Transaction system, Testing of serializability, Serializability of schedules, conflict and view serializable schedule, recoverability, Recovery form transaction failures, deadlock handling. Concurrency Control Techniques: Concurrency control, locking Techniques for concurrency control.