Flashcards
Databases and SQL
Cards in this deck (16)
- 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.
- 12SQLSQL Stands for Structured Query Language
- 13QueryA Query is a little piece of code within a database that can be used to extract useful information
- 14Writing SQLSELECT
FROM
WHERE - 15Relational DatabasesWhen we use SQL to query related tables, we first need to list all tables that we are using in the FROM section
- 16Edit A QueryUsing SQL to change data on a database
Information
- Description
- Key terms of databases
- Created by
- Caitlin Bergan-Gander
- Views
- 158
- Tags
- History
-
- Created by Dean Whittle · Feb 3, 2016
- Copied by Caitlin Bergan-Gander · Feb 3, 2016
- Rating