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
The purpose of a database is to |
Keep track of things Ri |
|
Databases vs. spread sheets |
Spread sheets are good for organizing lists with one variable Databases organize data from multiple variables and can be updated with forms |
|
Database |
A self describing collection of Intergrated records |
|
In databases bytes (characters of data) are grouped in - |
Columns |
|
Columns are also called |
Fields |
|
Columns are also called |
Fields |
|
Columns are grouped into |
Rows |
|
Columns are also called |
Fields |
|
Columns are grouped into |
Rows (a collection of data for all columns) |
|
Rows are also called |
Récords |
|
A group of similar rows are called a |
Table or file |
|
Metadata |
Describes the structure of the database |
|
What are database management systems (DBM) |
A program used to create, process, and administer a database |
|
Example of a DBM |
DB2, ACCESS, SQL Server, Oracle Database, MySQL |
|
What are the tasks of Database Administration (DBA) |
Development, security, backing up and recovering data, improving performance and adapting, |
|
Data base design |
The process of converting a data model into tables, relationships, and data constraints |
|
Database integrity problem |
An error in the database |
|
Normalization |
The process of converting a poorly structured table into two or more well caricatured tables |
|
The data development process |
Requirements - Data Model - Database Design |