Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
31 Cards in this Set
- Front
- Back
Binary Relationship
|
relationships between instances of two different entities
|
|
Business event risk
|
results in errors and irregularities dealing with resources, agents and locations
• Ex. business event occurring without proper authorization. • Ex. business event occurring at the wrong time or sequence |
|
Business Process
|
A process comprised of events in order to accomplish a specific task
• Ex. OTC, Procurement, and Conversion |
|
Candidate keys
|
meets the criteria for being a primary key, every primary key is a candidate key, but every candidate key is not a primary key
• Ex. Student ID = primary key • Ex. Social Security # = candidate key but not primary key as it is not used due to security laws |
|
Cardinalities
|
means of more precisely representing business process rules and characteristics affected by characteristics governing the process as well as entity relationships
|
|
Cardinality Constraints
|
the number of instances of one entity that can or must be associated with each instance of another entity
• Minimum Cardinality o If zero, then optional o If one or more, then mandatory • Maximum Cardinality – the maximum number (usually many) |
|
Composite attribute
|
attributes that can (and likely should) be decomposed into separate attributes
• Ex. Address – actually composed of several separate attributes: street address, city, state, and zip code |
|
Conceptual Data Model
|
represent the entities or objects about which you want to collect data,
and rules about the meaning and interrelationships among these data objects |
|
Degree of a Relationship
|
number of entity types that participate in it
|
|
Duality
|
involves one event that causes resource inflows while the other event causes
resource outflows |
|
Economic Event and Exchange
|
events or exchanges that increase or decrease the quantity of a firm’s resources
|
|
Entity
|
persons, places, things or concepts you want to keep data about
• Entity group represents a collection of individual entity instances |
|
Entity Attribute
|
a property or characteristic that describes an entity
|
|
E-R Diagram
|
model displaying the relationships among entities
|
|
Field
|
based upon the relation’s columns of attributes
|
|
Foreign keys (also called posted keys)
|
attribute that appears as a non primary key in one entity (table) and as a primary key attribute in another entity (table)
• Many to Many – create a separate relation for that includes key attributes from both relations o Combination of key attributes becomes primary key for new relation • One to Many – post the key attribute of the relation on the one side of the cardinality to the many side of the cardinality o Big eats small |
|
Information processing risks
|
risks associated with incomplete, inaccurate, or unauthorized recording, maintaining, and reporting information activities
|
|
Instances
|
individual items that comprise an entity group
• Ex. Entity – Salesperson, Sample instances might include Salesperson #465 |
|
Logical Data Design
|
the blueprint for the physical database
|
|
Multivalued attribute
|
multivalued attribute can have more than one instance
• Ex. An employee could have one skill, two skills, or many skills o new relation would include the primary key of the relation (i.e., Employee number) and the multivalued attribute |
|
Normal form, normalization
|
relations with minimal redundancies, each data attribute of a relation should describe only the object represented by the relation
|
|
*Object oriented modeling
|
type of modeling technique
|
|
Primary key (attribute)
|
unique attribute type used to identify a single instance of an entity
|
|
REAL Template
|
template organizing business processes by resources, events, agents and locations
|
|
Record
|
rows in a relation table, based upon the relation’s rows of data instances
|
|
Relation
|
an array with columns and rows
|
|
Relational Database
|
database comprised of multiple relations, comprised of data from an E-R diagram
|
|
Relationships betweens entities
|
an association between the instances of one or more entity groups of interest to the organization
|
|
Table
|
physical database component that organizes instances by fields (columns) and records (rows)
|
|
Ternary Relationship
|
simultaneous relationship between instances from three or more entities
|
|
Unary Relationship
|
relationship between the instances of a single entity
• Ex. an employee who supervises other employees |