A Practical Guide to Database Design – 2nd
Edition, Rex Hogan | Complete Solutions
Manual Chapters 1–11
*DATABASE DESIGN*
The *five purposes* of *Database Design*: - answers-1. Structure the data in stable structures,
called *normalized tables*
2. Develop a *logical database design*
3. Develop a logical database design from which we can do *physical database design*
4. *Translate a relational database model* into a *technical file and database design* that
balances several performance factors
5. *Choose data storage technologies* (such as Read/ Write DVD or optical disc) that will
efficiently, accurately, and securely process database activities
Structure the data in - answers-stable structures, called *normalized tables*
Develop a *logical* - answers-database design
Develop a logical database design from which we can - answers-do *physical database design*
Translate a relational database model into a - answers-technical file and database design that
balances several performance factors
Choose data storage - answers-*technologies* (such as Read/ Write DVD or optical disc) that
will *efficiently, accurately, and securely* process database activities
1
,Two benefits of normalized tables - answers-• *Not likely to change* over time
• Have *minimal redundancy*
Developing a *logical database* design *reflects* - answers-the *actual data requirements*
that exist in the forms and reports of an information system
Developing a physical database design from the logical database design requires the use of -
answers-relational database management systems
File and Database Design occurs in two steps:
(Develop and Prescribe what?) - answers-*1.)* *Develop a logical database model*, which
describes data using notation that corresponds to a data organization used by a database
management system.
*2.)* *Prescribe the technical specifications* for computer files and databases in which to store
the data
The most common style for a logical database model is the - answers-relational database model
What provides the technical specifications for computer files and databases in which to store
the data - answers-*Physical* database design
Logical and physical database design in - answers-*parallel* with other system design steps
*THE PROCESS OF DATABASE DESIGN* - answers-
2
,*Four key steps in logical database modeling and design:* - answers-
Develop a logical data model for each known - answers-*user interface* for the application
using *normalization principles*
*Combine normalized data requirements* from all user interfaces into - answers-*one
consolidated logical database model* (view integration)
*Translate* the conceptual - answers-*E-R data model* for the application *into normalized
data requirements*
*Compare* the *consolidated logical database design* with the
(produce what?) - answers-*translated E-R model* and produce one final logical database
model for the application
During *physical database design*, you use the __________ of these four key logical database
design steps. - answers-*results*
During *physical database design*, along with the results of the key logical database design
steps, *you also consider what 4 things:* - answers-
*Definitions* of each - answers-attribute
Descriptions of *where and when* - answers-data are entered, retrieved, deleted, and updated
*Expectations* for - answers-response time and data integrity
3
, Descriptions of the *file* and - answers-*database technologies* to be used
*Key physical database design decisions* include: - answers-1. *Choosing a storage format
(called data type) for each attribute* from the logical database model.
2. *Grouping attributes* from the logical database model into physical records.
3. *Arranging related records in secondary memory* (hard disks and magnetic tapes) so that
records can be stored, retrieved and updated rapidly (called file organization).
4. *Selecting media and structures* for storing data to make access more efficient.
When *choosing a storage format (called data type) for each attribute* from the logical
database model, the format is chosen to - answers-minimize storage space and to maximize
data quality
When *arranging related records in secondary memory* (hard disks and magnetic tapes) so
that records can be stored, retrieved and updated rapidly (called file organization), you should
also consider - answers-protecting data and recovering data after errors are found
When *selecting media and structures* for storing data to make access more efficient, the
choice of media affects the - answers-utility of different file organizations
When *selecting media and structures*, the primary structure used today to make access to
data more rapid is - answers-*key indexes* on unique and non-unique keys
Logical database design is still somewhat - answers-"conceptual" (like E-R modeling)
The main emphasis with logical design is to ensure a - answers-well-structured database
4
Edition, Rex Hogan | Complete Solutions
Manual Chapters 1–11
*DATABASE DESIGN*
The *five purposes* of *Database Design*: - answers-1. Structure the data in stable structures,
called *normalized tables*
2. Develop a *logical database design*
3. Develop a logical database design from which we can do *physical database design*
4. *Translate a relational database model* into a *technical file and database design* that
balances several performance factors
5. *Choose data storage technologies* (such as Read/ Write DVD or optical disc) that will
efficiently, accurately, and securely process database activities
Structure the data in - answers-stable structures, called *normalized tables*
Develop a *logical* - answers-database design
Develop a logical database design from which we can - answers-do *physical database design*
Translate a relational database model into a - answers-technical file and database design that
balances several performance factors
Choose data storage - answers-*technologies* (such as Read/ Write DVD or optical disc) that
will *efficiently, accurately, and securely* process database activities
1
,Two benefits of normalized tables - answers-• *Not likely to change* over time
• Have *minimal redundancy*
Developing a *logical database* design *reflects* - answers-the *actual data requirements*
that exist in the forms and reports of an information system
Developing a physical database design from the logical database design requires the use of -
answers-relational database management systems
File and Database Design occurs in two steps:
(Develop and Prescribe what?) - answers-*1.)* *Develop a logical database model*, which
describes data using notation that corresponds to a data organization used by a database
management system.
*2.)* *Prescribe the technical specifications* for computer files and databases in which to store
the data
The most common style for a logical database model is the - answers-relational database model
What provides the technical specifications for computer files and databases in which to store
the data - answers-*Physical* database design
Logical and physical database design in - answers-*parallel* with other system design steps
*THE PROCESS OF DATABASE DESIGN* - answers-
2
,*Four key steps in logical database modeling and design:* - answers-
Develop a logical data model for each known - answers-*user interface* for the application
using *normalization principles*
*Combine normalized data requirements* from all user interfaces into - answers-*one
consolidated logical database model* (view integration)
*Translate* the conceptual - answers-*E-R data model* for the application *into normalized
data requirements*
*Compare* the *consolidated logical database design* with the
(produce what?) - answers-*translated E-R model* and produce one final logical database
model for the application
During *physical database design*, you use the __________ of these four key logical database
design steps. - answers-*results*
During *physical database design*, along with the results of the key logical database design
steps, *you also consider what 4 things:* - answers-
*Definitions* of each - answers-attribute
Descriptions of *where and when* - answers-data are entered, retrieved, deleted, and updated
*Expectations* for - answers-response time and data integrity
3
, Descriptions of the *file* and - answers-*database technologies* to be used
*Key physical database design decisions* include: - answers-1. *Choosing a storage format
(called data type) for each attribute* from the logical database model.
2. *Grouping attributes* from the logical database model into physical records.
3. *Arranging related records in secondary memory* (hard disks and magnetic tapes) so that
records can be stored, retrieved and updated rapidly (called file organization).
4. *Selecting media and structures* for storing data to make access more efficient.
When *choosing a storage format (called data type) for each attribute* from the logical
database model, the format is chosen to - answers-minimize storage space and to maximize
data quality
When *arranging related records in secondary memory* (hard disks and magnetic tapes) so
that records can be stored, retrieved and updated rapidly (called file organization), you should
also consider - answers-protecting data and recovering data after errors are found
When *selecting media and structures* for storing data to make access more efficient, the
choice of media affects the - answers-utility of different file organizations
When *selecting media and structures*, the primary structure used today to make access to
data more rapid is - answers-*key indexes* on unique and non-unique keys
Logical database design is still somewhat - answers-"conceptual" (like E-R modeling)
The main emphasis with logical design is to ensure a - answers-well-structured database
4
