Entity Relation Diagram Best Practices | Resolving DBMS Relationships Issues

ERD University Management System

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 Entity Relation Diagram Best Practices | Resolving DBMS Relationships Issues

Advertisements

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

ERD University Management System

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