Question: Case #2: Database Management System Implementation at Salala Juices Ltd, Oman Salala Juices Ltd, a well-established juice brand with five factories across GCC countries, has

Case #2: Database Management System Implementation at Salala Juices Ltd, Oman Salala Juices Ltd, a well-established juice brand with five factories across GCC countries, has been a regional favorite since its inception in 1990. The onset of the COVID-19 pandemic brought about a remarkable 53% surge in product sales, driven primarily by partnerships with food delivery giants like Akeed and Talabat. However, this surge in demand has ushered in heightened competition and amplified challenges in effectively managing the company's business processes and operations. One particularly pressing issue revolves around the handling of data, which has become increasingly burdensome and resource-intensive. Salala Juices lacks a structured mechanism for capturing, storing, processing, and visualizing data, especially data originating from a multitude of manual and automated sources. As the company engages with numerous individual and corporate customers, suppliers, and distribution partners, the volume of generated data has skyrocketed. The company currently struggles to harness this data efficiently to derive meaningful insights. To address this data management crisis, the senior management at Salala Juices has initiated a search for proposals from IT consulting firms to design and implement a comprehensive database management system. In your capacity as the lead consultant from OMine Data, an Omani IT solutions company specializing in database solutions, you are tasked with presenting your proposal to the Salala Juices management team. Subsequent to your presentation, the following questions have arisen from the participants:

Question 1: List down and provide brief descriptions of at least three software or tools suitable for designing and developing the database system for Salala Juices.

Question 2: In light of the current circumstances, explain three key advantages that your proposed solution will deliver to Salala Juices.

Question 3: Provide four crucial entities, each with a minimum of four attributes (including one primary key) for the proposed database. Additionally, describe the relationships among these entities.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!