Key physical database design decisions include:
A) choosing the storage format for each attribute from the logical database model.
B) grouping attributes from the logical database model into physical records.
C) arranging related records in secondary memory so that individual and groups of records can be stored, retrieved, and updated rapidly.
D) selecting media and structures for storing data to make access more efficient.
E) all of the above.

Question

Quizplus · Accepted Answer

All of the listed options are key physical database design decisions that need to be made. A significant part of database management involves choosing the appropriate storage format for each attribute, grouping them into physical records, arranging related records in secondary memory for quick retrieval and updating, and selecting storage media and structures to boost data access efficiency. Therefore, all the options mentioned above are essential for database design.

Key Physical Database Design Decisions Include