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
Showing posts with label Data Base Management system (DBMS). Show all posts
Showing posts with label Data Base Management system (DBMS). Show all posts
11/21/2017
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
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
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
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
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