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

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 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 systemDBMS Models & RelationshipsData Modelling … Continue reading Entity Relation Diagram | University Management System Part 1