SELECT Salary FROM Employee WHERE ROWNUM=2;

SELECT MAX(Salary) FROM Employee;

SELECT TOP 2 Salary FROM Employee;

Shared Lock

Exclusive Lock

Timestamp Lock

Read Lock

Committed

Partially Committed

Aborted

Active

Create one new relation including PKs of all participating entities

It cannot be represented

Merge any two entities

Convert it to three binary relationships

Cascading Schedule

Non-Serializable Schedule

Recoverable Schedule

Serializable Schedule

NOT NULL

UNIQUE

DEFAULT

CHECK

σ Manager > 50000 (Employee ⨝ Department)

 π Salary (Employee ⨝ Department)

π Manager (σ Salary > 50000 (Employee) ⨝ Department)

Lossless but not decomposition preserving.

Neither lossless nor decomposition preserving.

Both lossless and decomposition preserving

There are transitive dependencies

It has atomic values

It has multi-valued dependencies

There is a non-trivial functional dependency where determinant is not a

candidate key