In this chapter, students will be able to understand: The importance of high-quality information and issues involved in managing business data; advantages of the database approach; data modeling and database design with entity relationship diagram (ERD); how organizations can maximize their strategic potential with databases : data warehouse, data marts, data mining, business intelligence. | INFORMATION AND DATABASES Part 1 LEARNING OBJECTIVES The importance of high-quality information and issues involved in managing business data. Advantages of the Database approach. Data Modeling and Database Design with Entity Relationship Diagram (ERD) How organizations can maximize their strategic potential with databases : Data Warehouse, Data Marts, Data Mining, Business Intelligence Levels, Formats & Granularities of Information This is a good place to discuss the Samsung Electronics and Staples examples from the text Students should understand that information varies and different levels, formats, and granularities of information can be found throughout an organization Levels Formats Granularities Information granularity – refers to the extent of detail within the information (fine and detailed or coarse and abstract) CLASSROOM EXERCISE Organizing Information Break your students into groups and assign each group a different information type from Figure Ask the students to find examples of the different kinds of information they might encounter in an organization for their information type For example, information formats for a spreadsheet might include a profit and loss statement or a market analysis Ask your students to determine potential issues that might arise from having different types of information Ask your students what happens if the information does not correlate For example, the customer letters sent out do not match the customers and customer addresses in the database For example, the total on the customer’s bill does not add up to the individual line items Information Type: Transactional And Analytical Organizations capture and store transactional information in databases and use it when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules Transactional information examples include withdrawing cash from an ATM, making an airline reservation, purchasing stocks Compile a | INFORMATION AND DATABASES Part 1 LEARNING OBJECTIVES The importance of high-quality information and issues involved in managing business data. Advantages of the Database approach. Data Modeling and Database Design with Entity Relationship Diagram (ERD) How organizations can maximize their strategic potential with databases : Data Warehouse, Data Marts, Data Mining, Business Intelligence Levels, Formats & Granularities of Information This is a good place to discuss the Samsung Electronics and Staples examples from the text Students should understand that information varies and different levels, formats, and granularities of information can be found throughout an organization Levels Formats Granularities Information granularity – refers to the extent of detail within the information (fine and detailed or coarse and abstract) CLASSROOM EXERCISE Organizing Information Break your students into groups and assign each group a different information type from Figure Ask the students
