James Louden
Mind Map by , created over 5 years ago

Key Words used in Databse theory

9
0
0
Tags
James Louden
Created by James Louden over 5 years ago
AS Levels ICT -Form Controls
lukejones
Databases
loz .
Database Terminology
charcrawford
A-Level Law: Theft
amyclare96
GCSE History – Social Impact of the Nazi State in 1945
Ben C
OCR gcse computer science
Jodie Awthinre
GCSE AQA Computer Science - Definitions
James Jolliffe
Managing Digital Data Review
Shannon Anderson-Rush
SQL Quiz
Chris Cronin
Data, Information and Databases
maryamxjay
Database
1 File
1.1 Organise Records
2 Record
2.1 Group of Fields
3 Fields
3.1 Text
3.2 Numbers
3.3 Calculated
3.4 Date/Time
3.5 Graphic
4 Flat
4.1 1 table
5 Relational
5.1 Linked tables
5.2 Keys
5.2.1 Primary
5.2.1.1 Unique
5.2.1.2 Must have
5.2.2 Foreign
5.2.2.1 links tables relationships
5.3 Avoid Data Duplication
6 Search
6.1 Complex
6.1.1 >1 field
6.2 Simple
7 Sort
7.1 Complex
7.1.1 >1 field
8 Validation
8.1 Presence Check
8.1.1 field not blank
8.2 Restricted Check
8.2.1 dropdown box
8.3 Field length
8.3.1 size of field
8.4 Field Range
8.4.1 range of numbers

Media attachments