Shared Flashcard Set

Details

Database
Database Course Information Accumulative
19
Computer Science
Undergraduate 1
05/04/2009

Additional Computer Science Flashcards

 


 

Cards

Term
Use of Database
Definition
To provide state awareness
Term
Query
Definition
To create, define, and modify
Term
Modeling
Definition
To define organizational structure; To capture decision character
Term
Hard data
Definition
Clearly defined data; Generated by formal systems
Term
Soft Data
Definition
Intuitive or subjective information obtained by informal means.
Term
Database Management System (DBMS)
Definition
Software to create, store, organization, and retrieve data from a single database or several databases
Term
Data Definition Language
Definition
commands to create or destroy a structure in the dictionary. For example: create, drop, alter.
Term
Query Language
Definition
Commands to retrieve data
Term
External Schema
Definition
Deals with usage, programs, models
Term
Conceptional Schema
Definition
Forms design, report writers, and query languages.
Term
Logical Schema
Definition
Hierarchical, network, relation or object oriented
Term
Physical Schema
Definition
Sequential, indexed, hashed, B-tree access methods
Term
Primary Key
Definition
Column(s) used to uniquely differentiate rows
Term
Foreign Key
Definition
Primary key duplicated in another table to enable access between tables
Term
Candidate Key
Definition
Combinations of column(s) with the potential to uniquely differentiate rows
Term
Super Key
Definition
Any Combination of columns which uniquely differentiate rows
Term
Surrogate Key
Definition
Artificial attribute defined to possess primary key characteristics
Term
Composite Key
Definition
Primary Key spanning multiple columns
Term
Secondary Key
Definition
Columns used to facilitate retrieval by narrowing the possible outcomes to a more manageable set
Supporting users have an ad free experience!