Loading [MathJax]/jax/output/HTML-CSS/fonts/TeX/fontdata.js

We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our terms and conditions for more information.

Next up

FLAT FILE VS RELATIONAL DATABASE

rosiejones

Copy and Edit

Database

Description

Key Words used in Databse theory

Mind Map by James Louden, updated more than 1 year ago

	Created by James Louden over 11 years ago

(0)

Resource summary

Database

File
1. Organise Records
Record
1. Group of Fields
Fields
1. Text
2. Numbers
3. Calculated
4. Date/Time
5. Graphic
Flat
1. 1 table
Relational
1. Linked tables
2. Keys
  1. Primary
    1. Unique
    2. Must have
  2. Foreign
    1. links tables relationships
3. Avoid Data Duplication
Search
1. Complex
  1. >1 field
2. Simple
Sort
1. Complex
  1. >1 field
Validation
1. Presence Check
  1. field not blank
2. Restricted Check
  1. dropdown box
3. Field length
  1. size of field
4. Field Range
  1. range of numbers

Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

To join the discussion, please sign up for a new account or log in with your existing account.

Want to create your own Mind Maps for free with GoConqr? Learn more.

Similar

OCR gcse computer science

Jodie Awthinre

GCSE AQA Computer Science - Definitions

James Jolliffe

Managing Digital Data Review

Shannon Anderson-Rush

Midterm 2 (Chapter 5 - 13)

Yorria Raine

SQL Quiz

Chris Cronin

GCSE AQA Computer Science - Definitions

moffat00

1z0-082

Henderson Viscarra

Database Final Exam

dbm

Data, Information and Databases

maryamxjay

AS Levels ICT -Form Controls

lukejones

Browse Library