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;
14 Cards in this Set
- Front
- Back
What is a database? |
A collection of organized data stored in a computer system |
|
Advantages of using a database |
-easy to add to or amend existing records. -data can easily be sorted |
|
What are single data items ? |
Fields |
|
What are many fields? |
Records |
|
What are many records |
Tables(Files) |
|
Give the three parts of fields |
-field names -field types -field data |
|
What is a primary key? |
Individual pieces of data that are unique and are used to differentiate one record from another |
|
What are two main types of computer databases? |
*flat file *Relational |
|
What is a flat-file database? |
Databases that hold all data in one table |
|
What are the limitations of a flat-line database? |
-duplicate data is often unnecessarily entered -space is wasted with duplicate data -data takes a long time to enter and update |
|
What is a Relational Database |
Uses two or more tables linked together |
|
What is a table relationship? |
When two tables are joined |
|
What are the benefits of Relational databases |
-duplicate data is reduced -database spaces isn't wasted -quicker to enter data |
|
What are the main characteristics of a Relational database |
-built from relations -each table contains data about one entity -table must have a primary key -tables are linked by primary and foreign keys |