Reading...
Play button
Play button
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;
22 Cards in this Set
- Front
- Back
|
Data
|
A numeric or apohanumeric group of symbols
|
|
|
table
|
an object that stores data
|
|
|
data type
|
field type, text numbers, currency, date, etc
|
|
|
DBMS
|
software tools used to manage databases
|
|
|
report
|
strutures for written output of data which again allow one to combine information from one or more objects and view both details and summaries
|
|
|
query language
|
the language you use to talk to a database
|
|
|
data sheet
|
the comiled information of data that will be entered into a database
|
|
|
information
|
data that has been given meaning
|
|
|
QBE
|
query by example, used to design a query
|
|
|
fields
|
a specific set of ordered categories
|
|
|
foreign key
|
the field used to relate two table
|
|
|
database
|
a collection of related data sotred in a well defined structure
|
|
|
spreadsheet
|
store and analyze data
|
|
|
query
|
question structure to sort, filter, and select specific information
|
|
|
record
|
consists of one or more ordered categpries called fields
|
|
|
form
|
structures for input of data
|
|
|
primary key
|
a field or combination of fields which uniquely identifies a record in a database
|
|
|
referencial data integrity
|
a set of rules which speifies what record may exoist in each table
|
|
|
rules when setting up relationships
|
join tbles and enforce referencial data integrity
|
|
|
heirarchy of a database
|
file table records fields properties types
|
|
|
creation of dynasets
|
what is created when aquery is run
|
|
|
criterion
|
a collection of conditions. tells the DBMS which records to retrieve
|
