Former Marriages

The rules or conditions about former marriages are:

1. Men can make lots of mistakes... lots of ex-wives.
2. Women can also make lots of mistakes... lots of ex-husbands.
3. Men don't have to have any ex-wives.
4. Women don't have to have any ex-husbands.

Of course, this M:N relationship cannot be implemented in SQL Server, Oracle, DB2 or any other relational database product. The M:N relationship needs to be replaced with a new bridge table (i.e., FormerMarriages) and the appropriate 1:N relationships for the man and woman.

More FAQs