743973
Description
Flashcards by Dean Whittle, updated more than 1 year ago
|
Created by Dean Whittle
over 10 years ago
|
|
| Question | Answer |
| Database | An organised store of electronic data |
| Flat File database | All the data is contained in on table |
| Relational Database | Data is stored in seperate tables which are linked together using primary keys / Key fields. |
| Primary Key | A unique identifier used to identify each record in a table |
| Table | Used to store data in a database |
| Records | All of the information about one person or thing in a database. |
| Field | One piece of information about a person or things, many fields make up a record. |
| Queries | Can perform many different functions such as retrieving explicit data from one or more tables. Queries permit the viewing of data from more than one table in a single datasheet. |
| Data Redundancy | Storing the same data more than once in a database. |
| Reports | used to summarise and present the data that is in the tables |
| Forms | A user friendly screen to input data. |
Want to create your own Flashcards for free with GoConqr? Learn more.