Question

This is for database system design. Will give thumbs up! Thanks

Q10.1    What are the four components of typical DBMS software?

Q10.2    What is the purpose of the DBMS data definition component?

Q10.3    What is the purpose of the DBMS data manipulation component?

Q10.4    What is the purpose of the DBMS data administration component?

Q10.5    What is the purpose of the DBMS application development component?

Answer 1

Q10.1    What are the four components of typical DBMS software?

The four main components of a typical DBMS software are:

1. Query Processor

2. Data Dictionary

3. Database Engine

4. Query optimizer

Q10.2    What is the purpose of the DBMS data definition component?

The data definition component is a main component of DBMS which is used to define, update, and delete the structure or schema or database object like indexes, tables, etc.

For example:

CREATE command is used to create a new table or schema.

DROP command is used to drop or delete an existing table or schema

ALTER command is used to alter the structure of an existing table or schema

Q10.3    What is the purpose of the DBMS data manipulation component?

The data manipulation component is a component of DBMS which is used to manipulate and access the data in the database.

For example:

SELECT command is used to retrieve the data from the database.

INSERT command is used to insert the data into the database or table.

UPDATE command is used to update the data into the existing table or database.

Q10.4    What is the purpose of the DBMS data administration component?

The data administration component is used to install and upgrade the server, controlling and managing user role, monitoring and optimizing the performance, planning for backup and recovery, etc.  

For example:

If you want to define a role for new user or want to modify the role of an existing user is done by the administration component.