tailieunhanh - 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 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 .

• Thương mại điện tử
• Management Information Systems
• Information Systems
• Hệ thống thông tin
• Lecture Management Information Systems
• Hệ thống thông tin quản lý
• Enterprise resource planning
• Hoạch định nguồn lực doanh nghiệp
• Information system
• Business processes
• Enterprise Resource Planning systems
• ERP software
• Enterprise resource
• Management accounting change
• Transitional country
• Management accounting rules
• Summary and conclusions
• Manufacturing planning
• Control for supply chain management
• Supply chain management
• Transaction processing
• Performance metrics
• Theoretical framework
• Extra organisational institutions
• In cloud enterprise resources planning
• Access control authentication
• Network security
• Virtual network
• Enterprise resources planning
• EPR
• hệ thống
• hoạch định nguồn nhân lực
• doanh nghiệp
• kỹ năng mềm
• kỹ năng quản lý
• quản trị nhân sự
• Accounting information systems
• Lecture Accounting information systems
• Hệ thống thông tin kế toán
• ERP Enterprise resource planning
• Mô hình ERP
• Thành phần của ERP
• Chức năng của ERP
• Xu hướng sử dụng ERP
• Ưu điểm của ERP
• Business functions
• Data requirements
• Marketing Information Systems
• Production Information Systems
• Accounting in ERP Systems
• Financial accounting
• Human Resources Processes
• Human Resources Department
• Process modeling
• Flowcharting process models
• Electronic Commerce
• Electronic Commerce Background
• Bộ phận chính trong doanh nghiệp
• Bộ phận chức năng
• Hệ thống ERP
• Hệ thống thông tin doanh nghiệp
• Mô hình doanh nghiệp
• Công ty Fitter Snacker giả định
• Sales process
• Hệ thống thông tin Sales
• Hệ thống thông tin Marketing
• Hệ thống thông tin quản lý sản xuất
• Chuỗi cung ứng
• Kế hoạch sản xuất
• Kế hoạch quản lý chuỗi cung ứng
• Lưu đồ hóa quy trình
• Quy trình kinh doanh
• Quy trình chi phí Fitter Snacker
• Biểu đồ Event Process Chain
• Thương mại điện tử
• Journal of Science and Technology
• Higher education institution
• Critical success factors
• Summary of PhD thesis
• Applications of enterprise resource planning
• Retail enterprises in the world
• Context of competition
• Innovation growth model
• Financial ratio analysis
• Business process reengineering
• Organizational change management
• Empirical case of Taiwan
• Success of ERP implementation
• Development of ERP system
• Software packages for ERP implementation
• Training and technological complexity