Process of Database Design
Logical Design
Based upon the conceptual data model
Four key steps
Logical Design
Based upon the conceptual data model
Four key steps
1. Develop a logical data model for each known user interface for the application using normalization principles.
2. Combine normalized data requirements from all user interfaces into one consolidated logical database model.
3. Translate the conceptual E-R data model for the application into normalized data requirements.
4. Compare the consolidated logical database design with the translated E-R model and produce one final logical database model for the application
Physical Design
Based upon results of logical database design
Key decisions
Choosing storage format for each attribute from the logical database model
Grouping attributes from the logical database model into physical records
Arranging related records in secondary memory (hard disks and magnetic tapes) so that records can be stored, retrieved, and updated rapidly
Selecting media and structures for storing data to make access more efficient
2. Combine normalized data requirements from all user interfaces into one consolidated logical database model.
3. Translate the conceptual E-R data model for the application into normalized data requirements.
4. Compare the consolidated logical database design with the translated E-R model and produce one final logical database model for the application
Physical Design
Based upon results of logical database design
Key decisions
Choosing storage format for each attribute from the logical database model
Grouping attributes from the logical database model into physical records
Arranging related records in secondary memory (hard disks and magnetic tapes) so that records can be stored, retrieved, and updated rapidly
Selecting media and structures for storing data to make access more efficient