Key terms of databases
Dean Whittle
Flashcards by Dean Whittle, updated more than 1 year ago
Dean Whittle
Created by Dean Whittle over 9 years ago

Resource summary

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.
Show full summary Hide full summary


History of Medicine: Ancient Ideas
James McConnell
Geography Coastal Zones Flashcards
Zakiya Tabassum
Biology- Genes and Variation
Laura Perry
Enzymes and Respiration
I Turner
GCSE AQA Biology - Unit 2
James Jolliffe
GCSE Maths: Algebra & Number Quiz
Andrea Leyden
GCSE Maths: Geometry & Measures
Andrea Leyden
GCSE AQA Biology 1 Quiz
Lilac Potato
GCSE History – Social Impact of the Nazi State in 1945
Ben C
Using GoConqr to teach science
Sarah Egan
Using GoConqr to study English literature
Sarah Egan