SQL Server Isolation Levels

SQL Server Isolation Levels helps in concurrency & transaction management by preventing concurrency problems . In an environment where we have multiple users modifying and accessing the same information , it is essential that they all can work at the same time without any delays. They all should be able to read correct data and … Continue reading SQL Server Isolation Levels

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