Database: Entity Relationship Diagram.

In today’s seminar we looked into a few database functions called ‘ERD’ Entity Relationship Diagrams. An ERD is a way of organizing and a graphical representation of entities and their relationships to each other through a logical structure of a database.

The original notation for ERD’s used rectangles to represent entities and diamonds to represent relationships, they can also be seen as IDEF1X or a Crow’s foot like the images we used in our seminar below.collection_erd-01

Entitiy – is the thing we want to store information, for example a person, place, thing.

Attributes – is the data we are going to collect for an entity.

Relationships – describes the relations between the entities

collection_erd-02

Below is an example of a Recipe ERD that Simon gave us as an example to show the entity relations and how the database works.

recipe_erd

Advertisements

Making a contriubution to a community based UGC platform.

After our lecture on participatory culture we were asked to make a contribution to a community based UGC platform and were given a few examples that ranged from adding photo’s and videos to wikimedia, adding recipes to wikibooks and so on.

I chose to add some detail to Openstreet (www.Openstreetmap.org) which is a collaborative project to create a free editable map of the world that users can log onto and edit accordingly. This also allows users to access a free map of the world as well as avoid expensive technologies and softwares.

After signing up to OpenStreetMap i decided to add the new Penguin enclosure they are building on Bournemouth beach behind the Oceanarium as it had not yet been added, I liked using OpenStreet as it gives the user a lot more responsibility and freedom and gives users the chance to add details ever so small for example the likes of a ‘tree’.

Screen Shot 2015-03-09 at 15.13.49

(www.openstreetmap.org)

Participatory culture.

In today’s lecture with Rob we discussed participatory culture, to begin with we looked at ‘Web 2.0’. Web 2.0 is the network as a platform which converges all devices and is a continually updated service that gets better with the more people that use it. Web 2.0 consumes and remixes data from lots of different sources, including individual users information in a form which is allowed to be remixed by others, creating a network of participation which is on going and goes beyond Web 1.0 and gives rich user experiences.

An example of web 2.0 is WIKI – a social software. This is a great example as WIKI has no defined editors and allows multiple users to change and edit pages, the simplistic plain vanilla web browsers main aim is to offer meaningful topic associations and is done so collaboratively.

Example of a WIKI – (http://en.wikipedia.org/wiki/Patek_Philippe_%26_Co.)

Another good example of participatory culture that you may not even be aware of is youtube, a community in which everyone uploads videos in which supplies with content to watch, without these users youtube would merely be a piece of software with no content.

Participatory culture, Henry Jenkins – (https://www.youtube.com/watch?v=AFCLKa0XRlw)

When looking at participatory culture we also watched a video on shared culture and ‘CC’ the creative commons which allows users to decide whether they want other uses to be able to remix, copy or change their work and in doing so they would have to reference the creator, therefore giving them credit and allowing users to still share someone’s work without the law or copyright getting involved.

After looking at participatory culture It made me realise that a lot of web based applications would not run without the huge audiences they carry, for example going back to Youtube. Youtube would not work if users stopped uploading to the site as there would be no content to watch, therefore audiences are a huge part of participatory culture and make these shared websites a lot more interesting as there is so much different content available.