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;
20 Cards in this Set
- Front
- Back
|
entity integrity constraint
|
makes sure a primary key is unique and is not NULL
|
|
|
referential integrity constraint
|
forces a foreign key to point to a primary key that is present in the database
|
|
|
data type
|
the definition of the data to be stored
|
|
|
field or attribute
|
a space in the record with a predefined location, length and data type
|
|
|
record or tuple
|
a collection of entries in a table
|
|
|
table
|
a collection of records or tuple related to the same category
|
|
|
form
|
a user friendly interface that allows user to display the data in a table and edit if necessary
|
|
|
query
|
a mechanism that allows user to find or extract portions of data based on specific predefined criteria
|
|
|
database
|
a collection of related data
|
|
|
DBMS
|
a program or group of programs that allow users to manipulate data using components like tables, forms, queries, etc.
|
|
|
primary key
|
uniquely identifies records in a table
|
|
|
foreign key
|
uniquely identifies records in another table or relation
|
|
|
loading
|
loading an existing data file such as a text file or sequential file
|
|
|
backup
|
creating a backup of the database being worked on
|
|
|
database storage reorganization
|
used to reorganize a set of files into different file organizations
|
|
|
controlled redundancy
|
ensures that multiple copies of the same data are consistent
|
|
|
uncontrolled redundancy
|
allows for "facts" or the same data to be stored in several places of the database several times
|
|
|
database schema
|
a description of the database
|
|
|
database state
|
the data that is currently stored in the database, and is subject to change if the database is updated or edited
|
|
|
relationship
|
a link between two relations with a specific cardinality (one-to-one, one-to-many, many-to-many)
|
