Short Case Study: Green Grocers

"Green Grocers" is a small retail company that specialises in selling organic fruits and vegetables. Currently, they use spreadsheets to manually handle their supplier information, sales, and inventories. They are, however, aiming to move to a database$-$driven inventory management system due to growing demand and complexity.

Subsequently, Green Grocers made the decision to put in place a database$-$driven inventory management system in order to increase the accuracy and efficiency of their inventory management. They have to specify the design and structure of the database as part of the implementation phase.

Required:

$4\mathrm{.}1$

What are the four $(4)$ potential benefits of implementing a database system for Green Grocers? $(4$ Marks$)$

$4\mathrm{.}2$

Discuss the importance of data integrity in the context of Green Grocers' inventory management system. $(4$ Marks$)$

$4\mathrm{.}3$

Describe the steps involved in transitioning Green Grocers from manual record$-$keeping to a database$-$driven inventory management system. $(10$ Marks$)$

$4\mathrm{.}4$

Discuss the potential risks associated with the implementation of a database$-$driven inventory management system for Green Grocers and propose mitigation strategies. $(8$ Marks$)$

Page $6$ of $6$

$4\mathrm{.}5$

Identify and explain at least three essential tables that should be included in Green Grocers' database structure for inventory management. $(9$ Marks$)$

$4\mathrm{.}6$

Discuss the importance of establishing relationships between tables in Green Grocers' database and propose at least two relationships that should be implemented. $(6$