I have been working on a relational database and have been putting it together as an ER diagram which I have attached (it has no relationships at the moment).
Here are how the tables are related:Each Diary (diaries) has many Questions (questions)
Each Question (questions) has many Responses (responses)
Each Response (responses) has one Value (responses_values)
Each Question (questions) has one Answer (answers)
(The lkp_scales table is a static list for a drop down list)
My problem is, I have contained the primary id's (for the main tables) through out my tables but I'm unsure if this is the correct method to be designing this database.
So I'm looking for any input on how my database is designed and if there is a better or alternative way I should be putting it together?
Thanks in advance!