Database Concepts - Data Warehouse Systems: Design and Implementation - page 45

2.7 Bibliographic Notes
For a general overview of all the concepts covered in this chapter, we refer the
reader to the textbook [ 49 ]. Other relevant database textbooks are [ 58 , 168 ].
An overall view of requirements engineering is given in [ 217 ]. Conceptual
database design is covered in [ 148 ] although it is based on UML [ 17 ]instead
of the entity-relationship model. Logical database design is covered in [ 198 ].
A thorough overview of the components of the SQL:1999 standard is given in
[ 133 , 135 ], and later versions of the standard are described in [ 108 , 132 , 236 ].
Physical database design is detailed in [ 116 ].
2.8 Review Questions
2.1 What is a database? What is a DBMS?
2.2 Describe the four phases used in database design.
2.3 Define the following terms: entity type, entity, relationship type,
relationship, role, cardinality, and population.
2.4 Illustrate with an example each of the following kinds of relationship
types: binary, n -ary, one-to-one, one-to-many, many-to-many, and
recursive.
2.5 Discuss different kinds of attributes according to their cardinality and
their composition. What are derived attributes?
2.6 What is an identifier? What is the difference between a strong and a
weak entity type? Does a weak entity type always have an identifying
relationship? What is an owner entity type?
2.7 Discuss the different characteristics of the generalization relationship.
2.8 Define the following terms: relation (or table), attribute (or column),
tuple (or line), and domain.
2.9 Explain the various integrity constraints that can be described in the
relational model.
2.10 Discuss the basic rules for translating an ER schema into a relational
schema. Give an example of a concept of the ER model that can be
translated into the relational model in different ways.
2.11 Illustrate with examples the different types of redundancy that may
occur in a relation. How can redundancy in a relation induce problems
in the presence of insertions, updates, and deletions?
2.12 What is the purpose of functional and multivalued dependencies? What
is the difference between them?
2.13 What are normal forms? Specify several normal forms that can be
defined on relations. For each one of these normal forms, give an
example of a relation that does not satisfy the particular normal form.