Term
|
Definition
collection of numbers and text
ex.273459368 |
|
|
Term
|
Definition
| list of data organized into fields and records |
|
|
Term
|
Definition
| data storage format that can contain a specific type or range of values |
|
|
Term
| Database Management System (DBMS) |
|
Definition
software that handles storage, retrieval, and updating of data in a computer system
[STORE AND RETRIEVE DATA] |
|
|
Term
|
Definition
| structures for written output of data |
|
|
Term
|
Definition
| specialized language for requesting information from a database |
|
|
Term
|
Definition
| visual representation of the data contained in a table or the results returned by a query |
|
|
Term
|
Definition
meaning derived from the data
ex.SSN: 273-45-9368 |
|
|
Term
|
Definition
| database query language for relational databases (the user enters commands using visual tables) |
|
|
Term
|
Definition
|
|
Term
|
Definition
| field that defines the relationship between two tables |
|
|
Term
|
Definition
large collection of data stored in a well-defined structure
ex.paper database: phone book
ex.computer database: OSU stores student info in a database |
|
|
Term
|
Definition
computer program that organizes and analyzes data
[STORE AND ANALYZE DATA] |
|
|
Term
|
Definition
| a question structure that sorts, filters, and selects specific information |
|
|
Term
|
Definition
| rows where data on tables are listed (consists of one or more fields) |
|
|
Term
|
Definition
| structure for screen views of data |
|
|
Term
|
Definition
| unique identifier for a database record |
|
|
Term
| Referential Data Integrity |
|
Definition
| set of rules that specifies what records may exist in each table |
|
|
