Podcast
Questions and Answers
Which of the following are true about the purpose of structure models? (Select all that apply)
Which of the following are true about the purpose of structure models? (Select all that apply)
- Tools for planning (correct)
- Tools for documenting (correct)
- Tools for implementing databases (correct)
- None of the above
A model of logical database structures must be able to describe all of the following except?
A model of logical database structures must be able to describe all of the following except?
- Relationships
- Entities
- Keys (correct)
- Attributes
The specification for UML (Unified Modeling Language) is maintained by the Object Management Guild.
The specification for UML (Unified Modeling Language) is maintained by the Object Management Guild.
False (B)
Class diagrams are one type of UML diagram.
Class diagrams are one type of UML diagram.
A __________ is an object which is implemented as a table in a relational database.
A __________ is an object which is implemented as a table in a relational database.
Structure models describe the __________ and __________ structure of a business process or processes.
Structure models describe the __________ and __________ structure of a business process or processes.
A separately identifiable collection of things about which the organization wants to collect and store information is a _____.
A separately identifiable collection of things about which the organization wants to collect and store information is a _____.
Structure models should be able to describe all except:
Structure models should be able to describe all except:
Classes in UML are implemented as tables in a relational database and individual instances of the class are implemented as __________ in the table.
Classes in UML are implemented as tables in a relational database and individual instances of the class are implemented as __________ in the table.
The Object Management Group is a consortium of __________ industry members.
The Object Management Group is a consortium of __________ industry members.
Class diagrams are similar to _____.
Class diagrams are similar to _____.
Which of the following things can be represented by classes on a UML class diagram?
Which of the following things can be represented by classes on a UML class diagram?
Match the symbol with the thing that the symbol represents in UML.
Match the symbol with the thing that the symbol represents in UML.
A class is any separately identifiable collection of objects about which the organization wants to collect and _____________ information.
A class is any separately identifiable collection of objects about which the organization wants to collect and _____________ information.
A depiction of the relationship between two classes is a(n) _____.
A depiction of the relationship between two classes is a(n) _____.
Individual instances of objects are represented as _____ in a table.
Individual instances of objects are represented as _____ in a table.
Which of the following are examples of associations between classes in UML?
Which of the following are examples of associations between classes in UML?
Multiplicities describe the __________ and __________ number of times that instances of one class can be associated with instances of another class.
Multiplicities describe the __________ and __________ number of times that instances of one class can be associated with instances of another class.
The symbol used to represent a class is the _____.
The symbol used to represent a class is the _____.
Valid multiplicity options are shown in which of the following?
Valid multiplicity options are shown in which of the following?
An __________ depicts the relationship between two classes in UML.
An __________ depicts the relationship between two classes in UML.
Attributes are data elements that describe instances in a __________.
Attributes are data elements that describe instances in a __________.
The relationship between two classes is depicted by a(n):
The relationship between two classes is depicted by a(n):
A list of tables associated with a UML class diagram would include attributes, primary keys, and any foreign keys for each table.
A list of tables associated with a UML class diagram would include attributes, primary keys, and any foreign keys for each table.
In this diagram, which of the following statements are likely true regarding the associations?
In this diagram, which of the following statements are likely true regarding the associations?
Which of the following is true about primary keys?
Which of the following is true about primary keys?
Criteria for selection of primary keys include which of the following?
Criteria for selection of primary keys include which of the following?
Match the described situation with the correct multiplicity.
Match the described situation with the correct multiplicity.
Flashcards are hidden until you start studying
Study Notes
Structure Models Purpose
- Serve as tools for planning, documenting, and implementing databases.
Logical Database Structures
- Must describe keys, but not all logical models do.
UML (Unified Modeling Language)
- Specification is maintained by the Object Management Group, not guild.
- Class diagrams represent one type of UML diagram.
Object-Relational Mapping
- A class corresponds to an object represented as a table in a relational database.
- Rows in the table represent individual instances of the class.
Structure Model Functions
- Describe data and information structures pertinent to business processes.
- Should not describe the sequence of activities in processes.
UML Class Diagrams
- Classes depicted as rectangles, associations represented by lines.
- Can represent assets and people, similar to entity relationship diagrams.
Associations in UML
- Highlight the relationship between two classes, depicted as associations.
- Examples include: Customers "participate" in sales, Instructors "teach" classes, Employees "work for" supervisors.
Multiplicities in UML
- Define minimum and maximum associations between class instances (e.g., 0..1, 0..*).
- "0..1" means participation is optional, while "1..*" indicates mandatory participation.
Class Attributes
- Attributes are data elements that describe class instances.
- Primary keys uniquely identify class instances and cannot be null.
Primary Key Selection Criteria
- Must be stable over time, cannot be blank, and using sequential values is preferable.
Table Information
- A UML class diagram includes a list of tables with attributes, primary keys, and foreign keys for each table.
Additional Facts
- Autos can be serviced by multiple dealers, and a person can own many autos, while an auto is licensed in one state.
- Valid multiplicity options must reflect the nature of class associations.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
