System Analysis and Design Paper 37

Access right to a database is controlled by

The attributes of relationship teaches in teacher teaches course should be

If an entity appears in not more than 5 relationships then it is a

Given an attribute x, another attribute y is dependent on it, if for a given x

Given the following relation
vendor order (vendor no, order no, vendor name, qty supplied , price/unit)
the second normal form relations are

A 3 NF relation is converted to BCNF by

By redundancy in a file based system we mean that

A database is a

Database is

DBMS must implement management controls to
control access rights to users
implement audit trail when changes are made
allow data to be used extensively in the organization
duplicate databases