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

BasicsofSQL,DDL,DML,DCL,structure–creation,alteration,definingconstraints–Primarykey, 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:CreationofTablesusingSQL-OverviewofusingSQLtool,DatatypesinSQL,Creating Tables (along with Primary and Foreign keys), Altering Tables and Dropping Tables. Implementationofdifferenttypesoffunctionwithsuitableexamples • Number function Implementationofdifferenttypesoffunctionwithsuitableexamples • Number function Implementationofdifferenttypesoffunctionwithsuitableexamples Number function

DATABASEDESIGN:DatabaseDesignProcess,ERDiagrams -Entities,Attributes,Relationships, Constraints,keys,extendedERfeatures,Generalization,Specialization,Aggregation,Conceptual design with the E-R model.E-R Issues- weak entity set, code rules, Dependencies and Normal forms-FunctionalDependencies,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, recoveryandatomicity,log-basedrecovery,shadowpaging,buffermanagement,failurewithlossofnon-volatilestorage,advancedrecoverytechniques,remotebackup systems. LAB: Study and Implementation of Database Backup& Recovery Commands.