Editorial Team

Normalization in DBMS

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 that cuts …

Normalization in DBMS Read More »

Locks in Database Management

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 variable associated …

Locks in Database Management Read More »

Rational Functions

Rational functions are special functions that you cannot call polynomials, but are obtained by dividing polynomials. In other words, they are the quotients of the polynomial division. A rational function is of form where and are polynomials and . The domain of rational function can be any real numbers except those that makes . Example …

Rational Functions Read More »

Quadratic Functions

Certain functions are symmetric in nature and quadratic function is one of them. If you remember from earlier lessons, we classified the functions as even and odd which means even functions are symmetric over y-axis and odd functions are symmetric over x-axis in a 2d coordinate plane. What is a quadratic function ? A quadratic …

Quadratic Functions Read More »

Concurrency Control

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 time efficiency. …

Concurrency Control Read More »

Transaction Management

In database, transactions are very important to maintain the consistent state of the database. We need to consider the users who operate and access database, and alter the state. This is an important aspect of database management which you will study in this article. What is Transaction? A Database Transaction is a logical unit of processing in …

Transaction Management Read More »