Please enable JavaScript.
Coggle requires JavaScript to display documents.
Systems Design – 2 (security and control design (Output Controls (Spot…
Systems Design – 2
security and control design
Data Controls
Data type.
Length.
Format.
Value range.
Mandatory.
Default value.
Visibility.
Clerical Controls
Serial number of the batch.
Count of batch contents.
Serial numbers of forms in the batch.
Batch control totals.
Hash totals.
Process Controls
Output Controls
Spot check
Control totals
Pre-numbering
Security and Audit
Logical Security
AAA
firewalls
encryption
Physical Security
barriers
locks
System Audit Trail
Input Controls
Verification of Input Data
Validation of Input Data
logical and physical design
Physical Data Design
Physical Process Design
objectives and principles of data design
Normalisation
Normalisation is a technique that designers use to derive flexible, robust and redundancy-free data structures.
the design of codes
Code Design
Self-Checking Codes
look up the code in some reference data table
uses an algorithm
faceted codes
A faceted code is one that is made up of a number of parts
Database Management Systems
Hierarchical Databases
Network Databases
CODASYL database model
network DBMS are IDMS (Integrated Data Management System) and IDS (Integrated Data Store).
Object-Oriented
Physical files
Uniqueness.
Stability.
Expandability.
Length
design patterns
Pattern name – a handle for describing the design problem.
Problem – explaining the problem and its context.
Solution .
Consequences – understand the benefits and disadvantages of applying the pattern.