Problem $1(1$ point each, total $14$ points$)$

For each concept in the left column below, select the closest matching item from the right column. Note that items in the right column are to be used at most once. Place the number of the right column item next to the corresponding left column item. $q,$ entity integrity

$$ transaction

$q,$ horizontal decomposition

snapshot

before, after, instead of

SEQUEL

vertical composition

$22$ virtual relations

scanning a relation tuple by tuple equi$-$JOIN referential integrity $q,$ fast query execution $.P\frac{L}{S}QL$

$10$ relational data model

index.

Microsoft.

P$.$ Chen.

virtual memory.

Sequential Query Language.

E$.$F$.$ Codd.

DML$.$

Oracle.

JOIN where duplicate attributes are eliminated.

e$.$g$.$ 'Age can not be negative'.

derived attributes.

ATM.

prior to$,$ just after, rather than a transaction.

inter$-$relation constraint.

restrict.

$116.$ integrity of entity types in the E$-$R$.$

division.

trigger.

more general than Natural$-$JOIN

QBE.

all or nothing.

view.

union.

horizontal composition of relations.

CURSOR.

SQL$.$

T$-$SQL$.$

refresh

intra$-$relation constraint.