Database Setup In Part 6 we created an Entity Relationship Diagram for our database, including a junction table to link the ‘keyword’ table to the ‘photo’ table. Now it is time to set up the database so we will be able to use it when we begin the coding. The first thing we want to … Read more
Database Design So far we have designed two tables, created the relationship between them, and designed an ERD (Entity Relationship Diagram). Let’s look at that again: I mentioned that we would be looking into the ‘keywords’ column. So what problem do we have here? In its current design we could have a photo with multiple … Read more
Database Design Previously we created our tables and I said we would look at a graphical representation – also called an Entity Relationship Diagram (ERD) – which will help us visualise the lists for our table columns. This is extremely helpful because it can show if a relationship (the connection between tables) has any errors. … Read more
Database Design I previously talked about creating lists for what we require for our site and how messy our initial lists were. Before I get into improving these, I would recommend reading the link below. It covers database normalisation which is a method to organise your databases – making them simpler to use, improving the … Read more
Creating Lists In the previous article I described the website idea from the point of the user – what they will be able to do on the site. Now we need to work out what we need from a developer’s point of view. I will get the idea, pull out individual parts, and create a … Read more
The Idea Once you have got the idea for the site you want to create, you will want to write down what it will do from the point of view of the user. This will be a general description, as getting too specific won’t allow for any future changes to the idea that may be … Read more