Homework answers / question archive / Drawing an EER diagram

Drawing an EER diagram

Computer Science

Share With

---

Drawing an EER diagram.
 

MapOnMe Database eg

vapOaMe (MOM) is a company that aims to provide a local spatial data that can be wast on yse urban movement behaviour. For this purpose, this company provides a system whenmap data is manually inserted by their staffs and trajectory data are obtained from publics contributors. A trajectory is a time series of visited location point that shows a user movement?

in a specific of time window. A trajectory may contain numerous of trajectory points, howevent

in some rare Cases, a trajectory may consist of no trajectory points at all. oe

For the map data, the entry is manually inserted or updated by the administrator. A 5 satial

object can be modified several times by different administrators. For historical purposes: als

reason, the updated date and eaten

on, the updated date and reason must be recorded for any objects added/modified by the =

administrators. There are three types of objects in map data, whiclrare Point Data, Road Data ‘=a

and Region Data. Each object will have a unique object identifier called “objectID”. A Point “ |

data shows a location for an object such as Restaurant, Shop, Education or Public Service. 34

Any other type of objects will be classified as Others. A Point may have multiple -.2%

classifications. For example, a shop may have a restaurant in it. Each Point object will havea 3

specific object name and the Geolocation coordinate that contains a pair of Latitude and = {38

Longitude values. ig

A Road object is the road in the local area that might be classified as Highway, Primary, “st Ba

Residential or Footpath. Highway is a road normally with 2 or more running lanes plus -_.23

emergency hard shoulder. This type of road is usually used to connect metropolitan areawith = ““

regional area. Primary road is the main road in an area. The Residential road is the road that et

located in residential area which serves as an access to housing, without function of connecting = — i

settlements. The Footpath is a road restricted to pedestrian and bicycle access. Each Road ee

entry must have road name and road length in Km. A road data is represented as a specific s Fad

sequence of coordinate list. The Region data is used to represent Region in the local area. The ae

Region data has region name, area size in SqKm and a specific sequence of coordinate listes ‘4 +

a closed loop. : "3 i.

A member must be registered in the system by providing preferred memberID, email aid: = a | |

- name. The date and time when a member joins as user are obtained automatically during: : Ses

ae registration. The Administrators are staffs in this company that have modification: tig ne

were —_,_ insert, update or delete the spatial objects. The administrators are identified by Ga ae

BEES p~ Coatributor. Only contributors can submit (rajectotion, 0 Ie 2 epee
are required to develop an EER model for the above problem description. The EEK alaat Ge

You are required to iti ibutes, primary keys, relationships (inoluinsgeems

contain all necessary information such as entities, attribu , primary keys, relationsh magi Ae |

specialization/generalization if any), cardinalities, and participation (inc Od on oe a

‘ SFA

Lge is . as d union type must be represented accordingly, instead being treate a

specialization/generalization and union ions should also be stated cleatly. Tt'assiiptiOnk a

iation relationships. Any assumptions s atso pg

as simple association re + i flect possible real practice foe:dssam

de, it is important to make sure that the assumptions reflec Tn al

are mate, Ht is tradict with the problem description above. ernest |

particular industry and do not contradict with the pro ee

meee

: 7" arnt OT Te Se

P RE we

eS os 2

- . os See i

_ gle wt

| . oe : ae

- 7°! SO

a ye

be pee Do So fat a .

Beware ARES Se a

ea Ea yale

Re a ‘points a before you. get started: + pee

recent ont p note the following important po oo ee ot ore oy. = Ce :

We, 7 - | Sra Sh F &? wR -:. ies ae an

PR ead La Bia ag, Use any software to draw figures.a7S

Pain FABRIS MCL e to follow tite;poiations introduced in this subject (Youquams

ier Your acsionment. However, make sure to follow ‘tit potat . ee

aa —— eo . a a oe dtaw'to) . 4, . Se

Eungiseneral web-based drawing platforms such:ag dfaw.10) of tables for this. part of nee

haa ea ur EER’ diagram into a set of tables for this. part of am

| “Es Ny req quired to transform your ) ) ” | + oa ll

eee a ne, YT secu ed to perform normalization of the user views provided), 9

ease mes NOT require . used as a saurce-of” ai

Se otot h ee ge em = : 1 ra ecole de ae --

eae Spay The forms in the: appendices should be Ne, Appendix As an

aS art sate vies a. e* examp RS Cerne

Seater eocesnation for this assignment. For : ai ~ oF as ties anal

ae Rewer td jt what:information is required to be stonatt Ras