BISM7206: Information Retrieval and Management - Queensland Organics Description and Specifications Case Study - Management Assignment Help

Assignment Task :

Purpose 

This document provides the case study and assignment specifications for the assessment Item 2 - “Case Study: Database analysis, design and development”. After you have read the following case study description and assignment specifications, you should refer to the associated Database Design Case Study Formatting and Submission Requirements document. If you have any questions after you have read both of these documents, please post your questions to the Discussion Board under the relevant forum ‘Assessment Item 2 - Case study’. 

Background 

Sarah James grew up on the Atherton Tablelands in far north Queensland on her family’s Avocado farm. On completion of her Business degree, Sarah 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. Sarah’s passion for the land and the subtropical climate led her back to the Atherton Tablelands where she invested in an organic fruit and vegetable farm and started trading as Atherton Organics Ltd. 

Initially, Sarah’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 both locally and nationally. Similarly, there was a growing number of Queensland suppliers interested in joining the co- op. Sarah decided to form a Queensland based cooperative that would provide a common platform to promote the supply of organically grown fruit and vegetables and a central marketplace for customers throughout Australia. The newly formed co-op was renamed to Queensland Organics (QO). 

Prior to establishing QO, Sarah’s business relied primarily on spreadsheets to keep track of her produce, expenditure, orders and invoices. This system was proving to be inadequate for the growing and somewhat complex needs of QO. To address these needs, Sarah enlisted the help of a local web developer (Jack) to build a common web platform for QO. Jack did a great job and Sarah was very pleased with the new QO website. It was intuitive to navigate and provided helpful information for customers as well as the basic functionality that enabled processing and recording customer purchases and co-op member supplies. The QO website also provided a platform for its members to collaborate and share ideas online with their community. 

Part A: Database Analysis and Design 

The first part of this assignment requires you to analyse the database requirements and design the first phase of the database project in accordance with the case study background and requirements. The following documentation is required to be submitted as a MS Word Document: 

• Entity Relationship Diagram using Crows Foot Notation (preferably using draw.io); 

• Relational Schema - including Primary and Foreign Keys (preferably using draw.io); 

• Supplementary Design Requirements formatted as a data dictionary. The following information can be used as a guide for the elements to be included: 

• Table names and their data attributes and descriptions; o Information on data type, length, format, acceptable values;
•  The compulsory/optional nature of the attribute and if nulls are valid. 

• Assumptions 

This Management Assignment has been solved by our Management 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.