ICT211 - Database Design - Growing Sunshine Organics Case Study - IT Assignment Help

Assignment Task

Growing Sunshine Organics

Background

Phoebe Hunt grew up on the Sunshine Coast, on her family’s Avocado farm. On completion of her Business degree, Phoebe realised that her business management knowledge could be applied within the Queensland horticultural industry. Queensland horticulture is worth almost $3 billion per year and is Queensland’s second largest primary industry.

Phoebe’s passion for the land led her back to the Sunshine Coast where she invested in an organic fruit and vegetable farm and started trading as Sunshine Organics. Initially, Phoebe’s business plan was directed at farm fresh organics for the home delivery market but subsequently expanded to cater to the needs of the local restaurant market. There was increasingly high demand for organic fruit and vegetables, so Phoebe sourced other local producers and started to market their produce alongside her own.

Sunshine Organics ensured that their producers were paid well for their products and as a result, they have a waiting list of organic fruit and vegetable farmers who would like to become suppliers. The organisation had been growing well at around 8% per year. However, during the Covid 19 pandemic in 2020, sales to the local restaurant market slowed, so Phoebe Hunt increased advertising through social media to extend the home delivery market and started to consider how she could diversify. One of her ideas was to build a small number of cabins on her property.

The cabins could then be used for accommodation and weekend workshops at which people could learn about growing their own organic produce. To trial the idea Phoebe invested in three cabins, two one-bedroom cabins and one two-bedroom cabin. During the autumn and winter of 2020, the demand for Sunshine Organics products to the home delivery market increased dramatically.

This was particularly evident while lockdown restrictions were being enforced. As a result, Phoebe took the opportunity to leave flyers advertising her workshops and cabins in every box of produce that was delivered. The response was outstanding. With people unable to take their usual holiday breaks and travel restricted (initially inter-State and to date outside Australia), interest in taking short breaks while learning a new skill in a new environment, flourished. From the moment Phoebe opened her new venture, her cabins and workshops have been fully booked.

The cabins being popular with workshop attendees travelling from further afield and with people looking for a short break in a rural environment.

User Requirements

A joint agreement was formed to design and implement the following core system requirements as the first phase of the GSO database project:

• It has been agreed that the core database entities are likely to be the members of GSO, cabin suppliers, cabin types and cabin orders. However, you also know that this may change as there will be other regular and composite entities, and business rules which will determine the entity relationships.

• GSO members will have a unique member id, a member name, a contact name, a date when they joined the group and an end date (should they leave the group – it will be left blank by default), the name of their business, its address, phone number, and email address and a member description where they can describe their business.

• A cabin supplier will have a unique id. A contact name, the name of the business, its address, phone number, and email address and a short description of the business will also be recorded. Each cabin supplier may supply many types of cabin, some cabin suppliers may supply the same types of cabin.

This ICT211 - IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.