database - relationship type,degree, cardinality, optionality terms confusion -


i studying database i've seen degree , cardinality uses same term, or in other degree defined no. of entities involved in relationship , further catogories unary, binary , trenary.

some placed degree defined degree of relationship type concerns number of entities within each entity type can linked given relationship type.

cardinality minimum , maximun number of entity occurrence associated 1 occurrence of related entity

cardinality types 1 1 , 1 many , many many. or min , max cardinality.

min degree optionality , maximum degree cardinalty.

what difference between degree , cardinaltiy ?

in context cardinality number of rows in table , degree number of columns.

so i'm suppose write if question asked "define cardinality ?".

can explain ?

ok here explanation

1.degree. number of entities involved in relationship , 2 (binary relationship) unary , higher degree relationships can exists.

2.cardinality. specifies number of each entity involved in relationship there 3 types of cardinality binary relationships

  • one 1 (1:1)
  • one many (1:n)
  • many many (n:m)

hope clear mind. please communicate more information


Comments

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -

javascript - Wordpress slider, not displayed 100% width -