Dean Whittle
Flashcards by , created over 5 years ago

Key terms of databases

Dean Whittle
Created by Dean Whittle over 5 years ago
RE Keywords - Paper 1 - Religion and life
Kerris Linney
Using GoConqr to teach science
Sarah Egan
Weimar Revision
Tom Mitchell
Transition Metals
To Kill a Mockingbird Key Themes and Quotes
Matthew T
Computer Science Keywords Revision
Rachael O'Sullivan
IT - The Online World
Business Studies GCSE
pelumi opabisi
ICT Key Terms Quiz - Part 1
Mr Mckinlay
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.