Initial Ideas


As a group we needed to come up with some ideas for the website we will be making in this unit. It needed to be database based and not too complicated to make. I created a spider diagram for the some of the ideas I had in mind for this project. I then took this to my group and added to the diagram with some of their ideas.

Initial IdeasAmy and I decided that after looking at some of the competitors for these websites that the babysitting idea would be the best one to go with. We considered our skill level and as both of us hadn’t really done any coding before we wanted to make something simple but effective.

We wanted the website to be able to:

  • log in
  • log out
  • sign up
  • post a new profile
  • delete the profile
  • upload an image
  • upload a CV

Hopefully we would be able to create all of these elements for the site and make a functioning an aesthetically pleasing web-app.


Entity Relationship Diagram


Today we had a lecture on Entity Relationship Diagrams which are a diagram system that explain he relationship between the entities on a database.

I also found some other definitions online to be able to understand this concept further:

“An entity-relationship diagram (ERD) is a type of data modeling that shows a graphical representation of objects or concepts within an information system or organization and their relationship to one another.”

Source – What is entity relationship diagram? – Definition from 2015.What is entity relationship diagram? – Definition from [ONLINE] Available at: [Accessed 23 February 2015].

The diagram below describes what each of the symbols are and how to use them in an ERD.

Here is a basic example of a real ERD as a purchase order application:

Contributing to UGC


OpenStreetMaps (OSM)

Screen Shot 2015-02-09 at 14.56.08

OSM Background

OSM was created by Steve Coast, a British entrepreneur, in 2004. He was inspired by the rising success of another UGC website, Wikipedia. The site is also funded by the OpenStreetMap Foundation (a non-profit organisation based in England).

Large companies such as Craigslist, Apple and Foursquare have replaced their mapping system (originally Google Maps) with OSM. There reasons vary but mainly as OSM contains free and openly available data (under the Open Database License) which means they do not have to pay Google for use of their mapping system as the data is open to anyone as people have contributed to the website to fill in the data that currently exists.

During the Haiti Earthquake in 2010 OSM was used as a new way to help the aid workers gain information and data about the aid centres created in Haiti that provided aid to the local people. HOT (Humanitarian OSM Team) would each update the map with the moving aid stations and vitals points across Haiti to provide up-to-date information to the people helping the earthquake victims.

This is their mission statement:

The Humanitarian OpenStreetMap Team (HOT) applies the principles of open source and open data sharing to humanitarian response and economic development.

HOT have outlined their core objectives as being:

  • To be the connecting point between humanitarian actors and open mapping communities.
  • To provide remote data creation during crises.
  • To collect and organise existing data sources.
  • To support deployments to the field.
  • To be a distribution point for free data.
  • To develop open knowledge and tools


Currently OSM has over 1.6 million registered users worldwide and is currently growing at a rapid rate. Being a more up-to-date and accurate map system, they are quickly competing with Google Maps as their main competitors.


I have decided to contribute the User Generated Content based sites (UGC). There are many of these sites including Wikimedia, Openstreetmaps, Zotero and many more.

After having a look at some of the UGC websites I was intrigued with Openstreetmaps. Considering their large competitors such as Google maps and Bing maps, they have used the UGC feature to be a unique and intriguing feature to the site. Being able to manually edit the map makes their data more up-to-date and accurate than their competitors. It gives users the chance to completely manipulate the map. I have never heard of this site before but now I will use this site over its competitors due to its accuracy and detail.

Screen Shot 2015-02-09 at 15.13.07

I decided to add the medical centre onto the map of the Talbot Campus. The website was easy to use as there was a tutorial on how to edit the map. I could add other details about the medical centre like the website and phone number which is good information to have on the map. Overall this is a great piece of technology. If more people know about the site and the map was more detailed, I could predict that it would be more popular than their main competitors. It’s great to see people collaborating on a site to improve the user experience for the next person that goes on the site.

Screen Shot 2015-02-09 at 15.19.03