Ok i’m building a portfolio archive for myself and was looking at the tutorial http://www.kirupa.com/developer/php/relational_db_design.htm.
Now it sort of makes sense doing it like this but i haven’t got great logic.
Correct me if i’m wrong doing it like this allows me to store information that would otherwise be duplicated once and search through my portfolio easier?
But i can’t seem to get my head round using it for myself? Could someone explain this in baby language how it works. I know you have joiners and things but whats it all for?
Also when adding work into the database how would you add it into that as it need to update three tables and i’m only used to updating one.
Any help would be great and ver much appreciated.