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 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 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 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 developers use 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 how the tables are logically related, and
adding relational columns to the tables that establish a link from one table to another.