1. Match the Terms on the Left with the Definitions on the Right
14 1:1 Relationships |
01. |
An entity which can exist independently of other
entities |
17 1:M Relationships |
02. |
Collection of similar entity instances |
30 Associative Entity |
03. |
A
key that is associated to a key in a
different table |
11 Attribute |
04. |
How
many entities are involved in a relationship |
28 Binary Relationships |
05. |
A
situation where all, or some, entities depend on others for their existence |
29 Cardinality |
06. |
A
field where multiple values are possible |
13 Cardinality Constraint |
07. |
A
relationship which may or may not have a specified number of instances |
25 Composite Attribute |
08. |
Uniquely Identifies entity instances |
20 Concatenated Key |
09. |
Being
able to reach the same point from a variety of directions |
04 Degree of Relationship |
10. |
An
association between entities |
21 Derived Attribute |
11. |
Property
of an entity |
31 Entity |
12. |
A
well-defined field |
02 Entity Type |
13. |
Restrictions
between how entities are related |
09 Equifinality |
14. |
A
relationship where one instance is related to only one other instance |
03 Foreign Key |
15. |
A
relationship where many instance is related to many other instances |
12 Identifier |
16. |
A
relationship which can contain n entities |
05 Interdependent Relationships |
17. |
A
relationship where one instance is related to only one other instance |
15 M:M Relationships |
18. |
Association
between entity types |
23 Mandatory Cardinality |
19. |
Relationship
of degree three |
06 Multivalued Attribute |
20. |
Logically,
putting together multiple keys as an identifier |
16 N-Ary Relationsihps |
21. |
A
field which is calculated |
07 Optional Cardinality |
22. |
A
relationship where 1 instance is related to many other instances |
08 Primary Key |
23. |
A
‘must’ relationship |
18 Relationship |
24 |
No.
of participating entity types in a relationship |
10 Relationship Constraints |
25. |
Can
be broken into component parts |
12 Simple Attribute |
26. |
Depends
on the existence of another entity |
01 Strong Entity |
27. |
A
relationship where only 1 table is involved |
02 Table |
28. |
A
relationship of degree two |
27 Unary Relationship |
29. |
Specifies
Min.& Max. Number of instances |
26 Weak Entity |
30. |
Relationship
modeled as entity type |
19 Ternary Relationship |
31. |
Person,
Place, Object, Concept, Event |