Its a database management system subject related to maintenance of database in DBMS software package to store data in systematic an organized way and ensure quick retreival of data  and information when needed in multi user environment. This subject describe various types of database designing models and standards. Each and every model having having its own set of rules and methodology to set up and design the database. DBMS subject file organization methods, concurrency control techniques,distributed databases, database warehousing,query processor,relational algebra for complex query processing, concepts of keys and Normalisation rules with different types of keys . security and integrity of data also cover entity relationship model also which describes the relationship between entities using various tools and symbols. Components of DBMS software with three level architecture to understand the functioning of DBMS software. It also cover structured query language and linq to interact with the database software. Also described deadlock conditions , serialization,locks and much more to achieve consistency and integrity in database management system.