Database Design
Goals and Prerequisites to Database Design
- The data model may have to be divided into multiple data models to reflect database distribution and database replication decisions.
- Data distribution refers to the distribution of either specific tables, records, and/or fields to different physical databases.
- Data replication refers to the duplication of specific tables, records, and/or fields to multiple physical databases.
- Each sub-model or view should reflect the data to be stored on a single server.