Tag: ERD

Table vs View – All You Need To Know

Table vs View is a topic of debate among DBAs and beginners because the similarities they both share . We will discuss various aspects of...

SQL Server Concurrency & Transaction Management

SQL Server Concurrency & Transaction Management  is a process which allows multiple users to access data and perform multiple operations maintaining data integrity and smooth...

SQL Subquery | SQL Beginner Guide

SQL Subquery is another tool SQL Server has which can be used to fetch data from other tables to be used in main query according to...

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...

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...