answersLogoWhite

0

What else can I help you with?

Continue Learning about Computer Science

What Four main types of actions involved in database?

A database management system is a collection of programs that enables users to create and maintain a database. The DBMS is general purpose software that facilitates the processes of Defining, Constructing, Manipulating and Sharing data among various users and applications.Defining a database involves specifying the data type, structure, and constraints of the data to be stored in the database. The database definition or descriptive data information is also stored in the database in the form of a database catalog or dictionary; it is called meta-data.Constructing the database is the process of storing the data on some storage medium that is controlled by the DBMS.Manipulating a database includes functions such as querying the database to retrieve specific data, updating the database to reflect changes in the miniworld, and generating reports from the data.Sharing a database allows multiple users and programs to access the database simultaneously.


What is a database made up?

Database comprises of records that are related to each other. In database the data is stored in the form of tables, are called database tables .


What are the four main purposes of information?

the for main purposes of information


List and describe three main capabilities or tools of a DBMS?

A data definition capability to specify the structure of the content of the database. This capability would be used to create database tables and to define the characteristics of the fields in each table. A data dictionary is used to store definitions of data elements, and their characteristics, in the database. In large, corporate databases, the data dictionary may capture additional information, such as usage, ownership, authorization, security, and the individuals, business functions, programs, and reports that use each data element. A data manipulation language, such as SQL, is used to add, change, delete, and retrieve the data in the database. This language contains commands that permit end users and programming specialists to extract data from the database to satisfy information requests and develop applications. @ pp. 217-218


What is the main four phases of query processing in dbms?

Query processing can be divided into four main phases: decomposition, optimization, code generation, and execution.