Databases and SQL

Caitlin Bergan-Gander
Flashcards by , created almost 4 years ago

Key terms of databases

Dean Whittle
Created by Dean Whittle almost 4 years ago
Caitlin Bergan-Gander
Copied by Caitlin Bergan-Gander almost 4 years ago
GCSE Computing: Hardware
Yasmin F
IT - The Online World
2.1.3 Software
Lavington ICT
Driver's Exam
AP US History Topics
GCSE Computing: Fundamentals of Computer Systems
Yasmin F
Data representation
Brodie McMeowface
Computer Science Flashcards (GCSE)
Lewis D'Arcy
Computer Science Keywords Revision
Rachael O'Sullivan
OCR gcse computer science
Jodie Awthinre
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
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