Home Work 10

A separately identifiable collection of things about which the organization wants to collect and store information is a _____.

class

Match the UML class diagram element to the corresponding entity-relationship diagram element.

class - entity Association - relationship multiplicities - cardinalities

A business rule is a statement of a _____ on a business process.

constraint

onsider the association between two classes: purchases and cash disbursements linked with one association. Match the description of the situation with the appropriate multiplicity. The first multiplicity is next to the purchases class and the second multiplicity is next to the cash disbursements class.

1..* and 0..1 - Each cash disbursement pays for a min of 1 and a max of many purchases 1..1 and 0..* - Each purchase can be paid for with many payments 1..1 and 0..1 - Each purchase is paid separately and in full with one cash disbursement 1..* and 0..* - Purchases may be paid for over time, and each payment can apply to many purchases

Specify the order of the steps in mapping a UML class diagram to a relational database schema by matching the step to the order number.

1.map classes to tables 2. map class attributes to table fields 3. map associations to foreign keys 4.create new tables for many-to-many relationships

Which of the following cardinality symbols (placed on the association between two classes/entities) is the equivalent of the multiplicity 0..* in information engineering notation?

A circle and three crow's feet

In this diagram, which of the following statements of multiplicities (the number of times instances of one class can be associated with instances of another class) are likely true?

A person may own many autos An auto is licensed in one state Autos may be serviced by many dealers

An _____ depicts the relationship between two classes in UML.

Blank 1: association

A _____ is an object which is implemented as a table in a relational database.

Blank 1: class

Best practices in preparation of UML diagrams include the use of common terminology in the organization for _____ names.

Blank 1: class

The Object Management Group is a consortium of _____ industry members.

Blank 1: computer

he Object Management Group is a consortium of _____ industry members.

Blank 1: computer

A business rule is a succinct statement of a _____ on a business process.

Blank 1: constraint, limit, or control

Structure models describe the ______ and _____ structure of a business process or processes.

Blank 1: information or informational Blank 2: data

An ERD is a graphical representation of the _____ data structure of a database.

Blank 1: logical

Multiplicities describe the ______ and _________ number of times that instances of one class can be associated with instances of another class.

Blank 1: minimum Blank 2: maximum

An entity is represented by the ______ symbol in an ERD.

Blank 1: rectangle

Best practices in preparation of UML diagrams suggests that classes should be linked only when there is a clear business purpose for that ________

Blank 1: relationship, association, or relationships

Classes in UML are implemented as tables in a relational database and individual instances of the class are implemented as ______ in the table.

Blank 1: rows or row

Best practices in preparation of UML diagrams suggests that the modeler should opt for _____ over complexity.

Blank 1: simplicity

A class is any separately identifiable collection of objects about which the organization wants to collect and _____ information.

Blank 1: store

Which of the following are examples of associations between classes in UML.

Employees "work for" supervisors Customers "participate" in sales Instructors "teach" classes

True or false: The specification for UML (unified modeling language) is maintained by the Object Management Guild.

False

ERD is short for entity-relationship diagram. Which of the following is true about ERDs?

Graphic representation of logical data structure Originally proposed by Peter Chen Similar to UML class diagrams

Which of the following things can be represented by classes on a UML class diagram?

People Assets

Using the diagram, select the answers that are true about the cardinalities described in information engineering notation.

Songs have one singer Singers sing many songs

Which of the following are true about the purpose of structure models?

Tools for planning Tools for documenting Tools for implementing databases

Match the UML class diagram multiplicity options with the corresponding ERD cardinality options.

0..1 - (0,1) 0..* - (0,N) 1..1 - (1,1) 1..* - (1,N)

Match the described situation with the correct multiplicity.

0..1 or 0..* - participation is optional 1..1 or 1..* - participation is mandatory 0..* or 1..* - maximum is more than one 0..1 or 1..1 - maximum is one

The first step in mapping a ULM class diagram to a relational database schema is

map classes to tables.

Valid multiplicity options are shown in which of the following?

minimum zero and maximum many (0..asterisk) minimum zero and maximum one (0..1)

The symbol used to represent a class is the _____.

rectangle

Individual instances of objects are represented as _____ in a table.

rows

What is the minimum cardinality in an ERD if the relationship is optional?

zero

Match the symbol with the thing that the symbol represents in UML.

Classes - rectangles Associations - lines

A depiction of the relationship between two classes is a(n) _____.

association

The relationship between two classes is depicted by a(n)

association