Chapter 4
A dashed line between entities indicates: A) a minimum cardinality of one. B) a nonidentifying relationship. C) a minimum cardinality of zero. D) a unique identifier. E) an identifying relationship.
B
Microsoft Access is a good tool for creating mock-ups of forms and reports because: A) Access forms and reports are very simplistic. B) Access wizards make it easy to create the forms and reports. C) the form and report generators do not exist within Access itself. D) Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets. E) Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows.
B
The number of entity classes involved in a relationship is known as the relationship's: A) minimum cardinality. B) degree. C) maximum cardinality. D) ordinality. E) class.
B
In the Entity-Relationship data model, all instances of an entity of a given type are grouped into: A) entity objects. B) class objects. C) entity attributes. D) entity classes. E) identifiers.
D
The Microsoft Access 2013 form editor is a(n): A) wizard-based form editor. B) Web-based form editor. C) ASCII form editor. D) banded form editor. E) WYSIWYG form editor.
D
The representation of the content, relationships, and constraints of the data needed to support the system requirements is the: A) relation design. B) application program. C) data view. D) data model. E) implementation.
D
The ________ is a representation of the content, relationships, and constraints of the data needed to support the system requirements.
Data model
) In crow's foot style E-R diagrams, a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent: A) a strong entity relationship. B) a recursive entity relationship. C) a non-ID-dependent weak entity relationship. D) an ID-dependent weak entity relationship. E) a supertype / subtype relationship.
E
A use case can be used to perform which of the following tasks? A) Develop applications B) Transform the data model into the database design C) Implement business rules D) Fill the database with data E) Validate the data model
E
Given only the following excerpt of an E-R model: Entity A -->()-------------------||-- Entity B Which of the following is known to be true? A) ENTITY A has a minimum cardinality of one. B) A single instance of ENTITY A must be related to many instances of ENTITY B. C) The degree of the relationship is "many." D) There are more instances of ENTITY A than there are instances of ENTITY B in the user's environment. E) A single instance of ENTITY B may be related to many instances of ENTITY A.
E
In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity indicates: A) a maximum cardinality of many. B) a minimum cardinality of one. C) a maximum cardinality of one. D) a minimum cardinality of zero. E) Both B and C
E
Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system? A) User interviews B) Business rules C) Use cases D) Forms E) All of the above are sources for user requirements.
E
Given only the following excerpt of an E-R model: Entity A ------------------------------ Entity B If one instance of ENTITY B must be related to one and only one instance of ENTITY A, and one instance of ENTITY A may be related to many instances of ENTITY B, which of the following should be written on the end of the relationship line next to ENTITY B in the figure above? A) -----------------|--<-- Entity B B) -----------------()--|-- Entity B C) ---------------||----- Entity B D) --------------()<-- Entity B E) None of the above is correct.
A
During the design phase of developing a database system, the users are asked about the need for changes to existing forms and reports.
F
During the implementation phase of developing a database system, the data model is transformed into a database design.
F
In crow's foot E-R notation, the crow's foot indicates a maximum cardinality of one.
F
Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class.
F
Microsoft Access 2013 is only used to prototype databases where Microsoft Access itself will be the final DBMS.
F
The number of entity classes involved in a relationship is the cardinality of the relationship.
F
Unified Modeling Language (UML) has quickly replaced the E-R Model as the most popular technique for creating data models.
F
An entity that must logically depend on another entity is called a(n) ________ entity.
ID-dependent entity
________ can be used to build prototype databases.
Microsoft Access
An entity class is described by the structure of the entities in that class.
T
In crow's foot E-R notation, the hash mark indicates both a minimum cardinality of one and a maximum cardinality of one.
T
Microsoft Access 2013 can be used to build a prototype database, which allows users to validate the data model by demonstrating the consequences of data modeling decisions.
T
Microsoft Access 2013 uses banded form and report editors.
T
The E-R Model assumes that all instances of a given entity class have the same attributes.
T
Use cases can be used to validate the data model, design, and implementation.
T
________ are descriptions of the ways users will employ the features and functions of the new information system.
Use cases
Microsoft Access 2013 uses ________ form and report editors.
banded
Relationships with the degree 2 are often called ________ relationships.
binary
Microsoft Access 2013 database files can be easily ________ to create multiple copies of a database.
copied
Recursive relationships occur when an entity has a relationship with ________.
itself
