DB Chapter 4 MULTIPLE

Given only the excerpt of an E-R model shown above, which of the following is known to be true? [ENTITY A]--------<N:1>--------[ENTITY B] A) There are more instances of ENTITY A than there are instances of ENTITY B in the user's environment. B) A single instance of ENTITY B may be related to many instances of ENTITY A. C) A single instance of ENTITY A must be related to many instances of ENTITY B. D) ENTITY A has a minimum cardinality of zero. E) The degree of the relationship is "many."

B) A single instance of ENTITY B may be related to many instances of ENTITY A.

Given only the excerpt of an E-R model shown above, which of the following is known to be true? [ENTITY A]--------<N:1>--------[ENTITY B] A) A single instance of ENTITY A must be related to one instance of ENTITY B. B) Many instances of ENTITY A may be related to one instance of ENTITY B. C) ENTITY B has a degree of many. D) ENTITY B is a weak entity. E) Both A and C are true.

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

Which of the following activities is not performed during the implementation phase of developing a database system? A) Filling the database with data B) Transforming the data model into a database design C) Writing application programs D) Creating forms E) Creating reports

B) Transforming the data model into a database design

A use case can be used to perform which of the following tasks? A) Transform the data model into the database design B) Validate the data model C) Fill the database with data D) Implement business rules E) Develop applications

B) Validate the data model

Which of the following is not a stage in the development of a database system? A) Requirements analysis B) Validation C) Component design D) Implementation E) All of the above are stages in the development of a database system.

B) Validation

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 in the relationship symbol of the figure above? [ENTITY A]--------< >--------[ENTITY B] A) 0:1 B) 1:1 C) 1:N D) N:1 E) N:M

C) 1:N

Which of the following would not be contained in a use case? A) Inputs provided to the system to perform a task B) A description of a task the user wants to perform C) A prototype of the system performing a given task D) Outputs generated by the system in performing a given task E) All of the above would be contained in a use case.

C) A prototype of the system performing a given task

Microsoft Access is a good tool for creating mock-ups of forms and reports because: A) the form and report generators do not exist within Access itself. B) Access forms and reports are very simplistic. C) Access wizards make it easy to create the forms and reports. D) Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows. E) Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets.

C) Access wizards make it easy to create the forms and reports.

Which of the following is true about identifiers of entities? A) Identifiers must be unique. B) Identifiers are not normally used in a naming role. C) The value of an identifier may identify a set of entity instances. D) Identifiers may not be more than two attributes. E) An identifier in the E-R model is equivalent to a key in the relational model.

C) The value of an identifier may identify a set of entity instances.

The representation of the content, relationships, and constraints of the data needed to support the system requirements is the: A) relation design. B) implementation. C) data model. D) data view. E) application program.

C) data model.

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 classes. D) identifiers. E) entity attributes.

C) entity classes.

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the: A) degree. B) recursive cardinality. C) minimum cardinality. D) maximum cardinality. E) ordinality.

C) minimum cardinality.

Microsoft Access can be used to build a prototype database, which allows users: A) to draw a crow's foot E-R diagram themselves. B) to normalize the tables in the E-R diagram. C) to validate the data model by demonstrating the consequences of data modeling decisions. D) to determine the functional dependencies in the data model. E) to determine the appropriate primary and foreign keys in the data model.

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

Which of the following is not a basic element of the E-R Model? A) Identifiers B) Entities C) Cardinalities D) Use cases E) Relationships

D) Use cases

In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates: A) a minimum cardinality of zero. B) a minimum cardinality of one. C) a maximum cardinality of one. D) a maximum cardinality of many. E) Both B and C

D) a maximum cardinality of many.

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) an ID-dependent weak entity relationship. C) a non-ID-dependent weak entity relationship. D) a supertype / subtype relationship. E) a recursive entity relationship.

D) a supertype / subtype relationship.

The number of entity classes involved in a relationship is known as the relationship's: A) maximum cardinality. B) minimum cardinality. C) ordinality. D) degree. E) class.

D) degree.

In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates: A) a minimum cardinality of zero. B) a minimum cardinality of one. C) a maximum cardinality of one. D) a maximum cardinality of many. E) Both B and C

A) a minimum cardinality of zero.

The Microsoft Access form editor is a(n): A) banded form editor. B) wizard-based form editor. C) ASCII form editor. D) WYSIWYG form editor. E) Web-based form editor.

A) banded form editor.

The Microsoft Access report editor is a(n): A) banded report editor. B) wizard-based report editor. C) ASCII report editor. D) WYSIWYG report editor. E) Web-based report editor.

A) banded report editor.

Microsoft Access can be used to prototype databases for which of the following DBMS products? A) Microsoft Access B) SQL Server C) MySQL D) Oracle Database E) All of the above

E) All of the above

Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system? A) Business rules B) User interviews C) Forms D) Use cases E) All of the above are sources for user requirements.

E) All of the above are sources for user requirements.

An ID-dependent entity is: A) a special type of weak entity. B) an entity in which the identifier of the entity includes the identifier of another entity. C) a strong entity. D) an entity with a maximum cardinality of one. E) Both A and B

E) Both A and B

In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity indicates: A) a minimum cardinality of zero. B) a minimum cardinality of one. C) a maximum cardinality of one. D) a maximum cardinality of many. E) Both B and C

E) Both B and C

A dashed line between entities indicates: A) a unique identifier. B) a minimum cardinality of zero. C) a minimum cardinality of one. D) an identifying relationship. E) a nonidentifying relationship.

E) a nonidentifying relationship.