During the systems analysis phase, you must decide how data will be organized, stored,and managed.A (71) is a framework for organizing,storing,and managing data. Each file or table contains data about people, places, things, or events. One of the potential problems existing in a file processing environment is (72) , which means that data common to two or more information systems is stored in several places.
In a DBMS, the linked tables form a unified data structure that greatly improves data quality and access. A(n) (73) is a model that shows the logical relationships and interaction among system entities. It provides an overall view of the system and a blueprint for creating the physical data structures. (74) is the process of creating table designs by assigning specific fields or attributes to each table in the database. A table design specifies the fields and identifies the primary key in a particular table or file. The three normal forms constitute a progression in which (75) represents the best design. Most business-related databases must be designed in that form.
