What is SQL ? | SQL Beginner’s Guide

Welcome to the SQL Beginner's Guide series . In this series we will learn , What is SQL ? What is SQL used for and SQL database management. The objective is to give SQL training to beginners and apply DBMS Concepts we learned in our DBMS Concepts series and code them into an actual database and … Continue reading What is SQL ? | SQL Beginner’s Guide

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

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

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

What is Database Management System

Database Management System Definition : Database Management System ( DBMS) is a software that handles creation, manipulation and data integrity in a database by providing appropriate tools. It manages all users and transactions that are trying to access the database in a way that no transaction is lost and no users are disturbed. When desktop … Continue reading What is Database Management System