Which of the following steps in database planning is used to record an object so that it is represented visually
in the system?
A.
Identifying the relationships between objects
B.
Gathering information
C.
Object identification
D.
Object modeling
Explanation:
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. 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 B is incorrect. Gathering information is thefirst 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 wereinvolved 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 A 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 columnsto the
tables that establish a link from
one table to another.