The assignment requires students to design and develop a complete SQL database for a real-world business case involving Pro App, a sharing economy platform. It consists of two parts: creating a database with an ER diagram, SQL implementation, and dummy data, and preparing a data analytics report addressing business concerns for the COO. The deadline for submission is 5 pm on October 4, 2024, and the assignment is valued at 30% of the overall grade.
The assignment requires students to design and develop a complete SQL database for a real-world business case involving Pro App, a sharing economy platform. It consists of two parts: creating a database with an ER diagram, SQL implementation, and dummy data, and preparing a data analytics report addressing business concerns for the COO. The deadline for submission is 5 pm on October 4, 2024, and the assignment is valued at 30% of the overall grade.
The assignment requires students to design and develop a complete SQL database for a real-world business case involving Pro App, a sharing economy platform. It consists of two parts: creating a database with an ER diagram, SQL implementation, and dummy data, and preparing a data analytics report addressing business concerns for the COO. The deadline for submission is 5 pm on October 4, 2024, and the assignment is valued at 30% of the overall grade.
The assignment requires students to design and develop a complete SQL database for a real-world business case involving Pro App, a sharing economy platform. It consists of two parts: creating a database with an ER diagram, SQL implementation, and dummy data, and preparing a data analytics report addressing business concerns for the COO. The deadline for submission is 5 pm on October 4, 2024, and the assignment is valued at 30% of the overall grade.
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: 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 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 with the job assignment of a Business Analyst.
Extending Dynamics 365 Finance and Operations Apps with Power Platform: Integrate Power Platform solutions to maximize the efficiency of your Finance & Operations projects
