Below tables are given, Employee (employee_id, name, salary, department) Leave (employee_id, date, reason, no_leaves) Holiday (Date, description)…
Below tables are given, Employee (employee_id, name, salary, department) Leave (employee_id, date, reason, no_leaves) Holiday (Date, description)
(i) Write mapping cardinality between 'Employee' and 'Holiday' table.
(ii) Write query to show all employee's leave count.
(iii) Write query to show employees who are in 'HR' department and have taken at least 5 leaves.
From the Rupali Bank Assistant Network Engineer 2021 – Written (CTI) exam, question 43 of 46.
More from this paper
- Previous: Preorder and In-order sequence is given, Draw the binary tree and write a procedure sum Nodes (Node* root) to find out summation of all…
- Next: Write about 5G disadvantages: (a) Increased High Costs (b) Draining Battery of devices. (c) Increased infrastructure development cost
- All questions in Rupali Bank Assistant Network Engineer 2021 – Written (CTI)