Đang chuẩn bị liên kết để tải về tài liệu:
Lecture Management information systems: Solving business problems with information technology – Chapter 6

In this chapter, students will be able to understand: How do you process the data from transactions and integrate the operations of the organization? How do you efficiently collect transaction data? What are the major elements and risks of a transaction?,. | 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 157.92 602-555-9987 4/4/04 8876 295.53 612-555-4325 4/9/04 8876 132.94 502-555-8876 5/7/04 3345 183.67 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 197.54 87535 James 305-777-2235 Miami 255.93 . | 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 157.92 602-555-9987 4/4/04 8876 295.53 612-555-4325 4/9/04 8876 132.94 502-555-8876 5/7/04 3345 183.67 Orders Table Relational .