Commerce 2ka3 Test Bank | RECOMMENDED | Solution |

Course Focus: How organizations use information systems to achieve operational excellence, customer intimacy, decision making, and competitive advantage.

The Golden Rule: If the file claims to contain questions from next week’s exam, do not open it. If it contains review questions for Chapter 6, it is a study tool.

This is the highest-fail area. Questions focus on relational databases, primary/foreign keys, SQL basics, and data warehousing. Commerce 2ka3 Test Bank

Tests synthesis, strategic thinking, and real-world application.

Question 9 (20 points)

Background: "FreshGrocery" is a regional supermarket chain. They face competition from Walmart (low prices) and Whole Foods (premium fresh). They choose a Focused Differentiation strategy: "Organic & local produce delivered within 2 hours."

Part A (6 points): Using Porter’s Value Chain, identify two primary activities and one support activity that FreshGrocery must excel at. For each, specify an information system feature they would need. Course Focus: How organizations use information systems to

Part B (6 points): FreshGrocery launches a mobile app. Describe one competitive advantage gained and one potential threat introduced from the perspective of Porter’s Five Forces.

Part C (8 points): The VP of Marketing wants to send a $5 coupon to any customer who has not opened the app in 14 days but has purchased organic milk in the past. Write the pseudo-SQL query logic (SELECT...FROM...WHERE) OR draw the logic flow a DSS would use to generate this list. This is the highest-fail area