psy290 Lecture Notes - Lecture 4: Database Normalization, Unique Key, Flowchart
Document Summary
System flowcharts depict the relationships among the input, processing, and output of an accounting information system (ais). A system flowchart begins by indentifying the inputs that enter the system and their origins. The input can be new data entering the system, data stored for future use or both. The input is followed by the processing portion of the flowchart. A program flowchart illustrates the sequence of logical operations performed by a computer in executing a program. Document flowcharts are particularly useful in analyzing the adequacy of control procedures in a system, such as internal checks and segregation of functions. Document flowcharts can reveal weaknesses or inefficiencies in a system, such as inadequate communication flows, unnecessary complexity in document flows, or procedures responsible for causing wasteful delays. Database normalization basically takes an unormalized table (a table that is not in 3rd normal form) and divides the table into smaller tables in order to eliminate data element redundancy.