BUSA8090 Assignment 1- Practical coding assignment using SQL Submission: Individual submission to iLearn Part A: a complete database design and development project through SQL for a real-world business case Part B: a written report to address the business concerns by data analytics tools Deadline: 5 pm, 27 April 2022 Value: 30% (Part A 20 marks, Part B 10 marks) Task Details: 1. Please choose to create a (one) database by SQL from the following two cases. Your database is required to include a. a complete ER diagram using Chen’s notation (8 marks) b. a complete database project using SQL to construct and implement (8 marks) c. a sufficient amount of dummy data integrated with the designed database for data retrieving and further data analytics (4 marks) 2. You are preparing a data analytics report as a data analyst to the Chief Operating Officer of the selected organization. The Chief Operating Officer would like to shed the light on minimizing the overhead of managing newly registered users of the online platform. The database designed by you would perfectly serve the purpose of managing users in a more productive way. On the other hand, the user data also provides insightful ideas to resolve business issues. Please propose 5-10 potential organizational issues that impact the COO’S decision-making process and formulate the appropriate SQL quires to support your “guesswork”. The SQL quires are required to be included in the database design package. A written report will contain the explanation of how the database was created, the elaborations of how the quires were selected and formulated, and suggestions of the return results – no word limit. (10 marks) Case Study A Easy Care Gardening seeks to help aged people and eligible people with disabilities, to stay in their own homes and retain independence by providing gardening services, lawn mowing services and lawn mowing subsidies. Gardens can be great therapy. Many studies suggest that the psychological benefits of gardening for older adults are enormous, and they transcend socioeconomic, educational and cultural boundaries. ECG organization is not-for- profit. The gardeners are all volunteers. Please refer to the link below: https://www.easycaregardening.org.au/volunteers/ to acquire more information about what we do and how to become a volunteer. It is always a headache to manage the volunteers enrolment and to easily access schedules and book themselves into gardens and date. Please create a databased for the current website and help to resolve the business problems above. Case Study B Pro App is a newly founded, Australia and Indonesia based sharing economy platform, currently seeking Series A funding in southeast Asia and Australia. It aims at providing the premium and customized offline services to satisfy local communities to outsource everyday tasks. Customers describe the task and indicate a budget, community members then bid to complete the task. Pro App resembles Airtasker very closely. Students are required to conduct research on such company with the company prospectus attached, and to come up with a detailed database for the app to manage all different types of users associated with the job assignment of a Data Analyst.