Smith works as a Database Administrator for DWorlds Inc. The management instructs him to plan a
database where identifying the key objects or entities for database management is important.
Which of the following database planning steps will help him to accomplish the task?

A.
Object identification

B.
Gathering information

C.
Identifying the relationships between objects

D.
Object modeling

Explanation:
In the object identification process 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 B is incorrect. Gathering information is the first step of database planning and requires a
good understanding of what tasks 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 D 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 developers use tools such as pencils, paper, word
processing etc., as well as create software
programs for data modeling of the database.
Answer C 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 how the tables are logically related, and adding relational columns
to the tables that establish a link from
one table to another.