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
Previous Topic: Need to design new database..
Next Topic: Strategy to be followed when creatingdatastructure
Goto Forum:
  


Current Time: Thu Mar 28 04:45:26 CDT 2024