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

Posted on 2009-12-28
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

    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

    it did not clear fully,

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Oracle SQL Query Syntax 6 71
    Invalid Identifier Error 3 50
    SQL Insert Query Help, part2 6 32
    Mysql not caching queries 4 36
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now