Minor SQL database design
Budget: $30 – $250 AUD
Part A: a complete database design and development project through SQL for a real-world
business case
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)
Part B: a written report to address the business concerns by data analytics tools
Task Details.
business case
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)
Part B: a written report to address the business concerns by data analytics tools
Task Details.