omis 452 ch 4 Questions with Correct Answers (Grade A+)

omis 452 ch 4 Questions with Correct Answers (Grade A+)

Question 1: An entity identifier can be either unique or nonunique.

Answer: TRUE


Question 2: 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.

Answer: FALSE


Question 3: In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity
indicates ____ _. a minimum cardinality of zero a minimum cardinality of one a maximum
cardinality of one a maximum cardinality of many Both a minimum cardinality of one and a
maximum cardinality of one

Answer: both a minimum cardinality of one and a maximum cardinality of one


Question 4: The number of entity classes involved in a relationship is the cardinality of the
relationship.

Answer: FALSE


Question 5: A use case can be used to perform which of the following tasks? Transform the data
model into the database design Validate the data model Fill the database with data Implement
business rules Develop applications

Answer: validate the data model


Question 6: 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 a strong entity an entity with a
maximum cardinality of one Both a special type of weak entity and an entity in which the identifier
of the entity includes the identifier of another entity

Answer: both a special type of weak entity and an entity in which the identifier of the entity includes the
identifier of another entity


Question 7: Recursive relationships can be represented as 1:N or N:M, but not 1:1.

Answer: FALSE


Question 8: A use case is a description of the way a user will employ the features and functions of the
new system.

Page 1

, Answer: TRUE


Question 9: It is possible for an entity to have a relationship to itself.

Answer: TRUE


Question 10: In crow's foot style E-R diagrams, a circle across the relationship line near an entity
indicates ____ _. a minimum cardinality of zero a minimum cardinality of one a maximum
cardinality of one a maximum cardinality of many Both a minimum cardinality of one and a
maximum cardinality of one

Answer: A minimum cardinality of zero


Question 11: The subtype symbol is a circle with a line under it.

Answer: TRUE


Question 12: Microsoft Access is only used to prototype databases where Microsoft Access itself will
be the final DBMS.

Answer: FALSE


Question 13: Which of the following would not be contained in a use case? A description of a task the
user wants to perform Outputs generated by the system in performing a given task An activity
scenario A prototype of the system performing a given task Inputs provided to the system to perform
a task

Answer: A prototype of the system performing a given task


Question 14: In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an
entity indicates ___ _. a minimum cardinality of zero a minimum cardinality of one a maximum
cardinality of one a maximum cardinality of many Both a minimum cardinality of one and a
maximum cardinality of one

Answer: a maximum cardinality of many


Question 15: A dashed line between entities indicates _. a minimum cardinality of zero a minimum
cardinality of one an identifying relationship a nonidentifying relationship a unique identifier

Answer: a non-identifying relationship


Question 16: Whether or not an instance of one entity class must participate in a relationship with
another entity class is indicated by the ________. maximum cardinality ordinality minimum

Page 2