Introduction to Database System, Purpose of Database System -– Views of data – Data models, Database Management system –Basic building blocks – Evaluation of Data models- Three-schema architecture of DBMS, Components of DBMS. LAB: Practicing DML commands- Insert, Select, Update, Delete

Basics of SQL, DDL, DML,DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator, Functions - aggregate functions, Built-in functions – numeric, date, string functions, set operations, sub-queries, correlated sub-queries. transaction control commands – Commit, Rollback, Save point, cursors, stored procedures, Triggers. LAB: Creation of Tables using SQL- Overview of using SQL tool, Data types in SQL, Creating Tables (along with Primary and Foreign keys), Altering Tables and Dropping Tables. Implementation of different types of function with suitable examples • Number function Implementation of different types of function with suitable examples • Number function Implementation of different types of function with suitable examples Number function

DATABASE DESIGN: Database Design Process, ER Diagrams - Entities, Attributes, Relationships, Constraints, keys, extended ER features, Generalization, Specialization, Aggregation, Conceptual design with the E-R model. E-R Issues- weak entity set, code rules, Dependencies and Normal forms - Functional Dependencies, Normalizations: 1NF,2NF,3NF,BCNF,4NF,5NF. LAB: Study & Implementation of different types of constraints.

Transaction Concepts – ACID Properties –serializability and its types Schedules – Serializability – Concurrency Control – Need for Concurrency – Locking Protocols – Two Phase Locking – Deadlock – Transaction Recovery – Save Points – Isolation Levels – SQL Facilities for Concurrency and Recovery. LAB: Creating Database /Table Space , Managing Users: Create User, Delete User, Managing roles:-Grant, Revoke. Study and Implementation of Rollback, Commit, Save point.

Concurrency control, lock based protocols, time-stamp based protocols, validation based protocols, multiple granularity. Recovery system - failure classification, storage structure, recovery and atomicity, log- based recovery, shadow paging, buffer management, failure with loss of non-volatile storage, advanced recovery techniques, remote backup systems. LAB: Study and Implementation of Database Backup & Recovery Commands.