Management Information Systems for the Information Age 9th Edition by Stephen Haag Maeve Cummings test bank

<< Life Span Development 15th Edition by John Santrock Test Bank Making Sense of the Social World Methods of Investigation 5th Edition by Daniel F. Chambliss Russell K. Schutt Test Bank >>
Product Code: 222
Availability: In Stock
Price: $24.99
Qty:     - OR -   Add to Wish List
Add to Compare

Management Information Systems for the Information Age 9th Edition by Stephen Haag Maeve Cummings test bank

Description

Module C
Designing Databases and Entity-Relationship Diagramming

Multiple Choice Questions

1. Relational databases are similar to spreadsheets in that:

A. you maintain information in two-dimensional files.

B. you maintain information in three-dimensional files.

C. you compress information in order to store them.

D. you create primary keys for each entity class.

2. Which of the following defines a database?

A. A software application that works primarily with numbers and is commonly used to execute calculations

B. A collection of information that is organized and accessed according to the logical structure of that information

C. A three-dimensional table of information

D. A concept in which you wish to store information and that you can identify with a unique key

3. What is the most popular type of database?

A. Relational database

B. Embedded database

C. Graph database

D. Parallel database

4. Which of the following characterizes a relational database?

A. A three-dimensional table or file of information

B. An object-oriented storage and data management system

C. A series of related worksheets populated with information

D. A logically related two-dimensional table or file of information

5. There are _____ primary steps in designing and building a database.

A. two

B. three

C. four

D. six

6. _____ are statements concerning the information you need to work with and the relationships within the information.

A. Entity classes

B. Business rules

C. Instances

D. Foreign keys

7. Why would you define business rules for a database?

A. To help define the correct structure of your database

B. To ensure smooth transfer of files containing information

C. To ensure that information is entered into the database correctly

D. To ensure that information is maintained properly

8. An organization wishes to store information about its employees in a database. The employees, in this case, constitute a(n) ____.

A. foreign key

B. primary key

C. entity class

D. data dictionary

9. What is the first step in designing and building a database?

A. Defining entity classes and primary keys

B. Defining relationships among entity classes

C. Defining information for each relation

D. Defining the maintenance cycle for future enhancements

10. Which of the following is true about an entity class?

A. It is a field or class of fields that uniquely identifies information about an entity.

B. It is an occurrence of an entity class.

C. It represents a group or class of information that sits separately from other information in the database.

D. It typically consists of people, places, or things that you wish to store information about in the database.

11. What is a primary key?

A. The password used to protect a database

B. A collection of information that you organize and access according to the logical structure of that information.

C. A field or group of fields that uniquely describes each record in a database

D. The authorization key that establishes the usage rights for the database

12. What is an instance?

A. It is a key that uniquely identifies a person, place, or thing.

B. It is a group of related information about an entity.

C. It is a record or row in a relation.

D. It is an occurrence of an entity class that can be identified by a primary key.

13. A supplier is an example of a(n) ____.

A. relational database

B. entity class

C. foreign key

D. Business rule

14. Which of the following would be a good primary key for the entity class of students?

A. Course ID

B. Student Course name

C. Student ID

D. Institute ID

15. Which of the following is a graphic method of representing entity classes and their relationships?

A. Database model

B. Flowchart

C. Pie chart

D. E-R diagram

16. An E-R diagram includes five basic symbols. Which one denotes an entity class?

A. Line

B. Rectangle

C. Circle

D. Crows foot

17. Which of the following denotes a relationship between entity classes in an E-R diagram?

A. Dotted line

B. Curved line

C. Arrow

D. Circle

18. Which symbol should you use in an E-R diagram to show the relationship between a student and the courses they are currently enrolled in?

A. Circle

B. Triangle

C. Dotted line

D. Arrow

19. An E-R diagram includes five basic symbols. Which of the following denotes a single relationship between entity classes?

