Here, WORKS is a relationship between EMPLOYEE, PROJECT, and DEPARTMENT. Which of the following questions cannot be answered using this database schema?
A. What is the total number of employees working in a project of PWD department?
B. Which department has more number of projects?
C. In which project, Mr. Guna is working under the Finance department?
D. What is the number of projects executed by PWD department at the cost of two million?
Answer:D
Here, WORKS is a relationship between EMPLOYEE, PROJECT, and DEPARTMENT. Which of the following questions cannot be answered using this database schema?
A. What is the total number of employees working in a project of PWD department? B. Which department has more number of projects? C. In which project, Mr. Guna is working under the Finance department? D. What is the number of projects executed by PWD department at the cost of two million?