If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Weak entity decision making (ER diagrams)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-21-09, 20:32
nffcchris nffcchris is offline
Registered User
 
Join Date: Nov 2009
Posts: 1
Weak entity decision making (ER diagrams)

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.
Reply With Quote
  #2 (permalink)  
Old 11-22-09, 03:38
dportas dportas is offline
Registered User
 
Join Date: Dec 2007
Location: London, UK
Posts: 732
I wouldn't spend too much time actually deciding whether to use a weak entity. Design your model based on formal methods like ORM or guiding principles like Normalization and so on. If some of the entities thus identified are "weak" then so be it. The weak entity concept is of very little importance in relational database design.

I think you are right. I expect you wouldn't want a border referring to a country that no longer existed in the database.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On