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

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