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 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 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 columns
to the tables that establish a link from
one table to another.