What is a relational database system.

Q5. What is a relational database system?

Ans. Relational Database refers to a database in which data is stored in multiple tables. these tables are linked to one another through common fields.

A Relational Database.

A relational database is shown in figure. in figure , you can see a database that contains several tables. these tables are linked to each other through a common fields.

Define DBMS and its functioning.

Q2. Define DBMS and its functioning.
Ans. DBMS is a program that controls the creation, maintenance, and use of a database. In DBMS, data is stored centrally. This allows users to easily access and share data as a common resource. DBMS helps in the integration of stored data by preventing inconsistencies and duplicate data. In addition, accessing, retrieving, and modifying the stored data is easy. DBMS also allows multiple users to access the data at the same time. Moreover, the access to the database is controlled. In other words, unauthorized users are prevented from accessing the database.

DBMS ensure data security.

Q3. How does DBMS ensure data security.
Ans. DBMS provides security for data by ensuring that only authorized users are able to access the database. Authorized users are doors users whose credentials are verified through security checks.

The data that is stored in a database may contain valuable or sensitive information. For example, the database of an organization can contain personal information about its employees or information about the financial deals made with other organizations. Such type of information is highly sensitive and may damage the organization or its goodwill if it were to fall in wrong hands. Therefore, it is important that such information should be provided adequate security. DBMS provides security for data by ensuring that only authorized users are able to access the database. Authorized users have the rights or permission to access or change the database. This not only helps keep track of the users who access and make changes in the database, but also preventsothers without right credentials to access the database.