Flashcards
Chapter 3 Key Terms
Cards in this deck (17)
- 1aggregation relationshipdescribe classes that are often considered together
- 2associationdepicts the relationship between two classes
- 3attributesdata elements that describe the instances in a class
- 4business rulea succinct statement of a constraint on a business process
- 5cardinalitiesthe numerical relationship between the row of one table and the row of another table
- 6classany separately identifiable collection of things about which the organization wants to collect and store information. can be resources, persons, events, and conceptual structures
- 7class diagramsa type of diagram within UML that describe the logical structure of a database system and are similar to entity-relationship diagrams
- 8composition relationshipa form of aggregation when the smaller parts do not exist without the larger part of the whole (ex. Chapters in a book)
- 9constraintsoptional or mandatory guidance about how a process should perform in certain situations
- 10data modelsrepresent the conceptual contents of databases to communicate with uses of those databases
- 11entitiesThe people, things, and events in the domain of interest; in UML, they are modeled as classes
- 12foreign key (FK)an attribute or combination of attributes that allows tables to be linked together
- 13generalization relationshipallow grouping of things that share common characteristics to reduce redundancy
- 14multiplicitiesdescribe the minimum and maximum number of times instances in one class can be associated with instances in another class
- 15primary key (PK)an attribute or combination of attributes that uniquely identifies each instance in a class or row in a table
- 16relationshipthe business purpose for the association between two classes of two database tables
- 17structure modeldescribe the data and information structures inherent in a business process or processes
Information
- Description
- Flashcards on Chapter 3 Key Terms, created by MacKenzie Burch on 26/08/2022.
- Created by
- MacKenzie Burch
- Views
- 1
- Tags
- Rating