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
Post a Comment