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 both tables and views . Such as: Difference between Table vs View. Table vs View Performance. Advantages of Views in SQL In SQL Beginner's Guide we have developed basic understanding about views. … Continue reading Table vs View – All You Need To Know

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 execution all at the same time. Microsoft SQL Server manages concurrency control by using locks to help protect data. The locks control how multiple users can access and change shared data … Continue reading SQL Server Concurrency & Transaction Management

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 the needs.  Inner query and nested query are other names of SQL Subquery. SQL Subquery can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators … Continue reading SQL Subquery | SQL Beginner Guide

Data Normalization University Management System

Data Normalization is the process widely used and implemented in industry . While this concepts has it's use it comes with a price. However , Designing a DBMS is fundamental and of utmost importance to the success of any software. You can think of DBMS as human brain and this is true because DBMS design … Continue reading Data Normalization University Management System

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

ERD Best Practices | Resolving DBMS Relationships Issues

Previously , we resolved a case study by creating an ERD for University Management System . Today , we will focus on ERD best practices and resolving dbms relationship issues . This can make our life a whole lot easier . So far , we have established the fact that an Entity-relation diagram is the first … Continue reading ERD Best Practices | Resolving DBMS Relationships Issues

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

Entity Relation Diagram | University Management System Part 1

Exciting stuff today people. Today , we are actually going to get our hands-dirty and do a hands-on practice for designing a database management system by creating ERD Case Study for University Management System . In case , you need an overview of previous articles : What is a database? Database management system DBMS Models & … Continue reading Entity Relation Diagram | University Management System Part 1

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