Storage of and access Data stored in files.  Implementation of storage/accesses algorithms like indexing, hashing and range accesses on data stored in independent files. Drawing conclusions regarding advantages/ disadvantages of data stored in files. Concept of database, Database Management Systems. Advantages of database management systems over file systems.  Different database models Implementation, storage and data retrieval strategies of Network three data models- Network, Hierarchical and relational data model, OODB, comparison with each other. Query languages, SOL. Relational Algebra – their syntax and use in Client server and single user environments. Transaction processing Types and Different stages of transactions. Aborted/incomplete transactions, Roll Back and different techniques of recovery from the exceptional situation. Parallel execution of transactions their inherent problems, limitations. Serialization of transactions. Distributed Database System & Advance Topics

This Course Will Map to PLO-1 and PLO-3