Give E-R diagram for a database showing fatherhood, motherhood and spouse, relationship among men and women

Posted on 2009-12-28
Medium Priority
Last Modified: 2013-12-18
can some one ls tell me  the E-R diagram for a database showing fatherhood, motherhood and spouse, relationship among men and women
Question by:dphfl
LVL 30

Accepted Solution

Reza Rad earned 1500 total points
ID: 26130456
first entity you need is person
person has a field named gender that specify male or female
Person entity has one to many relation to itself on two fields: mother - father
because every person has only one mother and one father not more. but every mother or father can have many children.
you need another entity named PersonMarriage
person has one to many relation to personmarriage , bacause every person may have more than one marriage experience, for example divorced person and ....

Is it clear?

Author Closing Comment

ID: 31670354
it did not clear fully,

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question