1 / 20

Chapter 11&12: Database Management System & Information Systems

Chapter 11&12: Database Management System & Information Systems. Introduction to Databases. Like a library, secondary storage is designed to store information End users need to understand How such stored information is organized using data field, records, files and databases

richardb
Download Presentation

Chapter 11&12: Database Management System & Information Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related