Chapter 6, Problem 2RQ

Explanation of Solution

DBMS (Database Management system):

DBMS is a program or software that is used to control and manage the database. It is a large, complex program or software that is used to manage and administer the stored databases and it is a computer based system to keep records.

Query language such as SQL is used along with DBMS to interact with the database.

Work of a DBMS:

• DBMS is used to Create Database which enables the user to store or contain a large amount of data.
• DBMS is used to manage the data definitions in database dictionary.
• DBMS provides security to the user by having network security such as firewalls which monitors internet traffic and using an Intrusion Detection System (IDS) device that blocks unauthorized access.
• The database can be accessed by more than one user simultaneously...

Explanation of Solution

Difference between logical and physical views of data:

Logical view	Physical view
The logical view of a database program represents data in a format.	The physical view deals with the physical arrangement, actual arrangement and location of data in the direct access storage devices.
The logical view presents data as end users would observe them...

Explanation of Solution

Three operations of a RDBMS:

Three operations are used to develop useful sets of data in the RDBMS. They are:

• Select – it makes a subset containing of all records in the file that meet specified criteria...

Explanation of Solution

Three major capabilities of a DBMS:

Database management system contains many capabilities which give value to an organization way of keeping its data. They are:

• Data definition language
• Data dictionary language
• Data manipulation language

Data definition language:

• It identifies how the content is structured within a database.
• Database tables are created with data definition language and the features of the fields in each table is defined.

Data dictionary language:

• Information of a database table fields can be displayed...

Explanation of Solution

Non-relational database management system:

• A non-relational database gives a mechanism for storing and recovering of data that is modeled in means other than the tabular relations used in relational databases.
• The non-relational databases are gradually used in big data and real time web applications.

Difference between relational DBMS and non-relational DBMS: