Entity Relation Diagram| University Management System Part 2

In Part 1 for ERD Case Study University Management System  we discussed how can you crack any case study and convert it into DBMS .  We did that step by step and had a wonderful feedback .  In another article on best practices for ERD , we discussed the pitfalls that we need to avoid.  Time to … Continue reading Entity Relation Diagram| University Management System Part 2

ERD Best Practices | Resolving DBMS Relationships Issues

Previously , we resolved a case study by creating an ERD for University Management System . Today , we will focus on ERD best practices and resolving dbms relationship issues . This can make our life a whole lot easier . So far , we have established the fact that an Entity-relation diagram is the first … Continue reading ERD Best Practices | Resolving DBMS Relationships Issues

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

Role of Keys In Database Management System | Data Modelling

Best thing about being a business intelligence consultant is that my work is closely related to real-life scenarios and objects that I use daily . Every time when i come across new concepts or even problems , I have always been able to map in my world . Such is our topic for today-Role of … Continue reading Role of Keys In Database Management System | Data Modelling

Entity Relation Diagram | University Management System Part 1

Exciting stuff today people. Today , we are actually going to get our hands-dirty and do a hands-on practice for designing a database management system by creating ERD Case Study for University Management System . In case , you need an overview of previous articles : What is a database?Database management systemDBMS Models & RelationshipsData Modelling … Continue reading Entity Relation Diagram | University Management System Part 1

Data Modelling | Database Management Systems

Data Modelling  is the process of organising data elements into entities and mapping them into real world objects . This defines how different entities will behave together and what will be the relationship among them. Database Management Systems are designed to store information and data for softwares . Before , implementation of the system the DBMS … Continue reading Data Modelling | Database Management Systems

Crow’s Foot Notation

When we design a database management system , we set some basic rules and define a limit and relation between different entities . In other words , we decide in what capacity the entities will interact each other.  Cardinality & Modality are two concepts that take care of these rules. Hence , today's article is … Continue reading Crow’s Foot Notation

DBMS Relationships

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 | 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

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