I'm having an issue creating a little practice ERD. I'm trying to do some more difficult stuff, and I'm not sure what the standard way to organize it is.
Basically, I don't know which of these is most correct. Also, I'm trying to add some data: "Last video chat; last voice chat; last im; last email".
- I'm not sure if I should organize it off of
has, like type stems off of
has, in the first drawing. Or should I stem it off of
friend, like in the second drawing?
- I'm not sure if I should be direct, like
goldcome directly out of has in the third drawing. Or should I stem indirectly, like
last->chatted/emailed/..., the way
goldcome out of
typein the first and second drawing?
- If I add a
friendID, should I have it as a derived key from