Concurrency Control NAYI Pathshala November 21, 2017 0 Comments When multiple transactions are trying to access the same sharable resource, there could arise many problems if the access control is not... Read More Read more No comments:
Transaction Management NAYI Pathshala November 21, 2017 0 Comments What is a Transaction? A transaction is an event which occurs on the database. Generally a transaction reads a value from the database ... Read More Read more No comments:
Indexing NAYI Pathshala November 21, 2017 0 Comments What is an Index? An index is a small table having only two columns. The first column contains a copy of the primary or candidate key ... Read More Read more No comments:
Normalization NAYI Pathshala November 21, 2017 0 Comments While designing a database out of an entity–relationship model, the main problem existing in that “raw” database is redundancy. Redundanc... Read More Read more No comments:
Entity Relationship Diagram NAYI Pathshala November 21, 2017 0 Comments When a company asks you to make them a working, functional DBMS which they can work with, there are certain steps to follow. Let us sum... Read More Read more No comments:
Introduction to DBMS NAYI Pathshala November 21, 2017 0 Comments As the name suggests, the database management system consists of two parts. They are: Database and Management System What is a Da... Read More Read more No comments: