Custom Closet Contractors: Making the Database Cut

內容大綱
In the summer of 2017, after completing his third year of business school, a student was eager to apply his newly developed business and technology skill sets at his father’s company during his four-month summer position. His father’s business, Custom Closet Contractors, designed and manufactured custom home organization solutions for home builders and individual clients. In the past year, the successful company’s sales growth had slowed, while expenses as a percentage of sales had increased. The company had experienced operational problems leading to higher expenses, and the student had found that part of the problem was the lack of data organization, which led to miscommunication between the front office and the production staff. To solve the problem, he proposed to design a centralized database and set to work trying to understand the business processes in order to design a data model.
學習目標
This case can is suitable for undergraduate, MBA, or MSc courses in data management as an introduction to data modelling. After completion of this case, students will be able to<ul><li>understand the complications that can arise in business from disorganized information, and how this can be solved through a database solution;</li><li>learn how to break down a description of the business process into data modelling terms, such as entities, attributes, and relationships; and</li><li>learn how to create a data model using Barker’s notation.</li><ul>
涵蓋主題
新增
新增