MySQL Forums
Forum List  »  Newbie

Re: Tables optimization for messages feature
Posted by: Rick James
Date: February 15, 2011 11:26AM

Database lingo.

1:Many
1 user can write Many messages.
1 message can have many recipients.
1 person has Many children (Note: 0 is included in the definition of "Many.)

Many:1 This is a variant on 1:Many.
It might be better to say "Many messages can be written by 1 user".

Many:Many
Many users can write messages to Many other users.

1:1
1 person has 1 name. Well, this does not work. Names are repeated; one person can go by several names. So, really this is Many:Many.
1 device has 1 serial number. (Hopefully)

Options: ReplyQuote


Subject
Written By
Posted
Re: Tables optimization for messages feature
February 15, 2011 11:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.