32113: Advanced Database - SQL Query - IT Computer Science Assignment Help

Assignment Task

This assessment addresses the following objectives:

• Objective 1: Identify corporate data resources and their value for modern business.
• Objective 2: Explain database technologies for managing and supporting corporate data resources;
• Objective 3: To be able to evaluate advantages and disadvantages of database technologies and their applicability in different business situations;
• Objective 4: To develop an understanding of data exploration methods and tools and their role in discovering knowledge locked in historical corporate data;
• Objective 5: To improve your ability to communicate in the form of technical reports and presentations;

TASK

• Design a relational schema that meets the CEO’s requirements.

• Provide SQL queries which run against your designed model.

• Provide explanations to the your queries.

Description of Tasks:

JD Hub is a national retailer company specialized in selling electronics products. The CEO of JD Hub wants to increase their sales on Boxing Day. This year (2022), he plans to give more discounts to the electronics products that were the most sold on the Boxing Days of recent years. He would like to try NSW shops as a trial for this year, before rolling out to all states in future.

The CEO asks you to find out the top 9 electronics products that are the best sold in quantity on Boxing Days over all the past five years in NSW.

• Provide a star schama to show your physical desgin. Explain what your facts, measures, and dimensions are, and how they are linked with each other.

• Produce a query which can be executed on your star schema and addresses the CEO’s requirement (5 Marks). Provide explanations to your query regarding its logic.

This 32113-IT Computer Science Assignment has been solved by our IT Computer Science 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 Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.