- Shuffle
Toggle OnToggle Off
- Alphabetize
Toggle OnToggle Off
- Front First
Toggle OnToggle Off
- Both Sides
Toggle OnToggle Off
Front
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
PLAY BUTTON
PLAY BUTTON
17 Cards in this Set
- Front
- Back
|
What is the purpose of a database?
|
to keep track of things that involve more than one theme
|
|
Contrast spreadsheets and databases.
|
Lists that involve a single theme can be stored in a spreadsheet
Lists that involve multiple themes require a database. |
|
What is a database?
|
a self-describing collection of integrated records
|
|
What is a byte?
|
character of data
|
|
How are bytes grouped?
|
into columns (AKA fields)
|
|
How are columns/ fields grouped?
|
into rows (AKA records)
|
|
What is a row/ record?
|
the collection of data for all columns
|
|
What is a table/ file?
|
a group of similar rows/ records
|
|
Databases have a BLANK of data elements.
|
hierarchy
|
|
T/F: A database is a group of tables/ files.
|
True
|
|
Special data AKA
|
metadata
|
|
What does the cylindrical symbol represent? When is it used?
|
a computer disk drive
used in diagrams where databases are stored on magnetic disks |
|
What is a key?
|
a column or group of columns that identifies a unique row in a table
|
|
T/F: Every table must have a key.
|
True
|
|
What is a foreign key?
|
columns are keys but they are keys of a different (or foreign) table than the one in which they reside
|
|
What is a relational database?
|
databases that carry their data in the form of tables and that represent relationships using foreign keys
|
|
Why are relational databases called relational and not relation?
|
b/c relation is a more formal name for a table
|
