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

What Is a Redundancy In DBMS

Redundancy in DBMS is when we store same information in different parts of the database , while this is not possible to remove Redundancy completely , it should be avoided whenever we can. Let’s say you are designing a system for a university. There’s a requirement to store the addresses of people in system as … Continue reading What Is a Redundancy In DBMS