ITECH2004: Data Modelling - Structured Query Language - IT Assignment Help

Assignment Task:

Overview 

The purpose of this task is to develop student’s skills in designing and implementing a relational database for a given case study. 

Learning Outcomes Assessed 

The following course learning outcomes are assessed by completing this assessment: 

K5. Describe relational algebra and its relationship to Structured Query Language (SQL).

S1. Interpret entity-relationship diagrams to implement a relational database.

S2. Demonstrate skills in designing and building a database application using a commercially available database management system development tool.

S3. Use a query language for data manipulation.

A1. Design and implement a relational database using a database management system.

A2. Utilise a query language tools and techniques to obtain data and information from a database. 

Assessment Details 

Background 

Major League Soccer (MLS)1 is a men's professional soccer league played in the United States. It is equivalent to European (and South American) football. The league comprises 24 teams — 21 in the U.S. and 3 in Canada. 

There are many games played in each season by many teams. You can find the details of the team names and home locations listed at this Wikipedia page: 

You are part of a SPORTS PERFORMANCE team and you currently gather the following information: 

- Video footage of each game – several frames per second, and recorded and stored in MP4 format. 

- GPS tracklogs of each player for each game, including the three referee staff, and even the location of the ball 

- Transcription of the “gameplay” by professional auditors, who have recorded all the important events during a game: when a pass was made, and between which people; whether there was a tackle; shots on goal; corners; fouls and any resultant cards; and so on. 

You have been tasked to start analysing this data, and the following SQL commands are a mixture of preprocessing and the beginnings of some useful statistics.

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