Chapter 4 Database

3) The Microsoft Access form editor is a(n)

Banded from editor

20) The representation of the content, relationships, and constraints of the data needed to support the system requirements is the

Data model

11) Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?

(Business rules, User interviews, Forms, Use cases) All the above are sources for user requirements.

19) Given only the following excerpt of an E-R model: graphic(Chapter 4:4-44to46.jpg) 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

-----------------|--<-- Entity B

23) Which of the following would not be contained in a use case?

A prototype of the system performing a given task.

18) Given only the following excerpt of an E-R model: graphic(Chapter 4:4-44to46.jpg) Which of the following is known to be true?

A single instance of entity B may be related to many instances of entity A

9) An ID-dependent entity is

A special type of weak entity, an entity in which the identifier of the entity includes the identifier of another entity.

13) Microsoft Access is a good tool for creating mock-ups of forms and reports because

Access wizards make it easy to create forms & reports.

27) There is usually only one instance of an entity in an entity class.

False

29) One type of strong entity is the ID-dependent entity.

False

37) Unified Modeling Language (UML) has quickly replaced the E-R Model as the most popular technique for creating data models.

False

38) A PRODUCT entity instance is the collection of all PRODUCT entity classes.

False

40) The number of entity classes involved in a relationship is the cardinality of the relationship.

False

42) Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class.

False

44) During the design phase of developing a database system, the users are asked about the need for changes to existing forms and reports.

False

45) In crow's foot E-R notation, the crow's foot indicates a maximum cardinality of one.

False

49) A nonidentifying relationship exists between an ID-dependent entity and its parent.

False

50) System requirements as documented by use cases, business rules, forms, reports, and queries are sufficient to design the database without using a formal data model.

False

53) Microsoft Access is only used to prototype databases where Microsoft Access itself will be the final DBMS.

False

56) During the implementation phase of developing a database system, the data model is transformed into a database design

False

22) Given only the following excerpt of an E-R model: graphic(Chapter 4:4-44to46.jpg) Which of the following is known to be true?

Many instances of ENTITY A may be related to one instance of ENTITY B.

5) A dashed line between entities indicates

Nonidentifying relationship

21) Which of the following is true about identifiers of entities?

The value of an identifier may identify a set entity instances

10) Which of the following activities is not performed during the implementation phase of developing a database system?

Transforming the data model into a data design

1) Which of the following is not a basic element of the E-R Model?

Use Cases

24) A use case can be used to perform which of the following tasks?

Validate the data model

2) Which of the following is not a stage in the development of a database system?

Validation

14) In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity indicates

a max & minimum cardinality of 1.

16) In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates

a maximum cardinality of many

15) In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates

a minimum cardinality of zero.

17) 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 supertype/subtype relationship

4) The Microsoft Access report editor is a(n)

banded report editor

7) The number of entity classes involved in a relationship is known as the relationship's

degree

6) In the Entity-Relationship data model, all instances of an entity of a given type are grouped into

entity classes

8) Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the

maximum cardinality

12) Microsoft Access can be used to build a prototype database, which allows users

to validate the data model by demonstrating the consequences of data modeling decisions.