TAILIEUCHUNG - Lecture Introduction to MIS - Chapter 6: Database management systems

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 .

• PR - Truyền thông
• Introduction to MIS
• Management Information Systems
• Information systems
• Database management systems
• Relational databases
• Database applications
• Organizing the MIS resources
• MIS organization
• International comparisons
• Hệ thống thông tin quản lý
• Technology foundations
• Business trends
• Social interactions
• Social group legitimacy
• Information warfare
• Information technology foundations
• Operating systems
• Hardware components
• Network structure
• Global telecommunications
• Sharing data
• Internet security issues
• Data protection
• Access controls
• Data capture
• Mobile commerce
• Transaction processing
• Integration of Information
• Business integration
• Enterprise resource planning
• Decision support systems
• Data mining
• Geographical information systems
• Complex decisions
• Artificial intelligence
• Building expert systems
• Strategic analysis
• External agents
• E Commerce failures
• Electronic business
• Electronic commerce
• Web advertising
• Systems development
• Building information systems
• Systems development lifecycle
• Hệ thống thông tin
• Lecture Management Information Systems
• MIS impact on society
• Introduction to management information systems
• Business information technology
• One user’s information
• Business school
• Networks telecommunications
• Computer security
• Communication channels