1

Add a new data table not associated with another data table.

M

M

D

D

Unimplemented entity type

Plus any data table

2.

Add a new data table associated with another data table.

M

M

M

D

S

D

Unimplemented entity type

Plus its related entity types

Plus data table

An entity type scoped with Modify or Delete protection includes its associated data table with Read protection.

3.

Delete a data table not associated with another data table

D

D

D

D

Implemented entity type of target data table

Plus entity type

An entity type scoped with Modify or Delete protection includes its associated data table with Read protection.

4.

Delete a data table associated with another data table.

D

D





M

M

D

D





D

S

(a) Target data table

(b) Data tables that have target data table's relationship membership name as their identifier

(c) Implemented entity types for data tables in
(a) & (b).

(d) Any entity types to which the foreign key column of
(a) & (b) point.