Anomalies In DBMS

Anomalies in DBMS are the taboos . You do them and instantly your colleagues will curse you every time they have to do some operations on your DBMS. My rule is , that I always try to understand the meaning of word before understanding the concept, since English is not my native language . This … Continue reading Anomalies In DBMS

ERD Terminologies | DBMS Concepts

ERD Terminologies are the terms such as entity , attributes their types and Keys that are responsible to create relationships between entities. Database Management Systems have been playing an important roles in our lives for decades now . It is helping businesses to grow and store their data, which later on used by Data Analysts … Continue reading ERD Terminologies | DBMS Concepts

Dr. Codd’s Rules For Relational Database

Dr. Codd was a mathematician who proposed a new model for a database , which is known to us as Relational Database Management System. He came up with twelve rules which every true relational database should follow .  Let's go through these and if you have a hands-on-experience with databases. See how much have you … Continue reading Dr. Codd’s Rules For Relational Database

DBMS Models | DBMS Concepts

DBMS Models defines the logical design and structure of a database and defines how data will be stored, accessed and updated in a database management system. There have been few proposed models which were used & then due to limitations in each of them . They got replaced by new DBMS Models. Most widely used … Continue reading DBMS Models | DBMS Concepts