File Systems versus DBMS, Advantages of DBMS.
Describing and Storing Data in a DBMS : The Relational Model, Levels of Abstraction in a DBMS, Data Independence , Database Architecture , Structure of a DBMS , Database users , Data Models .

Database Design-ER Diagrams, Entities, Attributes, Key, Participation Constraints, Weak Entities,Class Hierarchies,Aggregation. The Relational Model: Creating,Modifying Relations, Integrity Constraints, Key Constraints , General Constraints,Integrity Constraints, Querying Relational Data, ER to Relational, Entity Sets to Tables , Relationship Sets (without Constraints) to Tables, with Key Constraints , with Participation Constraints, Weak Entity, Views, Data Independence, Updates on Views, Destroying Views.

The Form of a Basic SQL Query: Examples of Basic SQL Queries, Expressions and Strings in the SELECT Command, UNION, INTERSECT, EXCEPT, Introduction to Nested Queries, Correlated Nested Queries, Aggregate Operators, The GROUP BY , HAVING Clauses, Joins .
Normalization : Purpose of normalization (or) schema refinement, concept of functional dependency, normal forms (1NF,2NF,3NF, BCNF & 4NF), Lossless join and Dependency preservation decomposition.

Data on External Storage, File Organizations, Indexing, Clustered Indexes, Primary and Secondary Indexes, Index Data Structures: Hash-Based Indexing, Tree-Based Indexing, ISAM, B+ Trees.

The ACID Properties, Transactions, Schedules, Concurrent Execution of Transactions: Concurrent Execution, Serializability, Two phase Locking (2PL), Strict 2PL.
Concurrency Control: View Serializability, Lock Management: Types, Lock conversions, dead locks, Concurrency Control without Locking: Time stamp based concurrency control, MultipleGranularity locking, Database Recovery Techniques.