CSYM017 : The Provided E-Commerce Dataset - Report Writing - IT Assignment Help

Assignment Task:

Task:

Learning Outcomes Assessed:
LO1 Critical thinking: evaluate ideas and concepts.
LO2 Professional communication: communicate effectively in a variety of situations with different audiences including via electronic media, including face-to-face group discussions, software demonstrations requiring technical knowledge and language, walkthrough sessions etc.

Introduction
This assignment is compulsory as it is the only formal assessment for this module. Read this document carefully and make sure that you are clear about what to do and what to submit before you attempt the assignment.

Assignment work

Learning diary (50%)
Students are expected to log their learning activities (e.g., lab tasks and extra work) in the diary; there should also be some reflection on the activities, including (but not limited to) the issues/challenges, approaches to address the issues, what worked and what didn’t and why, what have been learnt, etc. You should summarise your understanding of the topics that have been practiced using your own words. It’s a good idea to take screenshots of the tasks, issues, the solution and outcomes. Do not simply copy and paste any existing contents from lecture notes, the Internet, etc.

Assignment tasks (50%): Students need to work on the given tasks and submit a single report that documents the solutions of the two tasks.

Students are expected to look at the provided e-commerce dataset, which is about one- week of some e-commerce activities (from 1st December to 8th December 2010) to carefully design both a relational model and a graphical model based on the contents of the dataset, and to implement into a relational database and graph database for the queries. In the report, students need to include 1) both models with good explanation/justification, 2) the detailed process of database creation and 3) carefully designed SQL and Cypher commands to answer the following queries.

• How many customers are from the United Kingdom?
• Which product is the most popular one (i.e., most customers purchased it)?
• Which customer spent the most money?
• Display the customer who placed orders in the most consecutive calendar months?
• What did the customers buy before and after they bought the most popular product?

In addition to that, students are expected to include in the report a detailed comparison/reflection of the two solutions to demonstrate their understanding of the relational and graphical approaches. It might be a good idea to refer to some of the work in the report to support your statement/conclusion.

What you should submit

Students are expected to submit ONE report on NILE (in the format of MS word or PDF, use your student id as the file name of your report). In the body of the report, students are expected to properly document the assignment tasks; and the learning diary should be attached to the report as an appendix.

The report needs to be properly structured to allow easy reading (e.g., table of contents, sections/subsections with page numbers, etc); Wherever appropriate, you should have references in Harvard reference style.

Demo: students are required to submit a 10-minute video demo, which is COMPULSORY and should at least include the following: analysis of the dataset, design of both of the relational and graphical models, process of creation of the two databases and explanation of the query solutions. Failure in submission of the video demo will automatically result in a ‘Fail’. Students need upload the demo video, e in their own area of the internal storage (gallery) video.northampton.ac.uk; please use the default ‘Unlisted’ setting so that the uploaded video can be viewed by the marker. The link to the demo video should be on the front sheet of the assignment report. The module tutor reserves the right to invite students to a meeting to discuss coursework submissions.

What will be assessed

• Learning diary (quantity and quality of exercises, reflective comments)
• The assignment tasks (complexity of work and quality of solution)
• Assessment of the report will be based on the contents, format and quality of academic writing.
• The quality of demo and confidence in explaining own work.

This CSYM017 : IT Assignment has been solved by our IT Experts at My Uni Papers. 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 Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.