Foxcore Retail (A): Designing a Database
On April 2, 2017, the two founders of Foxcore Retail were preparing for a third summer managing their small retail business in Ontario, Canada. They had spent the weekend reviewing budgeting, staffing schedules, and inventory planning for their biggest expansion to date. There was only one pressing concern that had not been solved. In the past, employees had tracked sales by hand, on paper, which led to headaches when it came to calculating sales representatives' commissions. Additionally, the two partners knew that by not documenting key information about each sale, they were missing the opportunity to collect valuable data that could provide insight into the performance of employees, events, and products. As the business grew, they were starting to notice the impact of these inefficiencies on customer service, and it was clear that this was the right time to implement a more disciplined database system.