Upon completion of this lesson, the successful participant will be able to understand: How do you store and retrieve the vast amount of data collected in a modern company? Why is the database management approach so important to business? How do you write questions for the DBMS to obtain data?,. | Introduction to MIS Technology Toolbox: Creating Forms in Access Technology Toolbox: Creating Database Reports Cases: Pharmaceutical Industry Chapter 4 Database Management Systems Jerry Post 1 Outline How do you store and retrieve the vast amount of data collected in a modern company? Why is the database management approach so important to business? How do you write questions for the DBMS to obtain data? How do you create a new database? How do you create business applications using a DBMS? What tasks need to be performed to keep a database running? Why are databases so important in e-business? How are databases used in cloud computing? 2 Database Management Systems Database DBMS Programs Sales and transaction data Reports and ad hoc queries Central Role of DBMS Data Database Management System Program Program Business Operations Ad Hoc Queries and Reports Programmer Analyst Database Administrator Business Needs Programs & Revisions Managers (Standards, Design, and Control) Data Collection and Transaction Processing 4 Customer Table Sales Table Relational Databases Tables Rows Columns Primary keys Data types Text Dates & times Numbers Objects CustomerID Name Address City 12345 Jones 125 Elm Chicago 28764 Adamz 938 Main Phoenix 29587 Smitz 523 Oak Seattle 33352 Sanchez 999 Pine Denver 44453 Kolke 909 West Denver 87535 James 374 Main Miami SaleID CustomerID Date Salesperson 117 12345 3/3/12 887 125 87535 4/4/12 663 157 12345 4/9/12 554 169 29587 5/6/12 255 5 All Data Files Database Management System Invoice Program Billing Program Database Advantages Focus on data Stable data Programs change. Data independence Change programs without altering data. Data integrity Accuracy. Time. Concurrency. Security. Ad hoc queries Speed of development Report writers. Input forms. Data manipulation. Flexibility & Queries 6 Data Quality: Concurrent Access Transaction A Customer Accounts Sanchez: Balance Transaction B 1) Receive 300 payment 2) Read Balance (500) Sanchez: 500 3) New . | Introduction to MIS Technology Toolbox: Creating Forms in Access Technology Toolbox: Creating Database Reports Cases: Pharmaceutical Industry Chapter 4 Database Management Systems Jerry Post 1 Outline How do you store and retrieve the vast amount of data collected in a modern company? Why is the database management approach so important to business? How do you write questions for the DBMS to obtain data? How do you create a new database? How do you create business applications using a DBMS? What tasks need to be performed to keep a database running? Why are databases so important in e-business? How are databases used in cloud computing? 2 Database Management Systems Database DBMS Programs Sales and transaction data Reports and ad hoc queries Central Role of DBMS Data Database Management System Program Program Business Operations Ad Hoc Queries and Reports Programmer Analyst Database Administrator Business Needs Programs & Revisions Managers (Standards, Design, and Control) Data .
