In this chapter, we will address the following questions: Why is a DBMS a good way to store data? How do you construct a query? What types of computation can a DBMS perform? How do you join multiple tables with a query? How are reports different from queries? What database administration tasks need to be performed? What tasks are better suited to a DBMS than to a spreadsheet? How are databases used in e-business? | Introduction to MIS Chapter 6 Database Management Systems Database Management Systems Database DBMS Programs Sales and transaction data Reports and ad hoc queries Outline Relational Databases Queries Designing a Database Database Applications Database Administration Database and e-Business Cases: Airlines Appendix: Building Forms in Access DBMS & People 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 Phone Name Address City 312-555-1234 Jones 123 Main Chicago 502-555-8876 Smith 456 Oak Glasgow 602-555-9987 Juarez 887 Ribera Phoenix 612-555-4325 Olsen 465 Thor Minneapolis Customer Table Customer Date Salesperson Total_sale 502-555-8876 3/3/04 2223 602-555-9987 4/4/04 8876 612-555-4325 4/9/04 8876 502-555-8876 5/7/04 3345 Orders Table Relational Databases Tables Rows Columns Primary keys Data types Text Dates & times Numbers Objects Invoice Program Billing Program file 1 customers file A file B Programming Approach Problems with Programming Data and programs Undocumented files Files & many programs Multiuser Changes 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 1) What output do you want to see? 2) What tables are involved? 3) What do you already know? (constraints) 4) How are the tables joined? Four questions to create a query Database Queries Single Table Computations Joining Tables Single Table Query Introduction CID Name Phone City AccountBalance 28764 Adamz 602-999-2539 Phoenix 87535 James 305-777-2235 Miami . | Introduction to MIS Chapter 6 Database Management Systems Database Management Systems Database DBMS Programs Sales and transaction data Reports and ad hoc queries Outline Relational Databases Queries Designing a Database Database Applications Database Administration Database and e-Business Cases: Airlines Appendix: Building Forms in Access DBMS & People 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 Phone Name Address City 312-555-1234 Jones 123 Main Chicago 502-555-8876 Smith 456 Oak Glasgow 602-555-9987 Juarez 887 Ribera Phoenix 612-555-4325 Olsen 465 Thor Minneapolis Customer Table Customer Date Salesperson Total_sale 502-555-8876 3/3/04 2223 602-555-9987 4/4/04 8876 612-555-4325 4/9/04 8876 502-555-8876 5/7/04 3345 Orders Table Relational .
