CIT 233 Mid-term 2
Terms
undefined, object
copy deck
- A collection of related tables
- Relational database
- A collection of fields that describe a person, place, object, event, or idea. Also, a two-dimensional structure made up of two rows and columns of data in a relational database in which each row is unique, row order is unimportant, all entries are single
- Table
- A single characteristic or attribute of a person, place object, event, or idea.
- Field
- A complete set of field values for a specific person, place, object, event, or idea
- Record
- The specific value, or content, of a field in a record
- Field value
- A field that appears in more than one table, allowing you to connect the records in a separate table.
- Common field
- A field, or collection of fields, whose values uniquely identify each record in a table.
- Primary key
- A primary key field from one table that you include as a field in a second table forms a relationship between the two tables. Also, a field or a collection of fields in one table whose values must match the values of the primary key of some table or must
- Foreign key
- A software program that lets you create databases and then manipulate data in them.
- Database Management System
- A primary key that consists of two or more fields
- Composite key
- A condition that occurs when you store the same data in more than one place; it wastes stored space and can cause inconsistencies.
- Data redundancy