60) Multiple key retrieval is possible with sequential file organization.
Classification: Concept
61) File restoration can be achieved through backup copies of a file, audit trails, and row image
files.
Classification: Concept
62) Data security can be built into a file through encryption, passwords, or prohibiting users from
directly manipulating a file.
Classification: Concept
63) Designing the database for an Internet-based electronic commerce application differs
significantly from the process followed when designing the database for other types of
applications.
Classification: Concept
64) Which of the following is a purpose of logical model and physical database design?
A) Structure the data in unstable structures that are likely to change over time and that have
extensive redundancy.
B) Develop a logical database to help identify a steering committee.
C) Develop a logical database design from which we can do physical database design.
D) Translate a relational database model into network database models.
E) Develop a marketing plan for both logical and physical database design.
Classification: Concept
11
65) 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.
Classification: Concept
66) 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.
Classification: Concept
67) 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.
Classification: Concept
12
68) Which of the following is NOT a key step in logical database 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.
Classification: Concept
69) 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.
Classification: Concept
70) During physical design, you typically don’t 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) creating a new set of E-R models.
Classification: Concept
13
71) Key physical database design decisions typically do not 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) conducting requirements structuring.
Classification: Concept
72) 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.
Classification: Concept
73) 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.
Classification: Concept
14
74) 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.
Classification: Concept
75) A named two-dimensional table of data is a(n):
A) network.
B) tree structure.
C) relation.
D) tuple.
E) object.
Classification: Concept
76) Which of the following is NOT a true statement regarding a relation?
A) Each relation consists of a set of named columns and an arbitrary number of unnamed rows.
B) Each column in a relation corresponds to an attribute of that relation.
C) An entry at the intersection of each row and column has a single value.
D) The columns may not be interchanged or stored any sequence.
E) The rows may be interchanged or stored in any sequence.
Classification: Concept
77) Assume the structure of a relation is Employee (EmpID, Name, Dept, Salary). The number of
attributes for this relation would:
A) be three.
B) be four.
C) be five.
D) be six.
E) vary depending upon the number of employees.
Classification: Application
15
78) Which of the following properties of a relation states that an entry at the intersection of each
row and column is single-valued?
A) Entries in cells are simple.
B) Entries in columns are from the same set of values.
C) Each row is unique.
D) The sequence of rows is insignificant.
E) The sequence of columns can be interchanged.
Classification: Concept
79) A relation that contains a minimum amount of redundancy and allows users to insert, modify,
and delete the rows in a table without errors or inconsistencies is a(n):
A) independent relation.
B) simple relation.
C) unnormalized relation.
D) well-structured relation.
E) derived relation.
Classification: Concept
80) The process of converting complex data structures into simple, stable data structures is
referred to as:
A) normalization.
B) simplification.
C) structuring.
D) process modeling.
E) relational conversion.
Classification: Concept
16
81) When each nonprimary key attribute is identified by the whole key, the relation is said to be
in at least:
A) second normal form.
B) third normal form.
C) fourth normal form.
D) fifth normal form.
E) a relational form.
Classification: Concept
82) A particular relationship between two attributes best defines:
A) context.
B) functional dependency.
C) normal form.
D) structure.
E) join.
Classification: Concept
83) For any relation R, if, for every valid instance of A, that value of A uniquely determines the
value of B:
A) then a primary dependency exists in the relation.
B) then A is said to be functionally dependent on B.
C) then B is said to be functionally dependent on A.
D) then A and B are candidate keys for the relation.
E) None of the above are true.
Classification: Concept
17