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 …
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 …
Entity Relation Diagram| University Management System Part 2 Read More »
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 …
Crow’s Foot Notation is utilised to represent Cardinality & Modality .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 …
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. …