28. Another problem with the flat-file approach is the user’s inability to obtain additional
information as his or her needs change. This problem is called task-data dependency. The user’s
29. Organizations have overcome some of the problems associated with flat files by implementing
the database model to data management. Figure 2-13 illustrates how this approach centralizes the
30. Record layout diagrams are used to reveal the internal structure of the records that constitute a
32. The DBMS is a special software system that permits users to access authorized data only. The
user’s application program sends requests for data to the DBMS, which validates and authorizes access
33. The flat-file approach is a single-view model. Files are structured, formatted, and arranged to
suit the specific needs of the owner or primary user of the data. Such structuring, however, may
34. Transaction volume is the key factor. Large-scale systems that process high volumes of
transactions often use real-time data collection and batch updating. Master file records that are unique
to a transaction such as customer accounts and individual inventory records can be updated in real time
35. In a real-time processing environment, the master files are updated as soon as the transaction is
submitted and accepted into the system. Thus, reports are more accurate in the sense that the
38. Sequential codes are appropriate for items in either an ascending or descending sequence, such
as the numbering of checks or source documents. An advantage is that during batch processing, any
gaps detected in the sequence is a signal that a transaction may be missing. A disadvantage is that the
codes carry little, if any, information other than the sequence order. Another disadvantage is that