《管理信息系统（第7版）》章节练习题及答案chapter extension 05

1、管理信息系统（第7版）章节练习题及答案chapter extension 05管理信息系统（第7版）章节练习题及答案chapter extension 05 Copyright 2017 Pearson Education, Inc.管理信息系统（第7版）章节练习题及答案chapter extension 05Experiencing MIS, 7e (Kroenke)Chapter Extension 5 Database Design1) Which of the following is true of a data model?A) It is created after the da

2、tabase is designed.B) It is an attribute whose value is associated with only one entity instance.C) It is a logical representation of the structure of the data.D) It does not describe the relationships among the data.Answer: CAACSB: Information TechnologyDifficulty: 2: ModerateCourse LO: Discuss bes

3、t practices for using and managing databases.Learning Obj: LO 17.2: How are database application systems developed?Classification: Concept2) Once the users have validated and approved the data model, it is transformed into a _.A) database designB) technical reportC) knowledge systemD) data repositor

4、yAnswer: AAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.2: How are database application systems developed?Classification: Concept3) A data model is a logical representation of the structure of the data.Answer: T

5、RUEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.2: How are database application systems developed?Classification: Concept4) A data model does not depict the relationships among the data.Answer: FALSEAACSB: Info

6、rmation TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.2: How are database application systems developed?Classification: Concept5) A database contains a description of both the data and the relationships among the data.Answer: FALS

7、EAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.2: How are database application systems developed?Classification: Concept6) Explain the database development process.Answer: A database application consists of form

8、s, reports, queries, and application programs. At first, the developers interview users and develop the requirements for the new system. During this process, the developers analyze existing forms, reports, queries, and other user activities. The requirements for the database are then summarized in a

9、 data model, which is a logical representation of the structure of the data. The data model contains a description of both the data and the relationships among the data. It is similar to a blueprint. Once the users have validated and approved the data model, it is then transformed into a database de

10、sign. After that, the design is implemented in a database, and that database is then filled with user data.AACSB: Information TechnologyDifficulty: 3: ChallengingCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.2: How are database application systems developed?C

11、lassification: Concept7) Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them?A) entity-relationship (E-R) data modelB) Unified Mode

12、ling Language (UML)C) object-relational modelD) semantic data modelAnswer: AAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept8

13、) Which of the following is true of entities?A) Entities have an identifier whose value is associated with every entity in the data model.B) Entities can only represent a logical construct or transaction, not a physical object.C) The characteristics of entities are described by attributes.D) The nam

14、es of entities are always plural.Answer: CAACSB: Information TechnologyDifficulty: 2: ModerateCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept9) Carol, an online shopping cu

15、stomer, raises a complaint stating she had placed an order for books two weeks ago but has still not received them. Nigel, in charge of handling complaints for the site, wants to verify Carols complaint. He tracks the order number and the order date for Carols books. The data that Nigel is tracking

16、are also called _. A) attributesB) dependenciesC) cardinalitiesD) alternativesAnswer: AAACSB: Reflective ThinkingDifficulty: 2: ModerateCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classificati

17、on: Application10) Which of the following statements is true of identifiers?A) They are constraints on minimum requirements in a relationship.B) They are data that users want to track.C) They highlight instances of data duplication in a database.D) They are attributes whose values are associated wit

18、h only one entity instance.Answer: DAACSB: Information TechnologyDifficulty: 2: ModerateCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept11) Which of the following is true of

19、 an entity-relationship (E-R) diagram?A) Each entity is shown in separate rectangles.B) Many-to-many relationships are generally denoted by N:N.C) A crows foot represents a 1:N relationship between two entities.D) Crows foot is a shorthand representation for a single relationship between entities.An

20、swer: CAACSB: Information TechnologyDifficulty: 2: ModerateCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept12) Roger teaches a Chemistry class at the state university. Each

21、student in the class can only be tutored by Roger; however, he can tutor multiple students. In a data model, this relationship is best represented as a(n) _.A) N:M relationshipB) N:N relationshipC) 1:N relationshipD) 1:1 relationshipAnswer: CAACSB: Reflective ThinkingDifficulty: 2: ModerateCourse LO

22、: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Application13) Which of the following notations signifies that an adviser can be related to many students and that a student can be related t

23、o many advisers?A) 1:NB) N:MC) N:1D) N:NAnswer: BAACSB: Information TechnologyDifficulty: 2: ModerateCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept14) In an organization,

24、the administrative department consists of one clerk whose sole responsibility is the management of various administrative functions. The notation that accurately indicates this relationship is _.A) 1:NB) N:NC) 1:1D) N:MAnswer: CAACSB: Information TechnologyDifficulty: 2: ModerateCourse LO: Discuss b

25、est practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept15) The angled lines in an entity-relationship (E-R) diagram used as shorthand to represent multiple relationships are referred to as a(n) _.A) c

26、rows footB) identifierC) attributeD) cardinality lineAnswer: AAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept16) Maximum car

27、dinality in an entity-relationship (E-R) diagram refers to the maximum number of _.A) normalizations possible in a diagramB) entities that can be involved in a relationshipC) identifiers possible in a particular diagramD) attributes associated with an entityAnswer: BAACSB: Information TechnologyDiff

