Unit 1.3.2 - DATABASES
Teach ICT https://teach-ict.com/2016/A_Level_Computing/OCR_H446/OCR_H446_home.html
OCR videos “craigndave” watch these 2 videos https://www.youtube.com/watch?
v=PZVIV8wC4gM&list=PLCiOXwirraUAs5THJQKx6OCVIxPUY5XbU&index=1
https://www.youtube.com/watch?v=thM9e8Cd2QI&list=PLCiOXwirraUAs5THJQKx6OCVIxPUY5XbU&index=5
P 82-105 of white Heathcote PG textbook
Using the above resources complete the table of definitions below
Relational database
Flat file database
Primary key
Foreign key
Secondary key
Index
Entity / table
Field /Attribute
Record/Tuple
Field types Integer=
Real Number (float)=
String=
Boolean=
Data redundancy
Data integrity
Referential integrity
Video
ACID Video A=
C=
(Transaction I=
processing) D=
Record locking
C.R.U.D.
Methods of Capturing data methods :
Teach ICT https://teach-ict.com/2016/A_Level_Computing/OCR_H446/OCR_H446_home.html
OCR videos “craigndave” watch these 2 videos https://www.youtube.com/watch?
v=PZVIV8wC4gM&list=PLCiOXwirraUAs5THJQKx6OCVIxPUY5XbU&index=1
https://www.youtube.com/watch?v=thM9e8Cd2QI&list=PLCiOXwirraUAs5THJQKx6OCVIxPUY5XbU&index=5
P 82-105 of white Heathcote PG textbook
Using the above resources complete the table of definitions below
Relational database
Flat file database
Primary key
Foreign key
Secondary key
Index
Entity / table
Field /Attribute
Record/Tuple
Field types Integer=
Real Number (float)=
String=
Boolean=
Data redundancy
Data integrity
Referential integrity
Video
ACID Video A=
C=
(Transaction I=
processing) D=
Record locking
C.R.U.D.
Methods of Capturing data methods :