Databases Reference
In-Depth Information
ASSESS YOUR UNDERSTANDING
Go to
www.wiley.com/college/gillenson
to evaluate your knowledge of data
modeling.
Measure your learning by comparing pre-test and post-test results.
Summary Questions
1.
Entities and attributes are identified during logical design. True or False?
2.
A transactional database must support which of the following activities?
(a)
adding new data
(b)
changing existing data
(c)
deleting data
(d)
all of the above
3.
Your design must ensure that any customer purchases at least $20.00 in
merchandise. This is an example of which of the following?
(a)
entity definition
(b)
business rule
(c)
attribute
(d)
relational integrity
4.
Each table in your database typically represents which of the following?
(a)
an entity
(b)
an attribute
(c)
a relationship
(d)
a data diagram
5.
You are defining an employee entity. Which of the following would you
likely use as the identifier?
(a)
first name
(b)
last name
(c)
employee ID
(d)
hire date
(e)
none of the above
6.
A foreign key is based on a unique value in the referenced entity. True or
False?
7.
Which statement best describes attributes?
(a)
You should have a table for each attribute defined in your model.
(b)
Any attribute can be used as an entity's identifier.
(c)
Attributes describe entities.
(d)
Attributes are used in object modeling only.