28、iculty: 2: ModerateCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept17) Entities have attributes that describe characteristics of the entity.Answer: TRUEAACSB: Information Te

29、chnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept18) An identifier is an attribute whose value is associated with every entity in the data model.An

30、swer: FALSEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept19) Entities have relationships to attributes but not to each othe

31、r.Answer: FALSEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept20) In an entity-relationship (E-R) diagram, a line is used to

32、 represent a relationship between two entities.Answer: TRUEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept21) The notation N

33、:N is used to indicate a many-to-many relationship in an E-R diagram.Answer: FALSEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Co

34、ncept22) While representing the relationship between two entities in an entity-relationship diagram, the N:N notation is used to indicate that the same number of entities are present on each end of the relationship.Answer: TRUEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best p

35、ractices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept23) 1:N means that more than one entity is allowed on each side of the relationship.Answer: FALSEAACSB: Information TechnologyDifficulty: 1: EasyCours

36、e LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept24) The crows foot notation shows the minimum number of entities that can be involved in a relationship.Answer: FALSEAACSB: Inform

37、ation TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept25) The maximum number of entities that can be involved in a relationship is known as maxi

38、mum cardinality.Answer: TRUEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept26) In an entity-relationship diagram, a vertical

39、 bar on the lines indicates that at least one entity of that type is required in the relationship.Answer: TRUEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship d

40、ata model?Classification: Concept27) What are the different types of relationships represented in a data model?Answer: Entities in a data model have relationships with each other. Database designers use diagrams called entity-relationship (E-R) diagrams to explain the relationships. The relationship

41、s can be of three types: one-to-one, one-to-many, and many-to-many. The one-to-one relationship is denoted by 1:1 and one-to-many is denoted by 1:N. Many-to-many relationships are denoted by N:M.AACSB: Information TechnologyDifficulty: 2: ModerateCourse LO: Discuss best practices for using and manag

42、ing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept28) Explain the difference between maximum and minimum cardinality.Answer: Cardinality is the number of entities that can be involved in a relationship. There can be both a maxim

43、um and minimum constraint on cardinality. The maximum number of entities that can be involved in a relationship is known as maximum cardinality. Constraints on minimum requirements (minimum entities) are called minimum cardinalities.AACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss

44、best practices for using and managing databases.Learning Obj: LO 17.3: What are the components of the entity-relationship data model?Classification: Concept29) The process of converting poorly structured tables into two or more well-structured tables is referred to as _.A) replicationB) integrationC

45、) actualizationD) normalizationAnswer: DAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transformed into a database design?Classification: Concept30) The data integrity problem can occur onl

46、y if data are _.A) duplicatedB) missingC) inefficientD) insufficientAnswer: AAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transformed into a database design?Classification: Concept31) Nor

47、malized tables eliminate _.A) data dependencyB) data duplicationC) data insufficiencyD) data conversionAnswer: BAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transformed into a database de

48、sign?Classification: Concept32) The general goal of normalization is to _.A) create a copy of an existing tableB) establish relationships among the entities in a tableC) convert two or more tables into a single tableD) construct tables such that every table has a single topicAnswer: DAACSB: Informat

49、ion TechnologyDifficulty: 2: ModerateCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transformed into a database design?Classification: Concept33) According to the kinds of problems they have, database practitioners classify tables into v

50、arious _.A) solved formsB) cardinalitiesC) normal formsD) relationshipsAnswer: CAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transformed into a database design?Classification: Concept34)

51、Normalization is a database design concept that helps to construct well-structured tables.Answer: TRUEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transformed into a database design?Class

52、ification: Concept35) The data integrity problem can occur only if data are missing.Answer: FALSEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transformed into a database design?Classifica

53、tion: Concept36) The general goal of normalization is to construct tables such that every table has a single topic or theme.Answer: TRUEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transf

54、ormed into a database design?Classification: Concept37) Tables that are not normalized can have data integrity problems.Answer: TRUEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transforme

55、d into a database design?Classification: Concept38) Database practitioners classify tables into various normal forms according to the kinds of problems they have.Answer: TRUEAACSB: Information TechnologyDifficulty: 1: EasyCourse LO: Discuss best practices for using and managing databases.Learning Ob

56、j: LO 17.4: How is a data model transformed into a database design?Classification: Concept39) To represent an N:M relationship between two entities, two normalized tables are sufficient.Answer: FALSEAACSB: Information TechnologyDifficulty: 2: ModerateCourse LO: Discuss best practices for using and m

57、anaging databases.Learning Obj: LO 17.4: How is a data model transformed into a database design?Classification: Concept40) How is a data model transformed into a database design?Answer: Database design is the process of converting a data model into tables, relationships, and data constraints. The da

58、tabase design team transforms entities into tables and expresses relationships by defining foreign keys. The tables in a model must be normalized before they are converted into designs. Normalization is the process of converting poorly structured tables into two or more well-structured tables. Datab

59、ase 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 thos

60、e tables to complete the design.AACSB: Information TechnologyDifficulty: 2: ModerateCourse LO: Discuss best practices for using and managing databases.Learning Obj: LO 17.4: How is a data model transformed into a database design?Classification: Concept41) What are the steps involved in transforming