Database Reference
In-Depth Information
Key Terms
association pattern
attribute
binary relationship
cardinality
child
composite identifier
crow's foot symbol
data model
degree
discriminator
entity
entity class
entity instance
entity-relationship (E-R) diagrams
entity-relationship (E-R) model
exclusive subtype
extended E-R model
HAS-A relationship
ID-dependent entity
identifier
identifying relationship
IE Crow's Foot model
inclusive subtype
Information Engineering (IE) model
Integrated Definition 1, Extended
(IDEF1X)
IS-A relationship
mandatory
mandatory-to-mandatory (M-M)
relationship
mandatory-to-optional (M-O) relationship
many-to-many (N:M) relationship
maximum cardinality
minimum cardinality
nonidentifying relationship
one-to-many (1:N) relationship
one-to-one (1:1) relationship
optional
optional-to-mandatory (O-M) relationship
optional-to-optional (O-O) relationship
owner entity
parent
recursive relationship
relationship
relationship class
relationship instance
requirements analysis
strong entity
subtype
supertype
systems analysis and design
systems development life cycle (SDLC)
ternary relationship
unary relationship
Unified Modeling Language (UML)
weak entity
Review Questions
5.1 Describe the two phases in designing databases that arise from the development of
new information systems.
5.2 In general terms, explain how a data model could be used to design a database for a
small video rental store.
5.3 Explain how a data model is like a building blueprint. What is the advantage of making
changes during the data modeling stage?
5.4 Who is the author of the entity-relationship data model?
5.5 Define entity . Give an example of an entity (other than one presented in this chapter).
5.6 Explain the difference between an entity class and an entity instance.
 
 
 
Search WWH ::




Custom Search