Chapter 3 key terms

Description

Flashcards for Chapter 3 - Data Modeling key terms from textbook Accounting Information Systems.
Stephanie Poole
Flashcards by Stephanie Poole, updated more than 1 year ago
Stephanie Poole
Created by Stephanie Poole over 1 year ago
5
0

Resource summary

Question Answer
Aggregation relationship A special-purpose UML notation representing the relationship between two classes that are often considered together, such as when a sports league is made up of a collection of teams.
Association UML symbol that depicts the relationship between two classes; it is modeled as a solid line that connects two classes in a model.
Attributes Data elements that describe instances in a class, very much like fields in a database table; characteristics, properties, or adjectives that describe each class.
Business rule Succinct statements of constraints on business processes; they provide the logic that guides the behavior of the business in specific situations.
Cardinalities See multiplicities.
Class Any separately identifiable collection of things (objects) about which the organization wants to collect and store information. Classes can represent organization resources (e.g., trucks, machines, buildings, cash, investments), persons (e.g., customers, employees), events (e.g., sales, purchases, cash disbursements, cash receipts), and conceptual structures (e.g., accounts, product categories, budgets). Classes are typically implemented as tables in a relational database, where individual instances of the class are represented as rows in the table.
Class diagrams Structure models prepared using UML notation
Composition relationship A special-purpose UML notation representing the relationship between two classes that are often considered together, similar to aggregation relationships, except in composition relationships, one class cannot exist without the other, such as a book and the chapters that compose the book.
Constraints Optional or mandatory guidance about how a process should perform in certain situations.
Data models A graphic representation of the conceptual contents of databases; data models support communication about database contents between users and designers of the database.
Entities The people, things, and events in the domain of interest; in UML notation, entities are modeled as classes.
foreign key (FK) Attribute that allows database tables to be linked together; foreign keys are the primary keys of other tables placed in the current table to support the link between the two tables.
Generalization relationship A special-purpose UML symbol that supports grouping of things that share common characteristics; it reduces redundancy because the shared characteristics need only be modeled once.
Multiplicities UML symbols that describe the minimum and maximum number of times an instance of one class can be associated with instances of another class for a specific association between those two classes; they indicate whether the two classes are part of one-to-one, one-to-many, or many-to-many relationships.
primary key (PK) An attribute or a combination of attributes that uniquely identifies an instance of a class in a data model or a specific row in a table.
Relationship The business purpose for the association between two classes or two database tables; see association.
Structure model A conceptual depiction of a database, such as a UML class model or an entity-relationship model
Show full summary Hide full summary

Similar

CPA Exam Topics and breakdown
joemontin
CPA Exam Flashcards
joemontin
CPA Exam Sample Questions Pt. 1
nedtuohy
Accounting Definitions
Tess Morris
Accounting I - Objective 2 Keller
Kathleen Keller
Exam Bank 2
Valek
Specific Order Costing
Natalie Gray
COSTING SYSTMES
Francia o
Glossary of Accounting Terms
racheloucks
Unit 4 The Accounting Cycle
a.j.hemphill
Chapter One: Introduction to Accounting
charlotte.power9