Section 2
All of the following could be
attributes of an ENTITY called PERSON, except which one?
Haircolor
Weight
Gender
Natacha
Hansen (*)
Attributes can only have one
value at any point for each instance in the entity. True or False?
True
(*)
False
Entities are usually verbs.
True or False?
True
False
(*)
A/an _________'s value can be a
number, a character string, a date, an image, a sound
Attribute
(*)
Table
ERD
Entity
In the following statements,
find two good examples of ENTITY: Instance. (Choose Two)
DAIRY
PRODUCT: milk (*)
BOOK:
Biography of Mahatma Gandhi (*)
TRAIN:
runs
VEGETABLE:
grows
Attributes can be either
mandatory or optional. True or False?
True
(*)
False
Which of the following
statements about Entities are true?
They
never have Instances
A name
for a set of similar "things" (*)
They
are usually a noun. (*)
"Something"
of significance to the business about which data must be known. (*)
The word "Volatile"
means:
Changing
constantly; unstable (*)
Large
quantity
Static;
unlikely to change
Limited
quantity
Which of the following
statements are true about ERD's? (Choose Two)
A piece
of information should only be found in one place on an ERD. (*)
All
data must be represented on the ERD, including derived summaries and the result
of calculations.
A piece
of information can be shown multiple times on an ERD.
You
should not model derivable data. (*)
Which of the following can be
found in an ERD? (Choose Two)
Entities.
(*)
Instances.
Attributes.
(*)
Tables.
Entity Relationship modeling is
dependent on the hardware or software used for implementation, so you will need
to change your ERD if you decide to change Hardware Vendor. True or False?
True
False
(*)
A Conceptual Model is not
concerned with how the Physical Model will be implemented. True or False?
True
(*)
False
Data models show users the data
that their Physical Model will contain. True or False?
True
(*)
False
Documenting Business Requirements
helps developers control the scope of the system and prevents users from
claiming that the new system does not meet their business requirements. True or
False?
True
(*)
False
Many reasons exist for creating a
conceptual model. Choose three appropriate reasons from the options below.
They
capture current and future needs. (*)
They
capture the implementation details of the physical model.
They
model functional and informational needs. (*)
They
model the information flow of data.
They
accurately describe what a physical model will contain. (*)
No comments:
Post a Comment