If a student wants to change their Phone number, he or has to get it updated in various sections. Redundancy of data: Data is said to be redundant if the same data is copied at many places.Let us discuss the issues with this system: Some of the data is common for all sections like Roll No, Name, Father Name, Address, and Phone number of students but some data is available to a particular section only like Hostel allotment number which is a part of the hostel office. Data of students is available to their respective Departments, Academics Section, Result Section, Accounts Section, Hostel Office, etc. Let us consider the example of file-based University Management System.
Users are allowed to create, delete, and update the files according to their requirements.
REVOKE: revoke permissions to the user for running DML(SELECT, INSERT, DELETE,…) command on the specified tableĭatabase Management System: The software which is used to manage databases is called Database Management System (DBMS).
CREATE: to create a database and its objects like (table, index, views, store procedure, function, and triggers).Challenges of database security in DBMS.Introduction to TimeStamp and Deadlock Prevention Schemes in DBMS.Graph Based Concurrency Control Protocol in DBMS.Two Phase Locking (2-PL) Concurrency Control Protocol | Set 3.
Categories of Two Phase Locking (Strict, Rigorous & Conservative).Lock Based Concurrency Control Protocol in DBMS.