I am trying to do a database ER for the following scenario but I cannot figure it out how to do it specially the coordinates bit. Has anyone got a clue?
PhotoBook is a site for sharing information about places, photographs and arranging meetings.
Design a database that will enable PhotoBook members to add photos, places and visits.
Members should also be able to allocate other members as friends who are able to browse all of the information they add.
Places are identified and named by members. Their locations are described either by a point or an enclosing rectangle. Points consist of a pair of x,y coordinates. Rectangles consist of two pairs of x,y coordinates identifying the north‐west and south‐east corners.
Members can add unstructured text and any number of optional tags to describe a place. Note that each member may add, describe and locate the same ‘place’ (e.g. Northampton Square) differently, but a member must give each of the Places they add a unique name.
All photos are associated with a place Photos may also be optionally associated with a visit.
The date and time at which each photo is taken is recorded in PhotoBook along with file name and a photo number that uniquely identifies each photo added by any individual member.
Unstructured text and tags can be added by the photo’s owner to describe each photo. Any member who views a photo owned by one of their friends can rank it from 0‐5.
Visits are periods of time when members are at particular places.
Members sign up with a unique name. Their full names, dates of birth and time and date of most recent activity must be recorded in PhotoBook.
For the purpose of this scenario assume that all Places are in Russia. Use the coordinates which should be within the following bounding box: