Mastry Maltings: Data Modelling

Derrick Neufeld, Alexander Brown, Harsh Soni, Sandeep Jangir

商品編號：W41376
出版日期：2024/05/12
再版日期：
商品來源：
商品主題：Management Science; Information Systems
商品類型：
涵蓋議題：data modelling;database design;data analytics;supply chain optimization
難易度：4 - Undergraduate/MBA
內容長度：3 頁
地域：Canada; United States
產業：Manufacturing
事件年度：2024

Mastry Maltings, founded in 1990 in rural Saskatchewan, Canada, supplies malt to brewers, distillers, and food manufacturers. As the company expands, new regulatory traceability requirements challenge its reliance on Excel spreadsheets for data management. The malting process—from grain procurement to blending—requires detailed documentation for quality control and compliance purposes. This case focuses on designing a scalable data model to track grain lots, malt batches, machinery, operators, and customers while integrating quality control. Students will develop a database system to ensure compliance and efficiency and support business analytics.

教學手冊：Mastry Maltings: Data Modelling - Teaching Note
補充材料：