Shared Flashcard Set

Details

CSCI TEST TWO
database management
15
Computer Science
Undergraduate 1
04/07/2008

Additional Computer Science Flashcards

 


 

Cards

Term
data mining
Definition
the process by which great amounts of data are analyzed and investigated to spot significant patterns or trends within the data that would otherwise not be obvious.
Term
data modeling
Definition
used for setting up a business and helping it work better; how you set represent your business as a bunch of tables.
Term
database schema
Definition
how you represent your business in a bunch of tables
Term
field
Definition
where a category of information in a database is stored. fields are displayed in columns.
Term
foreign key
Definition
the primary key of another database table that is included for purposes of establishing relationships with that other table.
Term
normalization
Definition
the process of recording data only once in a database to reduce data redundancy.
Term
record
Definition
a collection of related fields in a database.
Term
referential integrity
Definition
for each value in the foreign key of one table, there is a corresponding value in the primary key of the related table.
Term
data warehouse
Definition
a large scale electronic repository of data that contains and organizes in one place all the data related to an organization.
Term
information system
Definition
a system that includes data, people, procedures, hardware, and software and is used to gather and analyze information.
Term
management information system
Definition
a system that provides timely and accurate information that enables managers to make critical business decisions.
Term
transaction processing system
Definition
a system used to keep track of everyday business activities (such as sales of products).
Term
query
Definition
the process of requesting information from a database.
Term
structured query language
Definition
the most popular database query language today.
Term
relational database
Definition
organizes data in table format by logically grouping similar data into relations (or tables) that contain related data.
Supporting users have an ad free experience!