Databases and SQL

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.
SQL	SQL Stands for Structured Query Language
Query	A Query is a little piece of code within a database that can be used to extract useful information
Writing SQL	SELECT FROM WHERE
Relational Databases	When we use SQL to query related tables, we first need to list all tables that we are using in the FROM section
Edit A Query	Using SQL to change data on a database

Resource summary

	Created by Dean Whittle over 9 years ago

	Copied by Caitlin Bergan-Gander over 9 years ago