McqMate
| Q. |
Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well? |
| A. | X→Z |
| B. | W→Z |
| C. | X→WY |
| D. | None of the above |
| Answer» B. W→Z | |
2.1k
1
Do you find this helpful?
1
View all MCQs in
Advanced Database Management Systems (ADBMS)Discussion
JINESH VARIA
1 year ago
please elaborate in depth with suitable example
0
Bhagirath Makwana
8 months ago
This is because w is not deriving any attribute, so w->z is not true.
0
Related MCQs
- How many inference rules are there for functional dependencies?
- A relation is in this form if it is in BCNF and has no multivalued dependencies:
- The DML provides following functional access to the database:
- Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?
- A functional dependency of the form X→Y is trivial if
- The ____ is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.
- An application where only one user accesses the database at a given time is an example of a(n) ________ .
- Which of the following statements is true concerning routines and triggers?
- Which of the following is the formal process for deciding which attributes should be grouped together in a relation?
- Which of the following is not the state that the transaction undergoes?