Databases Reference
In-Depth Information
SELF-CHECK
•
Describe the relationship in Figure 3-17, including all of the informa-
tion available in the diagram.
•
Explain why it is helpful to study other data diagrams before creat-
ing your own data model.
SUMMARY
This chapter introduced data modeling and the use of data diagrams. We started
with a general look at the design process and some of the decisions you must
make about the type of database you need to design and your design goals. We
looked at relational database modeling and the E-R model in some detail, includ-
ing an introduction to some fundamental database objects. You were introduced
to the various types of relationships that might be included in your database
model. Finally, we talked about modeling tools and compared two example data
diagrams.
KEY TERMS
Associative entity
Balanced tree index
Base object
Binary relationship
Binary tree index
B-tree index
Bulk loading
Business rules
Cardinality
Clustered index
Conceptual design
Concurrency
Database object
Data diagram
Data mart
Data model
Data warehouse
Decision support system (DSS)
Entity-Relationship diagram (ERD)
Entity-Relationship (E-R) modeling
Field
Hybrid database
Identifier
Index
Intersection data
Large object (LOB) data
Leaf node
Logical design
Many-to-many (M-M) binary relation-
ship
