Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Organization and Data Control - Coggle Diagram
Data Organization and Data Control
Data Error
Transcription Error
Transposition Error
Data Source Error
Garbage-in-Garbage-out
Data Control
Data Verification
Input Data Twice
Double Data Entry
Data Validation
Field Length Check
Range Check
Field Presence Check
Type Check
Format Check
Check digit
Data Hierarchy
Field < Record < Table < Database
Database Management System(DBMS)
Basic Functions
Add a new record
Delete Existing records
Modify existing record
Browse records
Delete Table
Modify Table
Create Table
Essential Features for Database Management
Index
Data Entry Forms
Sort
Query Forms
Filter
Reports
E.g. MySQL, Microsoft Access...
File Access Modes
Direct Access Mode
Very high reliability and durability
Low cost per storage unit
Short seek time
Sequential Access Mode
Average reliability and durability
Very low cost per storage unit
Long seek time
4C17 Sam Ching