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 business analytics tools

Deadline: 5 pm, Friday, 4 October 2024

Value: 30% (Part A 20 marks, Part B 10 marks)

Task Details:

1. Please create a (one) database by SQL from the following case. Your database is required to include:
   1. a complete ER diagram using Chen’s notation (8 marks)
   2. a complete database project using SQL to construct and implement (8 marks)
   3. 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 given case. 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

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