Database Relationship ??

king99

king99

@king99-bh2V1z Oct 21, 2024
😕😔😔😔😔😕😕
Hi,

I have confusion of representation of relationships in database schema suppose A ir private owner who owns B property for rent are tables as shown below

Table- PrivateOwner Table- Propertyfor_rent
Ownerno 0...1 (Powns ->) 1...* propertyno
lname -------------------------------------- street
address city

Please database experts can u tell exactly what are the above relationships show , i know 1..* means one to many or 1....1 ie one to one , but i want to know that relationship shown above ie 0...1 -------- 1..* from private owner who owns the property to property for rent means what ?. Is it 1...1 one to one relationship shown between them if yes , then why for individual table 0..1 and 1...* is shown , please clarify on this , thanks !!

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

  • PraveenKumar Purushothaman

    PraveenKumar Purushothaman

    @praveenkumar-66Ze92 May 15, 2011

    king99
    😕😔😔😔😔😕😕
    Hi,

    I have confusion of representation of relationships in database schema suppose A ir private owner who owns B property for rent are tables as shown below

     Table- PrivateOwner                                                         Table-  Propertyfor_rent
               Ownerno           0...1           (Powns ->)      1...*                 propertyno
                lname              --------------------------------------          street                 
               address                                                                               city 
    Please database experts can u tell exactly what are the above relationships show , i know 1..* means one to many or 1....1 ie one to one , but i want to know that relationship shown above ie 0...1 -------- 1..* from private owner who owns the property to property for rent means what ?. Is it 1...1 one to one relationship shown between them if yes , then why for individual table 0..1 and 1...* is shown , please clarify on this , thanks !!
    1...* is one to many...
    1...1 is one to one...
    0...1 is zero to one...
    *...* is many to many...

    In your case, the owner, can be an owner only if he owns atleast one. He can own either one or more than one. Hence one to many... 😀