Chapter 5, Problem 4ARQ

Explanation of Solution

Database by itself is not very useful to business user:

A database contains all the necessary information that is required for processing the business.

• The database is not useful for the business user since the contents that are present in them are structured in an unorganized way.
• The data stored in the database is present in the raw form and hence database is not ideal for the users.

Four elements of database application:

The four elements of database applications that are listed below:

• Forms
• Reports
• Queries
• Application Programs.

Purpose of the elements of database application:

The purpose of the each element is described below:

Forms:

The data present in the database can be viewed, inserted, updated and deleted using the elements.

Let us consider the example:

• Consider the student mark that needs to updates in the database.
• The form can be used to enter the marks scored by the user and the mark entered by the user can be viewed by the user through forms.
• Consider the mark that is entered by the user needs to be corrected and it can be updated through forms.
• Any student record that is not required can be deleted through forms.

Reports:

The data that are stored in the database are represented in the structural format by performing sorting, grouping, filtering and through other data manipulation process.

Let us consider the example:

A student record whose score can be viewed from highest to lowest order by using the sorting operation.

Queries:

The data values can be retrieved based on the search made by the user.

Let us consider the example:

A student whose score is greater than “90” can be viewed using the query given by the user.

Application Programs:

Application programs are used to provide security to the data, maintaining the consistency of the data and to process special purpose.

Let us consider the example:

The student data can be corrected only by the teacher who enters it the data is secured in such a way no student cannot modify the data present in the database...