Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
19 Cards in this Set
- Front
- Back
|
Data |
numeric or alphanumeric group of symbols. A collection of unprocessed items, which can include text, numbers, images, audio, and video. |
|
|
Table |
Organized into a specific set of ordered categories or fields. A group of related records. |
|
|
Data type/Field Type |
The type of information stored |
|
|
DBMS |
Database Management System |
|
|
Report |
Structures for written output of data which again allow one to combine information from one or more objects and view both details and summaries. |
|
|
Structured Query Language |
SQL-the language you use to talk to the database |
|
|
Data Sheet |
a simple view of data arranged in rows and columns |
|
|
Information |
give meaning to data it becomes information |
|
|
QBE-Query by example |
a graphical user interface (GUI)
|
|
|
Fields |
Each table is organized into categories of data known as fields |
|
|
Foreign key |
A field in one table whose values are required to match the primary key in another table |
|
|
Database |
a collection of tables |
|
|
Query |
"question" that retrieve information from a database. Queries are structures to sort, filter, and select specific information |
|
|
Record |
Related information is input into the table |
|
|
Form |
Structures for displaying data that allow a user to view information from and input information in one or more objects (tables, queries, etc.). |
|
|
Primary Key |
A field that uniquely identifies a record |
|
|
Referential Data integrity |
Limiting entries made in a foreign key field to those items listed in the primary key field of the related table |
|
|
Requirements of a valid foreign key: |
1.The foreign key must be a primary key on at least one of the tables. 2.The field types for the foreign key field must be the same on both tables. 3.The information being related must be the same. |
|
|
Hierarchy of a database: |
File Table Fields |
