CPT-264 Chapter-9 Exam Latest
Update
Which of the following is a purpose of logical and physical database design?
A) Structure the data in stable structures that are not likely to change over time and that
have minimal redundancy.
B) Develop a logical database design that reflects the actual data requirements that
exist in the forms and reports of an information system.
C) Develop a logical database design from which we can do physical database design.
D) Translate a relational database model into a technical file and database design.
E) All of the above. - ANSWER E) All of the above.
Which of the following is NOT associated with logical and physical database design?
A) Structure the data in stable structures that are not likely to change over time and that
have minimal redundancy.
B) The preparation of a final conceptual model and the implementation of the database
C) Develop a logical database design from which we can do physical database design.
D) Develop a logical database design that reflects the actual data requirements that
exist in the forms and reports of an information system.
E) Translate a relational database model into a technical file and database design. -
ANSWER B) The preparation of a final conceptual model and the implementation of the
database
The most common style for a logical database model is the:
A) relational database model.
B) hierarchical database model.
C) network database model.
D) object-oriented database model.
E) hybrid database model. - ANSWER A) relational database model.
During logical database design, the work of all systems development team members is
coordinated and shared through:
,A) the project dictionary.
B) scheduled weekly meetings.
C) the project leader.
D) JAD sessions.
E) walkthroughs. - ANSWER A) the project dictionary.
Which of the following is NOT a key step in logical database modeling and design?
A) Combine normalized data requirements from all user interfaces into one consolidated
logical database model.
B) Compare the consolidated logical database design with the translated E-R model and
produce, through view integration, one final logical database design for the application.
C) Model how data flow through an information system, the relationships among the data
flows, and how data come to be stored at specific locations.
D) Translate the conceptual E-R data model for the application into normalized data
requirements.
E) Using normalization principles, develop a logical data model for each known user
view for the application. - ANSWER C) Model how data flow through an information
system, the relationships among the data flows, and how data come to be stored at
specific locations.
Combining all normalized user views into one consolidated logical database model
refers to:
A) normalization.
B) requirements structuring.
C) file integration.
D) view integration.
E) logic modeling - ANSWER D) view integration
During physical design, you consider:
A) the definitions of each attribute.
B) the descriptions of where and when data are entered, retrieved, deleted, and
updated.
C) the expectations for response time and data integrity.
D) the descriptions of the file and database technologies to be used.
, E) all of the above. - ANSWER E) all of the above.
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. - ANSWER E) all of the above.
Using the normalized relation notation, an attribute of a relation which is the primary key
of another relation is indicated by:
A) an underline.
B) a circle.
C) a dashed underline.
D) italics.
E) a double-lined ellipse. - ANSWER C) a dashed underline.
The primary deliverable from logical database design is:
A) normalized relations.
B) design specifications.
C) an updated Baseline Project Plan.
D) a list of alternatives design strategies.
E) a production system. - ANSWER A) normalized relations.
A data model that represents data in the form of tables or relations is called a(n):
A) hierarchical database model.
B) network database model.
C) relational database model.
D) hybrid database model.
E) object-oriented database model. - ANSWER C) relational database model.
A named two-dimensional table of data is a(n):
Update
Which of the following is a purpose of logical and physical database design?
A) Structure the data in stable structures that are not likely to change over time and that
have minimal redundancy.
B) Develop a logical database design that reflects the actual data requirements that
exist in the forms and reports of an information system.
C) Develop a logical database design from which we can do physical database design.
D) Translate a relational database model into a technical file and database design.
E) All of the above. - ANSWER E) All of the above.
Which of the following is NOT associated with logical and physical database design?
A) Structure the data in stable structures that are not likely to change over time and that
have minimal redundancy.
B) The preparation of a final conceptual model and the implementation of the database
C) Develop a logical database design from which we can do physical database design.
D) Develop a logical database design that reflects the actual data requirements that
exist in the forms and reports of an information system.
E) Translate a relational database model into a technical file and database design. -
ANSWER B) The preparation of a final conceptual model and the implementation of the
database
The most common style for a logical database model is the:
A) relational database model.
B) hierarchical database model.
C) network database model.
D) object-oriented database model.
E) hybrid database model. - ANSWER A) relational database model.
During logical database design, the work of all systems development team members is
coordinated and shared through:
,A) the project dictionary.
B) scheduled weekly meetings.
C) the project leader.
D) JAD sessions.
E) walkthroughs. - ANSWER A) the project dictionary.
Which of the following is NOT a key step in logical database modeling and design?
A) Combine normalized data requirements from all user interfaces into one consolidated
logical database model.
B) Compare the consolidated logical database design with the translated E-R model and
produce, through view integration, one final logical database design for the application.
C) Model how data flow through an information system, the relationships among the data
flows, and how data come to be stored at specific locations.
D) Translate the conceptual E-R data model for the application into normalized data
requirements.
E) Using normalization principles, develop a logical data model for each known user
view for the application. - ANSWER C) Model how data flow through an information
system, the relationships among the data flows, and how data come to be stored at
specific locations.
Combining all normalized user views into one consolidated logical database model
refers to:
A) normalization.
B) requirements structuring.
C) file integration.
D) view integration.
E) logic modeling - ANSWER D) view integration
During physical design, you consider:
A) the definitions of each attribute.
B) the descriptions of where and when data are entered, retrieved, deleted, and
updated.
C) the expectations for response time and data integrity.
D) the descriptions of the file and database technologies to be used.
, E) all of the above. - ANSWER E) all of the above.
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. - ANSWER E) all of the above.
Using the normalized relation notation, an attribute of a relation which is the primary key
of another relation is indicated by:
A) an underline.
B) a circle.
C) a dashed underline.
D) italics.
E) a double-lined ellipse. - ANSWER C) a dashed underline.
The primary deliverable from logical database design is:
A) normalized relations.
B) design specifications.
C) an updated Baseline Project Plan.
D) a list of alternatives design strategies.
E) a production system. - ANSWER A) normalized relations.
A data model that represents data in the form of tables or relations is called a(n):
A) hierarchical database model.
B) network database model.
C) relational database model.
D) hybrid database model.
E) object-oriented database model. - ANSWER C) relational database model.
A named two-dimensional table of data is a(n):
