Shared Flashcard Set

Details

BYU ISYS 201 ER, DB
Test 1
21
Business
Undergraduate 1
02/19/2009

Additional Business Flashcards

 


 

Cards

Term
attribute
Definition
columns; Characteristics that describe entities
Term
cardinality
Definition
Maximum number of occurrences of one entity for a single occurrence of the related entity
Term
entity
Definition
table; any object or concept about which we want to store data
Term
foreign key
Definition
an attribute in one table that is a primary key in another table
Term
primary key
Definition
an attribute or set of attributes that can be used to identify individual instances of an entity
Term
information granularity
Definition
refers to the extent of detail within the informaiton
Term
transactional information
Definition
helps operational tasks
Term
analytical information
Definition
organizational info; supports managerial tasks
Term
real-time information
Definition
immediate, up-to-date info
Term
real-time system
Definition
provides real-time info in response to queries
Term
ideal measures
Definition
simple, objective, obtainable, definable, valid, robust
Term
high quality information
Definition
accurate, complete, consistent, unique, timely
Term
physical view
Definition
the physical storage of information on a storage device such as a hard disk
Term
logical view
Definition
focuses on how users logically access information to meet their particular business needs
Term
redundancy
Definition
the duplication of information or storing the same information in multiple places
Term
information integrity
Definition
a measure of the quality of information
Term
integrity constraints
Definition
the rules that help ensure the quality of information
Term
relational integrity constraint
Definition
the rules that enforce basic and fundamental information-based constraints
Term
business-critical integrity constraint
Definition
enforces business rules vital to an organization's success and often requires more insight and knowledge than relational integrity constraints
Term
database management system
Definition
software through which users and application programs interact with a database
Term
integration
Definition
allows separate systems to communicate directly with each other
Supporting users have an ad free experience!