What is SQL ? What is it used for and What is SQL database management. Welcome to the SQL Beginner’s Guide series . The objective…
In Part 1 for ERD Case Study Case Study University Management System , we discussed how can you crack any case study and convert it into DBMS…
Data Modelling is the process of organising data elements into entities and mapping them into real world objects . This defines how different entities will…
Crow’s Foot Notation is utilised to represent Cardinality & Modality .When we design a database management system , we set some basic rules and define…
DBMS Relationships are a fundamental & core principal which is used to make objects behave with each other. We use DBMS Relationships to define how…
ERD Terminologies are the terms such as entity , attributes their types and Keys that are responsible to create relationships between entities. Database Management Systems…
Dr. Codd’s Rules for Relational Database are the bases of every true relational database . Dr. Codd was a mathematician who proposed a new model…
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.
Database Management System have changed our world as we know it. They are capable of storing data of huge sizes and of business history of years. Providing businesses an opportunity to grow and adapt to the customer needs.