Which of the following steps in database planning helps to determine the requirements of the database through
interviewing?

A.
Gathering information

B.
Identifying the relationship between objects

C.
Identify the objects

D.
Identifying the type of information for each objects

E.
Modeling the object

Explanation:
Gathering information is the first step of databaseplanning and requires a good understanding of whattasks
are to be performed in the database. In case the database has to replace a paper-based or a manual system,
the old system can provide all the necessary information. Moreover, all those who were involved with the
previous system should be interviewed to determine what they did and what is now needed for the new
database. The limitations, problems, and bottlenecks of the old system should also be identified.
Answer C is incorrect. In the object identificationprocess in database planning, it is necessary to identify the
key objects or entities for database management. There are generally a few primary objects, and once these
are identified, the related items become visible. Answer E is incorrect. Object modeling is the third step in
database planning in which objects are identified in the system. A user should record an object in such a way
that it is represented visually in the system. He can use the database model as a reference during
implementation of the database. Database developersuse tools such as pencils, paper, word processing etc.,
as well as create software programs for data modeling of the database. Answer D is incorrect. Identifying
information for objects is the fourth step in database planning where the information for each object is stored.
In a table, there are four columns that contain different types of information for objects:
1.Categorical column: In this column, data is classified and grouped, and a limited selection of data is stored.
2.Relational or referential column: In this column,a link is established between information in one table and
related information in another table.
3.Identifier column: In this column, each item stored in the table is identified. 4.Raw data column: In this
column, tangible information is stored and is determined by a source that is external to the database.
Answer B is incorrect. Identifying relationships between objects is the last step in database planning, which is
the ability to relate information about various items in the database. Isolated types of information can be stored
separately, but the data can be combined according to the requirements of the database engine. Identifying the
relationship between objects in the design process necessitates looking at the tables, determining howthe
tables are logically related, and adding relationalcolumns to the tables that establish a link from one table to
another.