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
Messages: 11
Registered: July 2009
Junior Member


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.

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

Current Time: Fri Aug 18 20:54:14 CDT 2017

Total time taken to generate the page: 0.33022 seconds