D4DME – The Database (Part Two)

An entity-relationship diagram (ERD) is a data modeling technique that graphically illustrates an information system’s entities and the relationships between those entities.

After our group lecture on ERD and database design, I decided to have a go at planning how our database tables would look for the Starving Student page. Our website won’t be able to function properly without a solid database structure, so it’s vital that I get this part of the project up and running to make the other jobs easier for my team.

7

Screenshot of ERD in Word

8

Screenshot of Database Tables in Word

The USER table contains the same fields as my previous idea on ‘D4DME – The Database’, though I have focused more on the rough design for now rather than trying to make the table in PHPMyAdmin. The RECIPE table is slightly more complicated, as it must have two derivative tables each containing relevant data. As I wasn’t particularly happy with this structure for the database, I decided to email Simon for some advice on what to do next.

References

Janssen, D. and Janssen, C., 2010. Techopedia [online].
Available from: http://www.techopedia.com/definition/1200/entity-relationship-diagram-erd [2/20/2015].

Advertisements

D4DME – The Wiki

To make it easier for us to keep our group work clearly distinguishable from our blog work, I suggested that we create a DocuWiki page on one of our servers. I was happy to set it up on mine, as I have 24/7 hours access to the servers (one of the many perks of living on campus).

13

Screenshot of Our DokuWiki

In hindsight, I realised that having a full Media Wiki was more than what w actually needed it for, so I decided to remove it from my server space and replace it with a much simpler version.

We decided as a team that the DocuWiki will be used to host any information that we think of during our weekly team meetings (such as the one we had today) so that we can look back over our planning and have a constant record of what we need to do to progress our project.

Our DocuWiki can be found Here