Advance Database Management System (ADBMS)
R
Q 1. If every non-key attribute is functionally dependent on the primary key, then the relationwill be in
R
Q 2. Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well?
R
Q 3. Relations produced from an E-R model will always be in
R
Q 4. An attribute of one table matching the primary key of another table, is called as
R
Q 5. If a relation scheme is in BCNF, then it is also in
R
Q 6. A primary key when combined with a foreign key create
R
Q 7. The set of permitted value for each attribute is called its
R
Q 8. The airline reservation system, the enables are date, flight number, place of departure,destination, type of plane & seats available. The primary key is
R
Q 9. A functional dependency of the form X→Y is trivial if
R