A. A crows foot (shown as <) B. A "|" symbol C. A dotted line D. A circle 20. Which symbol would you use in an E-R diagram to show that a course is taught by only one teacher? A. Straight, vertical line ( | ) B. Crow's foot C. Solid arrow D. Circle 21. An E-R diagram includes five basic symbols. Which one denotes an optional relationship between entity classes? A. Dotted line B. Circle C. Triangle D. Straight, vertical symbol ( | ) 22. Which symbol would you use in an E-R diagram to show that a student may or may not enroll in a course? A. Circle B. Square C. Arrow D. Straight, vertical line ( | ) 23. Which of the following denotes a multiple relationship between entity classes in an E-R diagram? A. Double line B. Dotted line C. The symbol "|" D. Crow's foot 24. Which symbol would you use in an E-R diagram to show that a student can enroll in more than one course? A. Double-line circle B. Solid arrow C. Double straight line D. Crow's foot 25. _____ is the process of assuring that a relational database structure can be implemented as a series of two-dimensional relations or tables. A. Normalization B. Standardization C. Planning D. Cross-functional modeling 26. Which of the following is not one of the rules of normalization? A. Assure that the operating version of your relational database is consistent throughout the organization B. Eliminate repeating groups or many-to-many relationships C. Assure that each field in a relation depends only on the primary key for that relation D. Remove all derived fields from the relations 27. If you were looking at an E-R diagram, how would you be able to identify a many-to-many relationship between two entities? A. There would be multiple entities sharing the same name. B. There would be a crow's foot on each end of the relationship between the two entities. C. There would be a double-edged arrow pointing to the many side of the relationship. D. There would be a double line linking the two entities together. 28. An intersection relation is: A. a temporary relation that pulls information from other linked relations. B. a relation that holds aggregate or summary information. C. a relation you create to eliminate a many-to-many relationship. D. a relation that identifies and stores the primary key for all entity classes. 29. An intersection relation is also known as a(n) _____ relation. A. primary B. connection C. composite D. merged 30. A composite primary key is: A. a merged field containing the primary key and descriptive information. B. a key in the intersecting relation that contains the primary keys from the two intersecting relations. C. a field composed of information from multiple sources. D. a unique field that can be used throughout the organization to identify an entity. 31. An intersection relation consists of: A. summary information. B. primary keys for all entity classes in the relational database. C. primary key fields from the intersecting relations. D. definitions for the intersecting relations. 32. A foreign key is a: A. primary key of one relation that appears in another relation. B. primary key that contains a needed translation of the primary key from the same relation. C. field that reformats the primary key so that it can be used in another application. D. field that contains a primary key from an external database. 33. If a student's ID was also present in a relation that stored enrollment information, this field in the enrollment relation would be called a(n) _____ key. A. intersecting B. composite C. merged D. foreign 34. The primary key fields from the two original relations become foreign keys in the intersection relation. When combined, the two foreign keys make up the _____ for the intersection relation. A. merged key B. composite primary key C. combined key D. intersecting key 35. If you find a many-to-many relationship, which of the following is a guideline to be followed when creating an intersection relation? A. Create a new E-R diagram (showing no cardinality) with the original two relations in the middle and a new one (the intersection relation) in the end. B. Move the minimum cardinality appearing next to the left relation just to the left of the intersection relation. C. Move the minimum cardinality appearing next to the right relation just to the right of the intersection relation. D. The new minimum and maximum cardinalities for the two original relations will be one and one. 36. When defining information (fields) for a relation, you should ensure that: A. the information for this relation cannot be derived from other information. B. the information for this relation can be found in other relations. C. the information can be identified by the primary key and by other fields in the relation. D. the information can be identified by the foreign key in this relation. 37. A database management system is: A. a complete set of relations, their links, and the data stored in the database. B. an application that allows you to specify the logical structure for a database and access the information within it. C. a logical structure for the information within the database. D. a data dictionary for a specific relational database. 38. A data dictionary contains: A. an external listing of relations and the fields stored in each. B. the logical structure for the information in a database. C. the definitions associated with database management systems. D. a listing of business rules and the data these rules create. True / False Questions 39. A database is a collection of information that you organize and access according to the logical structure of that information. True False 40. A relational database uses a series of logically related two-dimensional tables or files to store information in the form of a database. True False 41. Once you've implemented your database, you can neither change nor add information. True False 42. When creating a database you don't need to know the physical location of the information you want to see or use. True False 43. A relational database is the most popular of all database types. True False 44. Before you begin the process of designing a database, it is important that you first understand the business rules. True False 45. Business rules help you define the correct structure of your database. True False 46. The first step in designing a relational database involves defining information for each relation. True False 47. An entity class is a table which stores similar information and can be identified with a common key. True False 48. A primary key is a field (or group of fields in some cases) that uniquely describes each record. True False 49. A Social security number is an example of a primary key because it is unique. True False 50. An instance uniquely describes records. True False 51. Defining relationships among entity classes is the second step in designing and building a relational database. True False 52. An entity-relationship (E-R) diagram is a graphic method of representing entity classes and their relationships. True False 53. An E-R diagram includes four basic symbols. True False 54. In an E-R diagram, a dotted line denotes an entity class. True False 55. In an E-R diagram, "|" denotes a single relationship. True False 56. In an E-R diagram, O is used to denote an entity class. True False 57. In an E-R diagram, a rectangle denotes a relationship. True False 58. In an E-R diagram, crow's foot denotes a multiple relationship. True False 59. Your implementation of technology should match the way your business works. True False 60. The numerical nature of the E-R relationship is referred to as "minimum and maximum cardinality." True False 61. To develop the numerical relationships or cardinality among entity classes, you must clearly understand the business environment and its business rules. True False 62. The first rule of normalization states that repeating groups can exist among the entity classes. True False 63. Normalization is a process of assuring that a relational database structure can be implemented as a series of three-dimensional relations. True False 64. An intersection relation is a relation you create to detect a many-to-many relationship. True False 65. A foreign key consists of the primary key fields from two intersecting relations. True False 66. Repeating groups should be eliminated during database design. True False 67. Defining entity classes and primary keys is the third step in designing and building a relational database. True False 68. A database management system helps you specify the logical organization for a database and use the information within it. True False 69. A data dictionary consists of the primary key fields from the two intersecting relations. True False Fill in the Blank Questions 70. A(n) _____ is a collection of information that you organize and access according to the logical structure of that information. ________________________________________ 71. A relational database uses a series of logically related _____ tables or files to store information in the form of a database. ________________________________________ 72. _____ are statements concerning the information you need to work with and the relationships within the information. ________________________________________ 73. A(n) _____ is a concept about which you wish to store information and that you can identify with a unique key. ________________________________________ 74. The first step in designing a _____ is to define the various entity classes and the primary keys that uniquely define each record or instance within each entity class. ________________________________________ 75. A library wishes to store information about its members in its database. Here, members belong to a(n) ____ class. ________________________________________ 76. A(n) _____ is a field (or group of fields in some cases) that uniquely describes each record. ________________________________________ 77. A(n) _____ is an occurrence of an entity class that can be uniquely described. ________________________________________ 78. A library provides its members with a unique member ID and uses that ID for identification. This unique ID used instead of a member's name is an example of ____. ________________________________________ 79. The goal of the first step in designing a relational database is to define and identify _____ and their primary keys for your database. ________________________________________ 80. The staff of a hospital, a supplier of optical fibers, raw materials for production are all examples of ____. ________________________________________ 81. A(n) _____ is a graphic method of representing entity classes and their relationships. ________________________________________ 82. An entity-relationship (E-R) diagram includes _____ basic symbols. ________________________________________ 83. Within an entity-relationship diagram, the _______ symbol represents an entity class. ________________________________________ 84. Within an entity-relationship diagram, _______ is used to represent multiple relationships. ________________________________________ 85. Within an entity-relationship diagram, a dotted line connecting entity classes represents a(n) ____. ________________________________________ 86. Within an entity-relationship diagram, a "|" represents a(n) ____. ________________________________________ 87. Within an entity-relationship diagram, O is used to denote a zero or ____. ________________________________________ 88. _____ is a set of tools that you use to process information. ________________________________________ 89. Once you determine that a relationship does exist, you must then determine the numerical nature of the relationship, what we refer to as " _____." ________________________________________ 90. _____ is a process of assuring that a relational database structure can be implemented as a series of two-dimensional relations. ________________________________________ 91. The complete normalization process is _____ and quite necessary for developing organization-wide databases. ________________________________________ 92. An intersection relation will have a _____ primary key that consists of the primary key fields from the two intersecting relations. ________________________________________ 93. A(n) _____ relation is a relation you create to eliminate a many-to-many relationship. ________________________________________ 94. Normalization involves assuring that each field within a relation depends only on the _____ for that relation. ________________________________________ 95. A(n) _____ is a primary key of one relation that appears in another relation. ________________________________________ 96. Normalization involves removing all repeating groups or _____ relationships. ________________________________________ 97. Removing _____ relationships is the most difficult aspect when designing the appropriate structure of a relational database. ________________________________________ 98. The business world is full of _____ relationships that must be eliminated before an organization can correctly implement a relational database. ________________________________________ 99. A(n) _____ helps you specify the logical organization for a database and access and use the information within the database. ________________________________________ 100. The _____ contains the logical structure for the information in a database. ________________________________________ Module C Designing Databases and Entity-Relationship Diagramming Answer Key Multiple Choice Questions 1. Relational databases are similar to spreadsheets in that: A. you maintain information in two-dimensional files. B. you maintain information in three-dimensional files. C. you compress information in order to store them. D. you create primary keys for each entity class. Relational databases are similar to spreadsheets in that you maintain information in two-dimensional files. In a spreadsheet, you place information in a cell (the intersection of a row and column). AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 2. Which of the following defines a database? A. A software application that works primarily with numbers and is commonly used to execute calculations B. A collection of information that is organized and accessed according to the logical structure of that information C. A three-dimensional table of information D. A concept in which you wish to store information and that you can identify with a unique key A database is a collection of information that you organize and access according to the logical structure of that information. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 3. What is the most popular type of database? A. Relational database B. Embedded database C. Graph database D. Parallel database Relational database is the most popular of all database types. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 4. Which of the following characterizes a relational database? A. A three-dimensional table or file of information B. An object-oriented storage and data management system C. A series of related worksheets populated with information D. A logically related two-dimensional table or file of information A relational database uses a series of logically related two-dimensional tables or files to store information in the form of a database. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 5. There are _____ primary steps in designing and building a database. A. two B. three C. four D. six Using a database amounts to more than just using various DBMS tools. The four primary steps in designing and building a database include: 1. Define entity classes and primary keys. 2. Define relationships among entity classes. 3. Define information (fields) for each relation (the term relation is often used to refer to a file while designing a database). 4. Use a data definition language to create your database. AACSB: Technology Blooms: Remember Learning Objective: C-02 List and describe the four steps in designing and building a relational database. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 6. _____ are statements concerning the information you need to work with and the relationships within the information. A. Entity classes B. Business rules C. Instances D. Foreign keys Business rules are statements concerning the information you need to work with and the relationships within the information. AACSB: Technology Blooms: Remember Learning Objective: C-02 List and describe the four steps in designing and building a relational database. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 7. Why would you define business rules for a database? A. To help define the correct structure of your database B. To ensure smooth transfer of files containing information C. To ensure that information is entered into the database correctly D. To ensure that information is maintained properly Business rules are statements concerning the information you need to work with and the relationships within the information. These business rules will help you define the correct structure of your database. AACSB: Technology Blooms: Remember Learning Objective: C-02 List and describe the four steps in designing and building a relational database. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 8. An organization wishes to store information about its employees in a database. The employees, in this case, constitute a(n) ____. A. foreign key B. primary key C. entity class D. data dictionary An entity class is a concepttypically people, places, or thingsabout which you wish to store information and that you can identify with a unique key (called a primary key). AACSB: Reflective Thinking Blooms: Apply Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 9. What is the first step in designing and building a database? A. Defining entity classes and primary keys B. Defining relationships among entity classes C. Defining information for each relation D. Defining the maintenance cycle for future enhancements The first step in designing and building a database involves defining entity classes and primary keys. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 10. Which of the following is true about an entity class? A. It is a field or class of fields that uniquely identifies information about an entity. B. It is an occurrence of an entity class. C. It represents a group or class of information that sits separately from other information in the database. D. It typically consists of people, places, or things that you wish to store information about in the database. An entity class is a concepttypically people, places, or thingsabout which you wish to store information and that you can identify with a unique key (called a primary key). AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 11. What is a primary key? A. The password used to protect a database B. A collection of information that you organize and access according to the logical structure of that information. C. A field or group of fields that uniquely describes each record in a database D. The authorization key that establishes the usage rights for the database A primary key is a field (or group of fields in some cases) that uniquely describes each record. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 12. What is an instance? A. It is a key that uniquely identifies a person, place, or thing. B. It is a group of related information about an entity. C. It is a record or row in a relation. D. It is an occurrence of an entity class that can be identified by a primary key. An instance is an occurrence of an entity class that can be uniquely described with a primary key. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 13. A supplier is an example of a(n) ____. A. relational database B. entity class C. foreign key D. Business rule An entity class is something like a student, a supplier, a book, and so on. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 14. Which of the following would be a good primary key for the entity class of students? A. Course ID B. Student Course name C. Student ID D. Institute ID The primary key for each entity class uniquely defines each record or instance within the entity class. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 15. Which of the following is a graphic method of representing entity classes and their relationships? A. Database model B. Flowchart C. Pie chart D. E-R diagram An entity-relationship (E-R) diagram is a graphic method of representing entity classes and their relationships. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 16. An E-R diagram includes five basic symbols. Which one denotes an entity class? A. Line B. Rectangle C. Circle D. Crow's foot An E-R diagram includes five basic symbols: a rectangle denotes an entity class. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 17. Which of the following denotes a relationship between entity classes in an E-R diagram? A. Dotted line B. Curved line C. Arrow D. Circle A dotted line connecting entity classes denotes a relationship in an E-R diagram. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 18. Which symbol should you use in an E-R diagram to show the relationship between a student and the courses they are currently enrolled in? A. Circle B. Triangle C. Dotted line D. Arrow A dotted line connecting entity classes denotes a relationship in an E-R diagram. AACSB: Reflective Thinking AACSB: Technology Blooms: Apply Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 3 Hard Topic: Designing and Building a Relational Database 19. An E-R diagram includes five basic symbols. Which of the following denotes a single relationship between entity classes? A. A crow's foot (shown as <) B. A "|" symbol C. A dotted line D. A circle The symbol "|" denotes a single relationship in an E-R diagram. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 20. Which symbol would you use in an E-R diagram to show that a course is taught by only one teacher? A. Straight, vertical line ( | ) B. Crow's foot C. Solid arrow D. Circle A | to denote a single relationship in an E-R diagram. AACSB: Reflective Thinking AACSB: Technology Blooms: Apply Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 3 Hard Topic: Designing and Building a Relational Database 21. An E-R diagram includes five basic symbols. Which one denotes an optional relationship between entity classes? A. Dotted line B. Circle C. Triangle D. Straight, vertical symbol ( | ) In an E-R diagram, an "O" is used to denote a zero or optional relationship. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 22. Which symbol would you use in an E-R diagram to show that a student may or may not enroll in a course? A. Circle B. Square C. Arrow D. Straight, vertical line ( | ) In an E-R diagram, an "O" is used to denote a zero or optional relationship. AACSB: Reflective Thinking AACSB: Technology Blooms: Apply Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 3 Hard Topic: Designing and Building a Relational Database 23. Which of the following denotes a multiple relationship between entity classes in an E-R diagram? A. Double line B. Dotted line C. The symbol "|" D. Crow's foot A crow's foot (shown as <) is used to denote a multiple relationship in an E-R diagram. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 24. Which symbol would you use in an E-R diagram to show that a student can enroll in more than one course? A. Double-line circle B. Solid arrow C. Double straight line D. Crow's foot A crow's foot (shown as <) is used to denote a multiple relationship in an E-R diagram. AACSB: Reflective Thinking AACSB: Technology Blooms: Apply Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 3 Hard Topic: Designing and Building a Relational Database 25. _____ is the process of assuring that a relational database structure can be implemented as a series of two-dimensional relations or tables. A. Normalization B. Standardization C. Planning D. Cross-functional modeling Normalization is a process of assuring that a relational database structure can be implemented as a series of two-dimensional relations. AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 26. Which of the following is not one of the rules of normalization? A. Assure that the operating version of your relational database is consistent throughout the organization B. Eliminate repeating groups or many-to-many relationships C. Assure that each field in a relation depends only on the primary key for that relation D. Remove all derived fields from the relations The three rules of normalization: 1. Eliminate repeating groups or many-to-many relationships. 2. Assure that each field in a relation depends only on the primary key for that relation. 3. Remove all derived fields from the relations. AACSB: Technology Blooms: Understand Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 2 Medium Topic: Designing and Building a Relational Database 27. If you were looking at an E-R diagram, how would you be able to identify a many-to-many relationship between two entities? A. There would be multiple entities sharing the same name. B. There would be a crow's foot on each end of the relationship between the two entities. C. There would be a double-edged arrow pointing to the many side of the relationship. D. There would be a double line linking the two entities together. The first rule of normalization states that no repeating groups or many-to-many relationships can exist among the entity classes. You can find these many-to-many relationships by simply looking at your E-R diagram and note any relationships that have a crow's foot on each end. AACSB: Technology Blooms: Understand Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 2 Medium Topic: Designing and Building a Relational Database 28. An intersection relation is: A. a temporary relation that pulls information from other linked relations. B. a relation that holds aggregate or summary information. C. a relation you create to eliminate a many-to-many relationship. D. a relation that identifies and stores the primary key for all entity classes. An intersection relation is a relation you create to eliminate a many-to-many relationship. AACSB: Technology Blooms: Understand Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 2 Medium Topic: Designing and Building a Relational Database 29. An intersection relation is also known as a(n) _____ relation. A. primary B. connection C. composite D. merged An intersection relation is sometimes called a composite relation. AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 30. A composite primary key is: A. a merged field containing the primary key and descriptive information. B. a key in the intersecting relation that contains the primary keys from the two intersecting relations. C. a field composed of information from multiple sources. D. a unique field that can be used throughout the organization to identify an entity. A composite primary key is a key that consists of the primary key fields from the two intersecting relations. AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 31. An intersection relation consists of: A. summary information. B. primary keys for all entity classes in the relational database. C. primary key fields from the intersecting relations. D. definitions for the intersecting relations. An intersection relation will have a composite primary key that consists of the primary key fields from the two intersecting relations. AACSB: Technology Blooms: Understand Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 2 Medium Topic: Designing and Building a Relational Database 32. A foreign key is a: A. primary key of one relation that appears in another relation. B. primary key that contains a needed translation of the primary key from the same relation. C. field that reformats the primary key so that it can be used in another application. D. field that contains a primary key from an external database. A foreign key is a primary key of one file (relation) that appears in another file (relation). AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 33. If a student's ID was also present in a relation that stored enrollment information, this field in the enrollment relation would be called a(n) _____ key. A. intersecting B. composite C. merged D. foreign A foreign key is a primary key of one file (relation) that appears in another file (relation). AACSB: Reflective Thinking AACSB: Technology Blooms: Apply Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 3 Hard Topic: Designing and Building a Relational Database 34. The primary key fields from the two original relations become foreign keys in the intersection relation. When combined, the two foreign keys make up the _____ for the intersection relation. A. merged key B. composite primary key C. combined key D. intersecting key When combined, the two foreign keys make up the composite primary key for the intersection relation. AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 35. If you find a many-to-many relationship, which of the following is a guideline to be followed when creating an intersection relation? A. Create a new E-R diagram (showing no cardinality) with the original two relations in the middle and a new one (the intersection relation) in the end. B. Move the minimum cardinality appearing next to the left relation just to the left of the intersection relation. C. Move the minimum cardinality appearing next to the right relation just to the right of the intersection relation. D. The new minimum and maximum cardinalities for the two original relations will be one and one. As a general rule, the new minimum and maximum cardinalities for the two original relations will be one and one. AACSB: Technology Blooms: Understand Learning Objective: C-06 Describe the process of creating an intersection relation to remove a many-to-many relationship. Level of Difficulty: 2 Medium Topic: Designing and Building a Relational Database 36. When defining information (fields) for a relation, you should ensure that: A. the information for this relation cannot be derived from other information. B. the information for this relation can be found in other relations. C. the information can be identified by the primary key and by other fields in the relation. D. the information can be identified by the foreign key in this relation. Your goal when defining information (fields) for a relation is to make sure that the information in each relation is indeed in the correct relation and that the information cannot be derived from other informationthe second and third rules of normalization. AACSB: Technology Blooms: Understand Learning Objective: C-06 Describe the process of creating an intersection relation to remove a many-to-many relationship. Level of Difficulty: 2 Medium Topic: Designing and Building a Relational Database 37. A database management system is: A. a complete set of relations, their links, and the data stored in the database. B. an application that allows you to specify the logical structure for a database and access the information within it. C. a logical structure for the information within the database. D. a data dictionary for a specific relational database. A database management system (DBMS) helps you specify the logical organization for a database and access and use the information within the database. AACSB: Technology Blooms: Remember Learning Objective: C-06 Describe the process of creating an intersection relation to remove a many-to-many relationship. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 38. A data dictionary contains: A. an external listing of relations and the fields stored in each. B. the logical structure for the information in a database. C. the definitions associated with database management systems. D. a listing of business rules and the data these rules create. The data dictionary contains the logical structure for the information in a database. AACSB: Technology Blooms: Remember Learning Objective: C-06 Describe the process of creating an intersection relation to remove a many-to-many relationship. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database True / False Questions 39. A database is a collection of information that you organize and access according to the logical structure of that information. TRUE A database is a collection of information that you organize and access according to the logical structure of that information. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 40. A relational database uses a series of logically related two-dimensional tables or files to store information in the form of a database. TRUE A relational database uses a series of logically related two-dimensional tables or files to store information in the form of a database. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 41. Once you've implemented your database, you can neither change nor add information. FALSE Once you've implemented your database, you can then change the information as you wish, add rows of information (and delete others), add new tables, and use simple but powerful reporting and querying tools to extract the exact information you need. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 42. When creating a database you don't need to know the physical location of the information you want to see or use. TRUE Databases are similar and different. You still create rows and columns of information. However, you don't need to know the physical location of the information you want to see or use. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 43. A relational database is the most popular of all database types. TRUE A relational database is the most popular of all database types. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 44. Before you begin the process of designing a database, it is important that you first understand the business rules. TRUE When you begin to think about designing a database application, you first need to capture and understand the business rules. AACSB: Technology Blooms: Remember Learning Objective: C-02 List and describe the four steps in designing and building a relational database. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 45. Business rules help you define the correct structure of your database. TRUE Business rules are statements concerning the information you need to work with and the relationships within the information. These business rules will help you define the correct structure of your database. AACSB: Technology Blooms: Remember Learning Objective: C-02 List and describe the four steps in designing and building a relational database. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 46. The first step in designing a relational database involves defining information for each relation. FALSE The first step in designing a relational database is to define the various entity classes and the primary keys that uniquely define each record or instance within each entity class. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 47. An entity class is a table which stores similar information and can be identified with a common key. FALSE An entity class is a concepttypically people, places, or thingsabout which you wish to store information and that you can identify with a unique key (called a primary key). AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 48. A primary key is a field (or group of fields in some cases) that uniquely describes each record. TRUE A primary key is a field (or group of fields in some cases) that uniquely describes each record. Within the context of database design, we often refer to a record as an instance. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 49. A Social security number is an example of a primary key because it is unique. TRUE A primary key is a field (or group of fields in some cases) that uniquely describes each record. Within the context of database design, we often refer to a record as an instance. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 50. An instance uniquely describes records. FALSE An instance is an occurrence of an entity class that can be uniquely described with a primary key. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 51. Defining relationships among entity classes is the second step in designing and building a relational database. TRUE The second step in designing a relational database is to define the relationships among the entity classes. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 52. An entity-relationship (E-R) diagram is a graphic method of representing entity classes and their relationships. TRUE An entity-relationship (E-R) diagram is a graphic method of representing entity classes and their relationships. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 53. An E-R diagram includes four basic symbols. FALSE An E-R diagram includes five basic symbols. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 54. In an E-R diagram, a dotted line denotes an entity class. FALSE In an E-R diagram, a dotted line connecting entity classes denotes a relationship. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 55. In an E-R diagram, "|" denotes a single relationship. TRUE In an E-R diagram, "|" denotes a single relationship. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 56. In an E-R diagram, O is used to denote an entity class. FALSE In an E-R diagram, O denotes a zero or optional relationship. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 57. In an E-R diagram, a rectangle denotes a relationship. FALSE In an E-R diagram, rectangle denotes an entity class. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 58. In an E-R diagram, crow's foot denotes a multiple relationship. TRUE In an E-R diagram, crow's foot denotes a multiple relationship. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 59. Your implementation of technology should match the way your business works. TRUE Technology (databases, in this instance) is a set of tools that you use to process information. So, your implementations of technology should match the way your business works. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 60. The numerical nature of the E-R relationship is referred to as "minimum and maximum cardinality." TRUE Once you determine that a relationship does exist, you must then determine the numerical nature of the relationship, what we refer to as "minimum and maximum cardinality." AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 61. To develop the numerical relationships or cardinality among entity classes, you must clearly understand the business environment and its business rules. TRUE To properly develop the numerical relationships (cardinality) among entity classes, you must clearly understand the business situation at hand. That's why it's so important to write down all the business rules. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 62. The first rule of normalization states that repeating groups can exist among the entity classes. FALSE The first rule of normalization states that no repeating groups or many-to-many relationships can exist among the entity classes. AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 63. Normalization is a process of assuring that a relational database structure can be implemented as a series of three-dimensional relations. FALSE Normalization is a process of assuring that a relational database structure can be implemented as a series of two-dimensional relations. AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 64. An intersection relation is a relation you create to detect a many-to-many relationship. FALSE An intersection relation is a relation you create to eliminate a many-to-many relationship. AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 65. A foreign key consists of the primary key fields from two intersecting relations. FALSE A foreign key is a primary key of one file (relation) that appears in another file (relation). AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 66. Repeating groups should be eliminated during database design. TRUE According to the rules of normalization, repeating groups or many-to-many relationships should be eliminated. AACSB: Technology Blooms: Remember Learning Objective: C-05 List and describe the steps in normalization. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 67. Defining entity classes and primary keys is the third step in designing and building a relational database. FALSE The third step of designing and building a relational database involves defining information for each relation. AACSB: Technology Blooms: Remember Learning Objective: C-06 Describe the process of creating an intersection relation to remove a many-to-many relationship. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 68. A database management system helps you specify the logical organization for a database and use the information within it. TRUE A database management system (DBMS) helps you specify the logical organization for a database and access and use the information within the database. AACSB: Technology Blooms: Remember Learning Objective: C-06 Describe the process of creating an intersection relation to remove a many-to-many relationship. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 69. A data dictionary consists of the primary key fields from the two intersecting relations. FALSE A data dictionary contains the logical structure for the information in a database. AACSB: Technology Blooms: Remember Learning Objective: C-06 Describe the process of creating an intersection relation to remove a many-to-many relationship. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database Fill in the Blank Questions 70. A(n) _____ is a collection of information that you organize and access according to the logical structure of that information. database A database is a collection of information that you organize and access according to the logical structure of that information. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 71. A relational database uses a series of logically related _____ tables or files to store information in the form of a database. two-dimensional A relational database uses a series of logically related two-dimensional tables or files to store information in the form of a database. AACSB: Technology Blooms: Remember Learning Objective: C-01 Identify how databases and spreadsheets are both similar and different. Level of Difficulty: 1 Easy Topic: Introduction 72. _____ are statements concerning the information you need to work with and the relationships within the information. Business rules Business rules are statements concerning the information you need to work with and the relationships within the information. AACSB: Technology Blooms: Remember Learning Objective: C-02 List and describe the four steps in designing and building a relational database. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 73. A(n) _____ is a concept about which you wish to store information and that you can identify with a unique key. entity class An entity class is a concepttypically people, places, or thingsabout which you wish to store information and that you can identify with a unique key (called a primary key). AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 74. The first step in designing a _____ is to define the various entity classes and the primary keys that uniquely define each record or instance within each entity class. relational database The first step in designing a relational database is to define the various entity classes and the primary keys that uniquely define each record or instance within each entity class. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 75. A library wishes to store information about its members in its database. Here, members belong to a(n) ____ class. entity An entity class is a concepttypically people, places, or thingsabout which you wish to store information and that you can identify with a unique key (called a primary key). AACSB: Reflective Thinking Blooms: Apply Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 3 Hard Topic: Designing and Building a Relational Database 76. A(n) _____ is a field (or group of fields in some cases) that uniquely describes each record. primary key A primary key is a field (or group of fields in some cases) that uniquely describes each record. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 77. A(n) _____ is an occurrence of an entity class that can be uniquely described. instance An instance is an occurrence of an entity class that can be uniquely described with a primary key. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 78. A library provides its members with a unique member ID and uses that ID for identification. This unique ID used instead of a member's name is an example of ____. primary key A primary key is a field (or group of fields in some cases) that uniquely describes each record. AACSB: Reflective Thinking Blooms: Apply Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 3 Hard Topic: Designing and Building a Relational Database 79. The goal of the first step in designing a relational database is to define and identify _____ and their primary keys for your database. entity classes The goal of the first step in designing a relational database is to define and identify entity classes and their primary keys for your database. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 80. The staff of a hospital, a supplier of optical fibers, raw materials for production are all examples of ____. entity class An entity class is something like a student, a supplier, a book, and so on. AACSB: Technology Blooms: Remember Learning Objective: C-03 Define the concepts of entity class; instance; primary key; and foreign key. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 81. A(n) _____ is a graphic method of representing entity classes and their relationships. entity-relationship diagram An entity-relationship (E-R) diagram is a graphic method of representing entity classes and their relationships. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 82. An entity-relationship (E-R) diagram includes _____ basic symbols. five An entity-relationship (E-R) diagram includes five basic symbols. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 83. Within an entity-relationship diagram, the _______ symbol represents an entity class. rectangle An E-R diagram includes five basic symbols. A rectangle is used to denote an entity class. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 84. Within an entity-relationship diagram, _______ is used to represent multiple relationships. crow's foot An E-R diagram includes five basic symbols. A crow's foot is used to denote multiple relationships. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 85. Within an entity-relationship diagram, a dotted line connecting entity classes represents a(n) ____. relationship An E-R diagram includes five basic symbols. A dotted line connecting entity classes is used to denote relationships. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 86. Within an entity-relationship diagram, a "|" represents a(n) ____. single relationship An E-R diagram includes five basic symbols. A "|" is used to denote single relationship. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 87. Within an entity-relationship diagram, O is used to denote a zero or ____. optional relationship Within an entity-relationship diagram, O is used to denote a zero or optional relationship. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 88. _____ is a set of tools that you use to process information. Technology Technology is a set of tools that you use to process information. AACSB: Technology Blooms: Remember Learning Objective: C-04 Given a small operating environment; build an entity-relationship (E-R) diagram. Level of Difficulty: 1 Easy Topic: Designing and Building a Relational Database 89. Once you determine that a relationship does exist, you must then determine the numerical nature of the relationship, what we refer to as " _____." minimum and maximum cardinality Once you determine that a relationship does exist, you must then determine the numerical nature of the relationship, what we refer to as "minimum and maximum cardinality." AACSB: Technology

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad           Good

Enter the code in the box below:



 

Once the order is placed, the order will be delivered to your email less than 24 hours, mostly within 4 hours. 

If you have questions, you can contact us here