Home » Developer & Programmer » Designer » Simple Question About RDBMS Design - SQL - I Need Suggestion (SQL, RDBMS, Normalization, Oracle, ER Diagram)
Simple Question About RDBMS Design - SQL - I Need Suggestion [message #421921] Fri, 11 September 2009 17:28
peace2009
Messages: 11
Registered: July 2009
Junior Member
Hello,

http://img3.imageshack.us/img3/6989/53645000.jpg


Beside CustomerFamilyMembers entity you will see (0,6). This means a customer does not need to have a family in case a customer is single. However, in case a customer has a family, the family members can not exceed 6 members. If i did (1, 6), this means i'm enforcing every customer (or newly inserted) record in Customer to be associated at least with one CustomerFamilyMembers record which is not true in case of a single customer, so (0,6) is the appropriate degree of participation. If i understand it wrongly, let me know please.

Thanks

Report message to a moderator

Previous Topic: Need to design new database..
Next Topic: Strategy to be followed when creatingdatastructure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 07:16:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.