DBMS Tutorial .What is Data ? Data is a raw fact and figure such as name of person,age, location where is based, or any collection of a distinct small unit of information.
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language.…
ISAM method is an advanced sequential file organization. In this method, records are storedin the file using the primary key. An index value is generated for each primary key andmapped…
In this article on Frequently Asked Question on DBMS , I will be discussing the top questions related to DBMS asked in your interviews. Q1. What are the differences between…
In Lock Based protocols, any transaction cannot read or write data until it acquires an appropriate lock on it. There are two types of lock: 1. Shared lock: It is…
Closure of an Attribute Set- The set of all those attributes which can be functionally determined from an attribute set is called as a closure of that attribute set. Closure…
Characteristics of DBMS are as follows: A modern DBMS has the following characteristics : Less redundancy –DBMS follows the rules of normalization which is a mathematically rich and scientific process…
Database utilities have the following types of functions: Loading : A loading utility is used to load existing data files—such as text files or sequential files—into the database. Usually, the…
There are several DBMS functions which ensure data integrity and consistency of data in the database. The ten functions in the DBMS are: data dictionary management, data storage management, data…
Indexing in DBMS is used to optimize the performance of a database by minimizing the number of disk accesses required when a query is processed. It is a data structure…
Any user who uses database and takes benefits from the database is considered a Database Users. They can be programmers, scientists, engineers, business person or can be an employee. Database…