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
