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;
15 Cards in this Set
- Front
- Back
|
field |
Column that runs vertically within a table. |
|
|
foreign key |
Link records of one type with those of another type. |
|
|
keys |
Uniquely identify a row or record in a table. |
|
|
normalization |
A three-step technique used to organize data attributes in a more efficient, reliable, flexible, and maintainable structure. |
|
|
primary key |
A field whose value uniquely identifies every row in a table. |
|
|
row |
A record that represents a collection of information relating to an item in a table. |
|
|
table |
Structured file containing rows and columns. |
|
|
column |
a field that represents a category of information within a table such as an address. |
|
|
row |
a record that represents a collection of information relating to an item in a table such as a customer's name, address, phone number, and social security number |
|
|
SQL |
Structured Query Language |
|
|
SELECT statement |
commands the database to retrieve data from the database and return the data to the user. |
|
|
describes why databases are referred to as client/server database systems? |
A system that divides processing between client computers and a database server. |
|
|
What is the most widely used type of database called? |
Relational database |
|
|
What links the tables in a relational database? |
Keys |
|
|
What technique is used to organize data attributes into a more efficient, reliable, and maintainable structure, and ensures that all tables are linked together? |
Normalization |
