James works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database.
James has been assigned the task to store information for each object in the database. Which of the following
steps will help him accomplish the task?
A.
Identifying the information for objects
B.
Object modeling
C.
Object identification
D.
Identifying the relationships between objects
Explanation:
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 D 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.
Answer B is incorrect. Object modeling is the thirdstep 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 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.