Glossary of Terms -Database concepts

?
  • Created by: kenyone
  • Created on: 14-05-16 09:31
J J P P X O R D S F I T W J D Y A B N U K
H I E E F K W V I H P R I M A R Y K E Y N
T A R E L A T I O N A L D A T A B A S E M
P V S G A B J J G L B N M D A Y O C I K N
D E I A H U X W A M C H B L E W V G X E J
A R S E X R C I T S D T C P W H T X R A Q
T I T V H E N J R N H R R Y W W O U A F I
A F E Q F L A T F I L E D A T A B A S E N
B I N T H A U M E J D A I X H T S M L U G
A C T T T T E P N P M U R P G J O N N U X
S A S J S I B N R U M D X F Y Y U U O I E
E T T E O O C B C L P X E C S K Q B I H F
M I O Y B N H X N L A M C S Y R S L T W U
K O R O K S L H P A E W E N R B S Q A P M
C N A Y C H H R F O R E I G N K E Y D A H
I E G S W I Y B I K R C V R M O N H I X G
O M E T A P U P N B J E O W M I J Q L F Q
D A T A I N C O N S I S T E N C Y H A G D
T M R N T C F R V P R R Q V S O Y D V T V
D G N O C H J V T J M F H E S J T I E P V
C G K D T M I I Q V F H H H T G R U W I K

Clues

  • A field in a table that uniquely identifies a record. (7, 3)
  • A field in one table that is the primary key in another table and is used to create a relationship between those two tables. (7, 3)
  • A persistent organised store of data where data is stored as a collection of related tables to minimise data redundancy. (10, 8)
  • A persistent organised store of data where data is stored in a single file organised into fields and records. (4, 4, 8)
  • A persistent organised store of data. (8)
  • Non-volatile storage on a secondary storage medium such as a hard disk. (10, 7)
  • The logical connection created between two tables using a primary and foreign key pair. (12)
  • When the computer software checks that data entered is sensible. (10)
  • Where data is entered twice and checked that each version is the same, to avoid data being entered with typing mistakes. (12)
  • Where different versions of data become different because duplicate versions have been stored and updated differently. (4, 13)

Comments

X,x,X

Report

This is very helpful even with someone with a slow learning process like me 

19002276

Report

The person above me is dumb

Similar Computing resources:

See all Computing resources »See all Databases resources »