Please enable JavaScript.

Coggle requires JavaScript to display documents.

TOPIC 1, Created by Anis Syakirah Adhwa - Coggle Diagram

- - - - ⛔update anomaly
      - ⛔delete anomaly
      - ⛔insert anomaly
    - - Every column in a row must be single valued
      - Primary key cannot be null also known as entity integrity
      - If foreign key is not null it must have a value that corresponds to the value of a primary key in another table
      - All other attributes in the table must describe characteristics of the object identified by the primary key
      - Following these rules allows databases to be normalized and solves the update, insert, and delete anomalies.
- - - - Primary activities
        provide direct value to cust
        Eg, Marketing & sales
      - Support activities
        enable primary activitiesto be efficient
        Eg, Technology
- - - - DATA CAPTURE
        Activity of interest
        Resources affected
        People who participated in the activity
      - SOURCE OF INFORMATION
        paper source docs
        turnaround docs
        source data automation
    - - Creating new records
      - R eading existing data
      - Updating previous record or data
      - Deleting data
    - - Coding Technique
        
        Sequence Codes
        items numbered consecutively to acc for all items
        
        Block Codes
        Block of numbers reserved for specific categories of data
        
        Group Codes
        2 or more subgroups of digit used to code item
        
        Mnemonic Codes
        Letter and numbers interspersed to identify an item
      - Audit Trail
      - Computer-Based Storage
        data is stored in master files/transaction files
    - - Printed Out (Hard Copy)
        Document,report,query
      - Online(Soft Copy)