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;
13 Cards in this Set
- Front
- Back
|
What is a Database? |
A self-describing collection of integrated records. |
|
|
What is the Purpose of a Database? |
To organise and keep track of things that involve more than one theme. |
|
|
Relationship Among Rows |
Values in one table may relate to rows/records in another table. |
|
|
Primary Key |
A column or a group of columns that identifies a unique row in a table. |
|
|
Foreign Keys |
Fields other than the primary key that are used to connect to a table where the field is the primary key. |
|
|
Relational Databases |
Databases using tables, keys and foreign keys. |
|
|
Metadata |
Data that describes data. |
|
|
Components of a Database Application System |
- User, - Database Application, - Database Management System, - Database. |
|
|
Database Management Systems (DBMS) |
Programs used to create, process and administer a database.
|
|
|
How Do Database Applications Make Databases More Useful? |
Databases can have multiple applications and therefore multiple users. |
|
|
Forms |
Used to read, insert, modify and delete data. |
|
|
Reports |
Show data in structured context. |
|
|
Queries |
A means of getting answers from database data. |
