1 / 11

The Database Environment: Basic Concepts, Organizational Issues and Database Models

The Database Environment: Basic Concepts, Organizational Issues and Database Models. Jason C. H. Chen, Ph.D. Professor of MIS School of Business Administration Gonzaga University Spokane, WA 99258 chen@jepson.gonzaga.edu. Events. New State. Transactions. (Add, modify, delete, …). D.B.

herbst
Télécharger la présentation

The Database Environment: Basic Concepts, Organizational Issues and Database Models

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. The Database Environment:Basic Concepts, Organizational Issues and Database Models Jason C. H. Chen, Ph.D. Professor of MIS School of Business Administration Gonzaga University Spokane, WA 99258 chen@jepson.gonzaga.edu

  2. Events New State Transactions (Add, modify, delete, …) D.B. Correspond with the processing of the events User A Relationship Between the Organization and the DataBase Organizational IS Resources: Picture Or Model Old State Activities 1. Hardware 2. Software 3. Data 4. Procedures 5. People DataBase Management Systems Information must be: 1. Time: Timely, 2. Content: Accurate, relevant, and verifiable. 3. Form: Presented in a useable form. TM 0-2

  3. A Relationship Between the Organization and the DataBase Organizational IS Resources: 1. Hardware 2. Software 3. Data 4. Procedures 5. People Picture Or Model Old State Activities Events New State DataBase Management Systems Transactions (Add, modify, delete, …) D.B. Correspond with the processing of the events Information must be: 1. Time: Timely, 2. Content: Accurate, relevant, and verifiable. 3. Form: Presented in a useable form. User TM 0-3

  4. DATA What is Information ? INFORMATION Information is refined data.

  5. Data vs. Information • Users really want is • Information • What users can learn from the data • how to satisfy their best customers • how to allocate their resources most efficiently, • how to minimize losses

  6. Are they Data Bases? • MS/Access, MS/SQL Server • ORACLE • IBM/DB2 • etc. Why don’t we just create a huge data file contain ALL fields?

  7. What Is a Database and DBMS? • A database is an organized collection of logically related and integrated data files. • Models real-world enterprise. • Entities (e.g., students, courses) • Relationships (e.g. Scott is taking bmis441) • A Database Management System (DBMS)is a software package designed to store and manage databases.

  8. Objectives of the MIS who has whatinformation about whom and when, where, and how will all be decided in the process of building an information system. Deliver the right information to the right people, at the right time, with the right form. Ultimately, MIS should improve the workers’ productivity.

  9. ? Why Study Databases?? • Shift from computation to information • Datasets increasing in diversity and volume. • Digital libraries, interactive video, Human Genome project • ... need for DBMS exploding • DBMS encompasses many business applications • These days, practically everything is built around a database. • If you understand how databases work, you understand how a lot of business function

  10. CUSTOMER ORDER Data Models • A data modelis a collection of concepts for describing data. • Three database models • Hierarchical • Network • Relational

  11. Comparison of Three Database Models TM 0-11

More Related