Q 1. If every non-key attribute is functionally dependent on the primary key, then the relationwill be in
Q 2. Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well?
Q 3. Relations produced from an E-R model will always be in
Q 4. An attribute of one table matching the primary key of another table, is called as
Q 5. If a relation scheme is in BCNF, then it is also in
Q 6. A primary key when combined with a foreign key create
Q 7. The set of permitted value for each attribute is called its
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
Q 9. A functional dependency of the form X→Y is trivial if
Q 10. In transactions, in ACID property A stands for