4.1- Intro To Database Flashcards
Accuracy
Refers to the fact that the data is ‘right’
Alternate key
A field that identifies each record with a unique value but is not used as the primary key
Completeness
Refers to how comprehensive data is
Correctness
Refers to data being logically correct or reasonable
Currency
Related to how recent or up to date data is
Data validation
Any technique used to reduce number of errors that can be made during input of data
Database
Collection of data or facts regarding specific topic
Field
Single fact or the smallest unit of data
Primary key
Field that identifies each record with a unique value
Query
Extracting information according to specified criteria
Record
Collection of fields that contains details on a specific entity
Relevance
Relates to how closely data matches your needs
Table
Grouping related records in a table where each row represents a record, and each column a field