Database Design
Database Capacity Planning
- A database is stored on disk.
- The database administrator will want an estimate of disk capacity for the new database to ensure that sufficient disk space is available.
- Database capacity planning can be calculated with simple arithmetic as follows.
- For each table, sum the field sizes.
- This is the record size for the table.
- For each table, multiply the record size times the number of entity instances to be included in the table.