| | |
Summary: March 23, 2008 DB:EER Model - 1 1
Informal Design Guidelines
March 23, 2008 DB:EER Model - 1 2
Objectives
Measuring the Quality of Relational Database Design +
Database Design Methodology +
Informal Design Guidelines for Relational Schema +
March 23, 2008 DB:EER Model - 1 3
- Measuring the Quality of Relational Database Design
At logical level
How users interpret relation schemas and the meaning of
attributes?
At the physical level
How the tuples in a base relation are stored and updated.
March 23, 2008 DB:EER Model - 1 4
- Database Design Methodology
A Bottom-Up Method
We start by identifying all the attributes then trying to group
attributes based on some relationships, to build relations.
A Top-Down Method
|