CIS 317 Chapter 3 Quiz Review

The "superclass/subclass" terminology describes elements in An EER model Cardinality model A UML class diagram A business process model Multiplicity model

A UML class diagram

Which one of the following illustrates a situation that can be addressed well with a multivalued attribute? A car consisting of a chassis and four wheels A vehicle that can be either a car or a truck A driver that can have multiple nationalities listed in the same field A driver that can be associated with multiple instances of a nationality entity None of the above

A driver that can have multiple nationalities listed in the same field

A company uses a concept of Product Line to denote a group of Products that it wants to track together in reporting. Each Product can at any point in time be moved from one Product Line to another and each Product continues to exist even if the Product Line to which it belongs is deleted. What is this structure called? Specialization Composition Generalization Inheritance Aggregation

Aggregation

Assume you have two entities, Team and Coach, and a many-to-many relationship between them. Also, assume that a coach can work with a team multiple different times during their career. Which one(s) of the following structures can be used to model this situation. Many-to-many relationship with attributes An associative entity without a primary key An associative entity with a primary key b) and c) a), b), and c)

An associative entity with a primary key

Which one of the following illustrates best a derived attribute? An attribute that consists of multiple components An attribute that can have only a limited set of values An attribute that changes its value frequently An attribute the value of which can be determined based on values of other attributes An attribute that must always have a value

An attribute the value of which can be determined based on values of other attributes

Which one of the following elements is frequently not included in a domain model? Attributes Associations Concepts Behaviors Concepts and attributes

Behaviors

In the UML class diagram notation, which term refers to the number of instances in one class associated with the number of instances in another class? Cardinality Degree Multiplicity Product Aggregation

Cardinality

Which one of the following requires a focus on the number of entity instances? Multivalued attribute Derived attribute Primary key Cardinality Degree

Cardinality

The key concepts in conceptual data modeling (with EER) and domain modeling (with UML class diagram) are the same or at least very close to each other. Consider the following list of EER concepts: Entity Type, Cardinality, Relationship, Entity Instance . Which one of the following UML class diagram concept lists is the same? Association Class, Multiplicity, Association, Object Association, Multiplicity, Object, Class Class, Multiplicity, Association, Object Object, Association, Multiplicity, Class Class, Object, Association, Multiplicity

Class, Multiplicity, Association, Object

The purpose of domain modeling is to identify Database tables Primary keys of a database tables Concepts, their attributes, and relationships between concepts within a domain of interest Foreign keys of relations None of the above

Concepts, their attributes, and relationships between concepts within a domain of interest

Enhanced Entity-Relationship Modeling is a notation for Logical data modeling Conceptual data modeling Conceptual and logical data modeling Database specification Business process modeling

Conceptual data modeling

Which one of the following statements is not true: Conceptual data modeling and business process modeling are always independent from each other Business process modeling may guide conceptual data modeling Conceptual data modeling can be performed independently, without business process modeling Domain modeling and conceptual data modeling can be used for the same purpose Domain modeling focuses primarily on concepts, their attributes, and their relationships

Conceptual data modeling and business process modeling are always independent from each other

An ATHLETE entity has two subtypes: Club and Varsity. An athlete cannot belong to both subtypes but each athlete belongs to one or the other. What would this combination be called? Disjoint, partial specialization Disjoint, total specialization Overlap, total specialization Overlap, partial specialization None of the above

Disjoint, total specialization

Which one of the following is an instance of the STUDENT entity? A general description that applies to all students? A label of a single attribute that each student has Ms. Brownwood with a student ID 34523443 Data regarding the grade that Ms. Brownwood earned in a section of course CS 350. All students in Mr. Derby's section of CS 350.

Ms. Brownwood with a student ID 34523443

Identify the discovery method of the following that is never used for conceptual data modeling: Observation Interviews Archival documents Existing software None of the above

None of the above

UML Class Diagram notation can be used both for domain modeling and software design. What is the key fundamental difference between the two? One describes a real-world area of interest, the other a structure created by humans. One is at a higher level of abstraction than the other. One is limited to modeling organizational concepts whereas the other is used for modeling human beings. Domain modeling leaves systematically out the attribute names whereas software design includes them. There is no difference; they are both the same.

One describes a real-world area of interest, the other a structure created by humans.

A not-for-profit organization has always exactly one paid staff member for each volunteer team. Each team has at least one member but may have many. What type of a relationship this is? Zero-to-many Many-to-many One-to-one One-to-many One-to-zero

One-to-many

What structural mechanism do you use if you want to include in a conceptual data model information regarding the one instructor of each course section without having to repeat instructor attributes for each section? One-to-many relationship between Instructor and Course Section One-to-one relationship for Course Section Many-to-many relationship between Instructor and Course Section One-to-one relationship for Instructor None of the above

One-to-many relationship between Instructor and Course Section

Which one of the following statements is true? A process model provides useful information for an associated domain model A domain model provides useful information for an associated process model Process models and a domain model contribute together to an integrated understanding of a domain of activity All of the above are true None of the statements above are true

Process models and a domain model contribute together to an integrated understanding of a domain of activity

Which one of the following is not a type of association in a UML class diagram? Aggregation Regression Inheritance Composition General association

Regression

Assume we evaluate domesticated animals and observe that cats and dogs are both domesticated animals and that they both have attributes that the other one does not have. Which process we have followed? Specialization Multiplication Generalization Conceptualization None of the above

Specialization

What type of a relationship is one that connects two instances of the same entity type with each other? Unidimensional Binary Ternary Unary Multidimensional

Unary

Identify the notation for a multivalued attribute: Area of interest {Area of interest} [Area of interest] Areas of interest None of the above

{Area of interest}