Subject Code : ITECH2004
Country : Australia
ITECH2004 - DATA MODELLING - Designing And Implementing A Relational Database - Case Study Assessment Answer 
Task:

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

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 ITECH2004 Computer Science Case Study Assessment has been solved by our Computer Science Experts at UniLearnO. 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.

 

 

  • Uploaded By : ethan
  • Posted on : September 05th, 2018
  • Downloads : 141

Whatsapp Tap to ChatGet instant assistance