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