Chapter 11&12: Database Management System & Information Systems

1. Chapter 11&12: Database Management System&Information Systems

2. Introduction to Databases • Like a library, secondary storageis designed to store information • End users need to understand • How such stored information is organized using data field, records, files and databases • The different types of databasesand structures • Competent end users need to be able to find information that is stored in databases

3. Data • Examples of data include • Facts or observations about people, places, things, and events • Audio, music, photographs, and video • Two ways to view data • Physical view • Logical view

4. Data Organization • Character • Field • Record • File • Table • Database • Key Field • Batch Versus Real-Time Processing

5. Key Field • Unique identifier also known as primary field • Common examples • Social Security Number • Student Identification Numbers • Employee Identification Numbers • Part Numbers • Inventory Numbers

6. Batch Processing • Batch processing • Data is collected over a period of time and the processing happens later all at one time

7. Real-Time Processing • Real-time processing • Also known as online processing because it happens immediately during the transaction

8. Databases • Collection of integrated data • Logically related files and records • Databases address data redundancyand data integrity • Need for databases • Database management

9. Need for Databases • Sharing • Security • Less dataredundancy • Data integrity

10. Database Management • DBMS engine • Data definitionsubsystem • Data dictionary • Data manipulationsubsystem • Query-by-example • Structured query language (SQL) • Application generation subsystem • Data administration subsystem

11. DBMS Structure • DBMS programs are designed to work with data that is logically structured or arranged • Data models define rules and standards for data in a database • Five common data models are • Hierarchical database • Network database • Relational database • Multidimensional database • Object-oriented database

12. Hierarchical Database • Fields or records are structured in nodes • Nodes are points connected like branches • One parent per node; a parent has severalchild nodes (one-to-many relationship) Return

13. Network Database • Hierarchical node arrangement • Each child node may have more than one parent node (many-to-many relationship) • Additional nodes are called pointers • Nodes can be reached through multiple paths Return

14. Relational Database • Data stored in table called a relation • Tables consist of rows and columns • Tables related via a common data item Return

15. Information Systems

16. Organizational Information Flow • Information flows vertically and horizontally throughout an organization • Information systems support the natural flow of information within an organization’s structure • 5 Functional Areas • Management Levels • Information Flow

17. Five Functions of an Organization • Accounting • Marketing • Human Resources • Production • Research Return

18. Management Levels • Management is usually divided into three levels: Top, Middle, and Supervisors Return

19. Information Flow (1 of 2) • Each level of management has different information needs • The information flows to support these needs • Top management • Vertical, horizontal, and external • Middle management • Vertical and horizontal • Supervisor • Primarily vertical Return

20. Information Flow (Page 2 of 2) Return