+
Cards In This Set
| Front | Back |
|
Data, information
|
Raw facts representing events that occur in an organization
|
|
Database
|
Collection of related tables
|
|
Relational database
|
-separate tables related together-each record must be unique
|
|
File
|
Can be thought of as a table
|
|
Table, entity
|
A collection of fields that describes a person, place, etc.
|
|
Field, attribute
|
Characteristic of a person, place, object, event, or idea field=attribute
|
|
Record, observation, row
|
Specific occurrence of a set of related fields
|
|
Field value
|
Product size, quantity, number, etc.
|
|
Redundancy
|
When data is stored in more than one place at once
|
|
Common field, relation
|
Used to relate tables
|
|
Entity-relationship (diagram)
|
Path from one table to another based on shared attributes
|
|
Key, primary key, foreign key
|
-unique piece of data that ID's the record-unique identifier for a record-field found within a table that also appears as the primary key of another table
|
|
Concatenated key
|
Key used more than once to ID a primary key
|
|
Data integrity
|
Database has integrity if data follows certain rules, known as integrity constraints
|
|
Data normalization
|
Logical process used to 'model' data and the logical relationships between data
|
