MISY 5335 EXAM
Which of the following activities is not performed during the implementation phase of
developing a database system? - answer Transforming the data model into a database
design
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) An activity scenario - answerC. A prototype of the system performing a given task
The representation of the content, relationships, and constraints of the data needed to
support the system requirements is the ________. - answerdata model
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 - answerB
A(n) ________ is a working demonstration of selected portions of the future system. -
answerprototype
________ are descriptions of the ways users will employ the features and functions of
the new information system. - answerUse cases
The ________ is a representation of the content, relationships, and constraints of the
data needed to support the system requirements. - answerdata model
Which of the following is not a source for user requirements during the requirements
analysis stage of developing a database system?
A) Referential integrity constraints
B) User interviews
C) Forms
D) Use cases
E) Business rules - answerA
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 - answerC
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. -
answerC
Identifiers of an entity that are composed of two or more attributes are called ________
identifiers. - answercomposite
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 - answerD
Relationships with the degree two are often called ________ relationships. -
answerbinary
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 - answerC
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 - answerD
Whether or not an instance of one entity class must participate in a relationship with
another entity class is indicated by the ________.
A) degree
Which of the following activities is not performed during the implementation phase of
developing a database system? - answer Transforming the data model into a database
design
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) An activity scenario - answerC. A prototype of the system performing a given task
The representation of the content, relationships, and constraints of the data needed to
support the system requirements is the ________. - answerdata model
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 - answerB
A(n) ________ is a working demonstration of selected portions of the future system. -
answerprototype
________ are descriptions of the ways users will employ the features and functions of
the new information system. - answerUse cases
The ________ is a representation of the content, relationships, and constraints of the
data needed to support the system requirements. - answerdata model
Which of the following is not a source for user requirements during the requirements
analysis stage of developing a database system?
A) Referential integrity constraints
B) User interviews
C) Forms
D) Use cases
E) Business rules - answerA
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 - answerC
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. -
answerC
Identifiers of an entity that are composed of two or more attributes are called ________
identifiers. - answercomposite
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 - answerD
Relationships with the degree two are often called ________ relationships. -
answerbinary
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 - answerC
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 - answerD
Whether or not an instance of one entity class must participate in a relationship with
another entity class is indicated by the ________.
A) degree
