Establishing the Worthiness of Information Systems Data through Information Engineering

1. Establishing the Worthiness of Information Systems Data through Information Engineering Presenter: Eghosa Ugboma Florida Memorial University Miami Gardens, Florida

2. The Tool (Planning Sheet) • Question • How is this paper related to Information Systems Education? • Answer • Shows one good method of planning, designing, and creating error-free information systems • Question • What is the key issue? • Answer • A tool called the planning sheet that uses Information Engineering principles to develop effective information systems • Question • What is being learned? • Answer • The planning sheet is an excellent instrument used to optimize data tables information systems use Establishing the Worthiness of Information Systems Data through Information Engineering

3. The Tool (Planning Sheet) • The planning sheet is used at the information level during the database design aspect of an information system • Adopts the data modeling approach of the planning phase of information engineering • model data to meet the reliability requirement stipulated for the data tables used by an information system • The sheet is used to: • Document the characteristics of data tables of an information system • Ensure that the information system’s data integrity is enforced • Ensure that the user requirement is met Establishing the Worthiness of Information Systems Data through Information Engineering

4. The Tool (Planning Sheet) • Uses both descriptive and problem-solving approach to mark out required rules • These rules are the underlying factor for establishing the reliability and the dependability of data within data tables of an information system • Shows how data integrity constraints are defined for each attribute of relational tables an information system uses • Assists in making an information system reliable • Serves unique and different functions from Normalization process and Entity-Relationship model Establishing the Worthiness of Information Systems Data through Information Engineering

5. A Sample of the Planning Sheet Establishing the Worthiness of Information Systems Data through Information Engineering

6. Implementing Data Integrity For a Data Table Using the Planning Sheet Establishing the Worthiness of Information Systems Data through Information Engineering

7. Information Engineering • Hoffer, Prescott, and McFadden define information engineering as “data-oriented methodology to create and maintain information systems.” They emphasize that within the context of information engineering, data are modeled to meet the needs of the enterprise, not by data usage • In his article, From Data Engineering to Information Enineering, Wiederhold (2004) writes that since information engineering focuses on “information”, dealing with the planning of information requires new engineering concepts if the data used to generate information is to retain its worthiness Establishing the Worthiness of Information Systems Data through Information Engineering

8. Conclusion • The fundamental function of information engineering is finding new ways for creating efficient information systems, including its components such as the database that stores the information system’s data, for improved performance • The fundamental roles of information systems are to generate reliable and dependable information • The second level of the planning phase of information engineering that conforms to the planning sheet focuses on planning, data modeling, and establishing data worthiness for data tables during the database design phase of information systems development • The planning phase of information engineering governs database rules and the authenticity of tables’ data Establishing the Worthiness of Information Systems Data through Information Engineering