The Three Schema Architechture of Relational database

 7 total views

 7 total views DBMS Basics ER To Relational Model The Relational Database Management Systems is the most popular database system. The overall structure of the Database System is given here. The relational database is at three level or three schemas.

Normalization in DBMS

 11 total views

 11 total views Designing a database structure without proper planning would cause duplicate data and problem updating the database. This will result in an inconsistent database. The process of normalization is to make an efficient database design that allow faster and efficient access while maintaining the accuracy. What is Normalization? Normalization is a database design technique …

Normalization in DBMS Read More »

Locks in Database Management

 26 total views

 26 total views Previously, you learned about the concurrency mechanism in database. You know that the concurrency is maintained in a serialized manner, giving the impression that there is indeed some concurrency. The locking technique has to do a lot with this achievement of efficient access to database. What is a Lock? A lock is a …

Locks in Database Management Read More »

Concurrency Control

 16 total views

 16 total views The concurrency control concept comes under the Transaction in the database management system (DBMS). It is a procedure in DBMS which helps us control two simultaneous processes to execute without conflicts among every other, these conflicts occur in multi-user systems. Concurrency explains executing multiple transactions at a time. It is required to increase …

Concurrency Control Read More »