Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Binary Relationship

    @shikha.bansal
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 344
    Comment on it

    A Binary relationship is when there is relation between two entities.This relationship is further divided into three types.

    1. One to One
    2. One to Many
    3. Many to one
    4. Many to Many

    1.One to One: In this relationship, one entity can be associated with just one entity.
    For Example: A student enrolls only for one course and a course will also have only one Student. We rarely found this scenario in real world.

    alt text


    2. One to Many:In this relationship, one entity can be associated with many entities.
    For Example: A Subject can avail many courses and Each courses belongs to one Student.

    alt text


    3. Many to one:In this relationship, many entities can be associated with just one entity.
    For Example:Student enrolls for only one Course but a Course can have many Students.

    alt text


    4. Many to Many:In this relationship, many entities can be associated with many entities.
    For Examplemany students can enroll for more than one courses.

    alt text

    SQL Server
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: