Databases Reference
In-Depth Information
DESIGNING A DATABASE
Starting Point
Go to
www.wiley.com/college/gillenson
to assess your knowledge of database
design.
Determine where you need to concentrate your effort.
What You'll Learn in This Chapter
▲
Entity-relationship to relational table conversion processes
Associative table requirements
▲
Standard normalization forms
▲
After Studying This Chapter, You'll Be Able To
▲
Convert stand-alone entities to tables
Identify entity relationships by type and conversion requirements
▲
Convert unary entity relationships to database objects
▲
Convert binary entity relationships to database objects
▲
Compare E-R diagrams and the resulting relational table designs
▲
Select appropriate foreign keys and their placement in relational tables
▲
Create associative tables, including intersection data where needed
▲
Recognize unnormalized data
▲
Normalize a database by applying the first, second, and third normal forms
▲
Normalize a database through non-loss decomposition
▲
Normalize the tables created from an E-R diagram
▲
Recognize the need for denormalization and selectively denormalize data
▲