DBMS Relationships are a fundamental & core principal which is used to make objects behave with each other. We use DBMS relationships to define how entities in DBMS relates to each other and to what extent they will communicate with each other. Recently , we talked about ERD Terminologies and discussed about entities and attributes in detailed. … Continue reading DBMS Relationships
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
Redundancy 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 well and … Continue reading Redudancy
To understand what a DBMS (Database Management System) is. You need to go through my first article about databases. When computers were reduced to the size where they were places on table. Enterprises big and small , all started using computer software to conduct their business. These software had a nice decent interface so that … Continue reading Database Management System
To understand what database Is, we have to first understand what data is . Data is a plural of 'Datum' . "Datum means a piece of information and by definition data is a collection of information." Important thing to understand is information can be anything, whether it is bill of your favourite take-out from a … Continue reading What is a Database?