ACCT 4240A-01 Chapter 3 Data Modeling(All answered)
Which of the following things can be represented by classes on a UML class diagram?
-Start events
-People
-Business rules
-Assets correct answers People
Assets
An ___ depicts the relationship between two classes in UML. correct answers Association
A class is any separately identifiable collection of objects about which the organization wants to
collect and __ information correct answers store
Which of the following are examples of associations between classes in UML?
-Customers "participate" in sales
-Instructors "teach" classes
-One student "is" Joe
-Employees "work for" supervisors correct answers Customers "participate" in sales
Instructors "teach" classes
Employees "work for" supervisors
Individual instances of objects are represented as __ in a table.
-models
-rows
-relationships
-fields correct answers Rows
Multiplicities describe the __ and __ number of times that instances of one class can be
associated with instances of another class. correct answers minimum, maximum
True or false: The specification for UML (unified modeling language) is maintained by the
Object Management Guild. correct answers False.
Group, not Guild
Match the described situation with the correct multiplicity.
0..1 or 0..*
1..1 or 1..*
0..*; or 1..*
0..1 or 1..1
-participation is optional
-maximum is one
-maximum is more than one
-participation is mandatory correct answers 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
Which of the following statements is true about a list of tables based on a UML class diagram
and associated attributes? (Check all that apply).
-Some classes don't need to have corresponding tables in the table list
-Every table should have a primary key identified
-The table name should be the same as the class name
-The list should contain at least as many tables as classes on the UML diagram correct answers
Every table should have a primary key identified
The table name should be the same as the class name
The list should contain at least as many tables as classes on the UML diagram
The relationship between two classes is depicted by a(n)
-association
-attribute
-class name
-class symbol correct answers Association
In this diagram, which of the following statements (the number of times instances of one class
can be associated with instances of another class) are likely true?
-Dealers service one auto
-Autos may be serviced by many dealers
-An auto is licensed in one state
-A person may own many autos correct answers Autos may be serviced by many dealers
An auto is licensed in one state
A person may own many autos
Valid multiplicity options are shown in which of the following?
-minimum zero and maximum zero (0..0)
-minimum many and maximum many (asterisk..asterisk)
-minimum zero and maximum many (0..asterisk)
-minimum zero and maximum one (0..1) correct answers minimum zero and maximum many
(0..asterisk)
minimum zero and maximum one (0..1)
Which of the following is true about primary keys?
-Should be controlled by the assigning organization
-Can change over time
-Uniquely identifies instances of a class
-Is the foreign key of another table
-Cannot be blank (null) correct answers Should be controlled by the assigning organization
Uniquely identifies instances of a class
Cannot be blank (null)
True or false: A list of tables associated with a UML class diagram would include attributes,
primary keys, and any foreign keys for each table. correct answers True
Which of the following things can be represented by classes on a UML class diagram?
-Start events
-People
-Business rules
-Assets correct answers People
Assets
An ___ depicts the relationship between two classes in UML. correct answers Association
A class is any separately identifiable collection of objects about which the organization wants to
collect and __ information correct answers store
Which of the following are examples of associations between classes in UML?
-Customers "participate" in sales
-Instructors "teach" classes
-One student "is" Joe
-Employees "work for" supervisors correct answers Customers "participate" in sales
Instructors "teach" classes
Employees "work for" supervisors
Individual instances of objects are represented as __ in a table.
-models
-rows
-relationships
-fields correct answers Rows
Multiplicities describe the __ and __ number of times that instances of one class can be
associated with instances of another class. correct answers minimum, maximum
True or false: The specification for UML (unified modeling language) is maintained by the
Object Management Guild. correct answers False.
Group, not Guild
Match the described situation with the correct multiplicity.
0..1 or 0..*
1..1 or 1..*
0..*; or 1..*
0..1 or 1..1
-participation is optional
-maximum is one
-maximum is more than one
-participation is mandatory correct answers 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
Which of the following statements is true about a list of tables based on a UML class diagram
and associated attributes? (Check all that apply).
-Some classes don't need to have corresponding tables in the table list
-Every table should have a primary key identified
-The table name should be the same as the class name
-The list should contain at least as many tables as classes on the UML diagram correct answers
Every table should have a primary key identified
The table name should be the same as the class name
The list should contain at least as many tables as classes on the UML diagram
The relationship between two classes is depicted by a(n)
-association
-attribute
-class name
-class symbol correct answers Association
In this diagram, which of the following statements (the number of times instances of one class
can be associated with instances of another class) are likely true?
-Dealers service one auto
-Autos may be serviced by many dealers
-An auto is licensed in one state
-A person may own many autos correct answers Autos may be serviced by many dealers
An auto is licensed in one state
A person may own many autos
Valid multiplicity options are shown in which of the following?
-minimum zero and maximum zero (0..0)
-minimum many and maximum many (asterisk..asterisk)
-minimum zero and maximum many (0..asterisk)
-minimum zero and maximum one (0..1) correct answers minimum zero and maximum many
(0..asterisk)
minimum zero and maximum one (0..1)
Which of the following is true about primary keys?
-Should be controlled by the assigning organization
-Can change over time
-Uniquely identifies instances of a class
-Is the foreign key of another table
-Cannot be blank (null) correct answers Should be controlled by the assigning organization
Uniquely identifies instances of a class
Cannot be blank (null)
True or false: A list of tables associated with a UML class diagram would include attributes,
primary keys, and any foreign keys for each table. correct answers True
