Databases Reference
In-Depth Information
DATA MODELING
Starting Point
Go to
www.wiley.com/college/gillenson
to assess your knowledge of data
modeling.
Determine where you need to concentrate your effort.
What You'll Learn in This Chapter
▲
The database design process and the initial design decisions in database design
▲
The three general categories of databases and their impact on database design
▲
Database modeling goals
▲
The role of business rules
▲
The importance of entities, attributes, and relationships
▲
Basic database objects: tables, views, and indexes
▲
Basic relationship types: binary, unary, and ternary
▲
Creating and reading an E-R diagram
After Studying This Chapter, You'll Be Able To
▲
Identify the tasks included in each database design step
▲
Accurately represent the business structure of your organization by identi-
fying the business rules associated with it
▲
Determine the appropriate functional type of database you need in your
organization by analyzing the business and user applications it will support
▲
Identify entities, attributes, and relationships
▲
Create a model including one-to-one, one-to-many, and many-to-many
relationships
▲
Properly use cardinality and modality in describing relationships
▲
Recognize requirements for intersection data
▲
Develop an entity-relationship (E-R) model that uniquely identifies and
describes each instance of an entity within your organization and its attrib-
utes, as well as show the associations and relationships between entities
▲
Read an E-R relational data diagram