Flashcards
Databases
Cards in this deck (11)
- 1DatabaseAn organised store of electronic data
- 2Flat File databaseAll the data is contained in on table
- 3Relational DatabaseData is stored in seperate tables which are linked together using primary keys / Key fields.
- 4Primary KeyA unique identifier used to identify each record in a table
- 5TableUsed to store data in a database
- 6RecordsAll of the information about one person or thing in a database.
- 7FieldOne piece of information about a person or things, many fields make up a record.
- 8QueriesCan 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.
- 9Data RedundancyStoring the same data more than once in a database.
- 10Reportsused to summarise and present the data that is in the tables
- 11FormsA user friendly screen to input data.