Database

Decomposition in DBMS – Lossless and Lossy

Decomposition means dividing a large and complex table into multiple small and easy tables. This removes redundancy, anomalies, and inconsistency in a database. This is the first stage of normalization. Suppose we have a relational schema R, in which we have attributes as given below: A1, A2, A3…………An So R = {A1, A2, A3…………An} If …

Decomposition in DBMS – Lossless and Lossy Read More »

Database Languages in DBMS – DDL, DML, DCL, DQL

Programming languages which are used to create and operate database, known as database language like Structured Query language aka SQL etc. Most of database languages are non-procedural, means the language focus on “what to do instead of how to do?” We can further divide database languages in these 4 categories as per the type of …

Database Languages in DBMS – DDL, DML, DCL, DQL Read More »

Parallel Database Architecture in DBMS – Advantages & Disadvantages

In this kind of architecture multiple processors, memory drives, and storage disks are associated to collaborate with each other and work as a single unit. In this type of database system, the hardware profile is designed to fulfill all the requirements of the database and user transactions to speed up the process. The arrangement of …

Parallel Database Architecture in DBMS – Advantages & Disadvantages Read More »