Database Reference
In-Depth Information
You then learned about the three characteristics of table relationships: the type of relation-
ship (one-to-one, one-to-many, many-to-many), the type of participation (optional or man-
datory), and the degree of participation (minimum/maximum number of related records).
The chapter ended with a discussion of integrity-related terms. Here you learned that
a field specification establishes the general, physical, and logical characteristics of a
field—characteristics that are an integral part of every field in the database. You then
learned that data integrity is one of the most important aspects of the database design pro-
cess because of its positive effect on the data in the database. Also, you now know that
there are four types of data integrity—three based on database structure and one based on
the way the organization interprets and uses its data. These levels of integrity ensure the
quality of your database's design and the accuracy of the information you retrieve from it.
Review Questions
1 . Why is terminology important?
2 . Name the four categories of terms.
3 . What is the difference between data and information?
4 . What does a null represent?
5 . What is a null's major disadvantage?
6 . What are the chief structures in the database?
7 . Name the three types of tables.
8 . What is a view?
9 . State the difference between a key and an index.
10 . What are the three types of relationships that can exist between a pair of tables?
11 . What are the three ways in which you can characterize a relationship?
12 . What is a field specification?
13 . What three types of elements does a field specification incorporate?
14 . What is data integrity?
15 . Name the four types of data integrity.
Search WWH ::




Custom Search