ITECH 2004: Data Modelling - ER Model & Relational Schema - IT Assignment Help

Assignment Task:

Learning Outcomes

The following course learning outcomes are assessed by completing this assessment:
K4. Design a relational database for a provided scenario utilizing tools and techniques including ER diagrams, relation models and normalization.
K5. Describe relational algebra and its relationship to Structured Query Language (SQL).
A1. Design and implement a relational database using a database management system.

Assessment Details

You have been commissioned to create a database for a data mining project related to mobility using GPS tracklogs. Very large “trajectory” datasets are increasingly available due to the proliferation of positioning sensors and location-based services. However, successful integration of mobility data still requires the development of conceptual and database frameworks that will support appropriate data representation and manipulation capabilities. GPS tracklogs come in many different kinds of formats, for instance, GPX1 or NMEA2 files. These formats can support simple descriptive statistics such as: distance travelled, average speed, time in motion vs. time stationery, elimination of stationary segments. However, there are very few data mining algorithms or libraries that can be used on this kind of file. Additionally, when processing GPX files often there may have been added custom extensions to deal with related to the domain, for instance, data like heart rate, cadence, power, and so on. It is important to understand the difference between the raw data from the GPS device, the track log in GPX/NMEA, and a “route”, often called a semantic trajectory. A route is derived from the track and contains meaning, or semantic tags. For instance, there will now be a start and end to the route, specific places that have been visited, and so on. This is in contrast to the raw data which is merely a time-based sequence of geographical coordinates. The tracklog has been “processed” or “transformed” into the route.

The minimum entities you are expected to have are listed below:

Each Track will have a unique ID, a name, a date and location, and will be comprised of multiple Points.

Each Point will have a Latitude, Longitude, Date and Time.
There will be many types of File Format, including the original “raw data” format of either GPX or NMEA, and transformed formats of Shapefile, LineString, GML, RDF and so on.

Transformations are used to change from one file format to another.

• There are many Algorithms possible, some simple (e.g. descriptive statistics, preprocessing), and some complex (e.g. data mining, semantic operations), but all will have Results Results can be simple values (calculation of average Speed, distance travelled), a complex value (series of Points that constitute a cluster), or even a geometry (a derived line segment or polygon that represents an area of significance). A Result will reference in some way the file and algorithm from which it is derived. It should also have a date and name.
• Complex Algorithms (data mining) include segmentation, clustering, prediction
• Complex Algorithms (behavioural) include flocking, following, avoidance etc.
• Complex Algorithms also include those based specifically by querying semantic (RDF) formatted data.
• Algorithms,Transformations, File Formats, Results constitute the parts of a specific Experiment. There will be many Experiments. An Experiment will have a name and date range (start and finish), and notes.

This ITECH 2004: 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.