DBMSs generally provide two types of database security:
Primary index on the PropertyForRent relation based on the propertyNo attribute:
CREATE UNIQUE INDEX PropertyNoInd ON PropertyForRent(propertyNo);
CREATE INDEX StaffNoInd ON PropertyForRent(staffNo) CLUSTER;
CHECK (NOT EXISTS (SELECT staffNo
GROUP BY staffNo
HAVING COUNT(*) > 100))
The process of producing a description of the implementation of the database on secondary storage. It describes the base relations, file organizations, and indexes used to achieve efficient access to the data.