First of all thank you in advance for any help that you can offer me.
I am currently drawing up an ER diagram of World countries, and I am finding it hard to decide whether to use a weak entity or not. If I have a country entity for example, and had to describe which country bordered which other country, would this be a weak entity due to the fact that the border information is meaningless without knowledge of the country itself? My logic was that if a country was deleted from the database, then you would want to cascade the deleting down to the border attributes automatically too. I would just like a quick opinion if at all possible please.
Thank you for your help.