Nt1320 Unit 7

Experiencing MIS, 3e (Kroenke)
Chapter Extension 7: Database Design

Multiple Choice

1) A data model ________.
A) is created after the database is designed
B) is an attribute whose value is associated with only one entity instance
C) is a logical representation of the structure of the data
D) does not describe the relationships among data
Answer: C
Page Ref: 384
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 2

2) Once the users have validated and approved the data model, it is transformed into a ________.
A) database design
B) requirement report
C) knowledge management system
D) data repository
Answer: A
Page Ref: 384
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 2

3) Which of the following
A) File numbers
B) Descriptors
C) Titles
D) Identifiers
Answer: D
Page Ref: 385
Difficulty: Easy
AACSB: Use of IT; Analytic skills
Study Question: Study Question 3

8) ________ is an example of an attribute in the E-R model.
A) Order
B) Salesperson
C) Order number
D) Customer
Answer: C
Page Ref: 385
Difficulty: Easy
AACSB: Use of IT; Analytic skills
Study Question: Study Question 3
9) The ________ notation signifies that an adviser can be related to many students and that a student can be related to many advisers.
A) 1:M
B) N:M
C) N:1
D) N:N
Answer: B
Page Ref: 386
Difficulty: Moderate
AACSB: Use of IT; Analytic skills
Study Question: Study Question 3

10) In a classroom, each student can have multiple advisers. In a data model, this can be best represented by which of the following notations?
A) N:M relationship
B) N:N relationship
C) 1:N relationship
D) N:1 relationship
Answer: C
Page Ref: 386
Difficulty: Moderate
AACSB: Use of IT; Analytic skills
Study Question: Study Question 3

11) The little lines in an E-R diagram used as shorthand for the multiple lines between two entities are referred to as
The database design team transforms entities into tables and expresses relationships by defining foreign keys. The tables in the model are to be normalized before converting them into designs. Normalization is the process of converting poorly structured tables into two or more well-structured tables. Database practitioners classify tables into various normal forms according to the kinds of problems they have. Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table. After normalizing, the designer should represent the relationship among those tables to complete the design.
Page Ref: 390
Difficulty: Moderate
AACSB: Use of IT; Analytic skills
Study Question: Study Question 4

5) Explain the role of users in designing a database.
Answer: A database is a model of how the users view their business world. This means that the users are the final judges as to what data the database should contain and how the records in that database should be related to one another. The easiest time to change the database structure is during the data modeling stage. So the user should be actively involved in the modeling process. The user review of a data model is crucial. When a database is developed, the user must carefully review the data model.
Page Ref: 392- 393
Difficulty: Easy
AACSB: Use of IT; Analytic skills
Study