DATABASE DESIGN PROBLEMS. READ AND ANSWER ALL PLEASE. THANKS.

=========

dept and dept ta HR u Iron are given the data of emp, emp dept and dept Deptit Percentage_tiene RandD Firme Dept d Dept Name *sults need to be matched and some 100 March the following queries with the outputs (not all result results may be repeated): 4. SELECT c. cmp_id, d. Dept_id FROM empe LEFT OUTER JOIN emp dept ed ON e.eu LEFT OUTER JOIN Dept d B. SELECT e. emp_id, d. Dept_id FROM emp e RIGHT OUTER JOIN emp dept ed ON e.emp_10 RIGHT OUTER JOIN Dept d C. emp_id - ed.emp_id ON d. Dept id - ed.Dept_id; N e.emp_id = ed.emp_id ON d. Dept_id = ed. Dept_id; c. SELECT c.emp_id, d. Dept_id FROM empe NATURAL JOIN emp_dept ed NATURAL JOIN Dept d; d. SELECT e.emp_id, d. Dept_id FROM emp e, emp_dept ed, Dept d WHERE e.emp_id = ed.emp_id AND d. Dept_id = ed. Dept_id; e. SELECT e.emp_id, d. Dept_id FROM emp dept ed LEFT OUTER JOIN emp e ON e.emp id = ed.emp_id LEFT OUTER JOIN Dept d ON d. Dept id = ed.Dept_id; f. SELECT e.emp_id, d. Dept_id FROM emp e LEFT OUTER JOIN emp_dept ed ON e.emp id = ed.emp_id LEFT OUTER JOIN Dept d ON d. Dept_id = ed.Dept_id UNION SELECT e.emp_id, d.Dept_id FROM emp e RIGHT OUTER JOIN emp_dept ed ON e.emp id = ed.emp_id RIGHT OUTER JOIN Dept d ON d. Dept_id = ed.Dept_id; g. SELECT ed.emp_id, ed. Dept_id FROM emp_dept ed WHERE EXISTS (SELECT 1 FROM emp_dept e WHERE e.emp_id = ed.emp_id) AND Percentage time > 50; dept and dept ta HR u Iron are given the data of emp, emp dept and dept Deptit Percentage_tiene RandD Firme Dept d Dept Name *sults need to be matched and some 100 March the following queries with the outputs (not all result results may be repeated): 4. SELECT c. cmp_id, d. Dept_id FROM empe LEFT OUTER JOIN emp dept ed ON e.eu LEFT OUTER JOIN Dept d B. SELECT e. emp_id, d. Dept_id FROM emp e RIGHT OUTER JOIN emp dept ed ON e.emp_10 RIGHT OUTER JOIN Dept d C. emp_id - ed.emp_id ON d. Dept id - ed.Dept_id; N e.emp_id = ed.emp_id ON d. Dept_id = ed. Dept_id; c. SELECT c.emp_id, d. Dept_id FROM empe NATURAL JOIN emp_dept ed NATURAL JOIN Dept d; d. SELECT e.emp_id, d. Dept_id FROM emp e, emp_dept ed, Dept d WHERE e.emp_id = ed.emp_id AND d. Dept_id = ed. Dept_id; e. SELECT e.emp_id, d. Dept_id FROM emp dept ed LEFT OUTER JOIN emp e ON e.emp id = ed.emp_id LEFT OUTER JOIN Dept d ON d. Dept id = ed.Dept_id; f. SELECT e.emp_id, d. Dept_id FROM emp e LEFT OUTER JOIN emp_dept ed ON e.emp id = ed.emp_id LEFT OUTER JOIN Dept d ON d. Dept_id = ed.Dept_id UNION SELECT e.emp_id, d.Dept_id FROM emp e RIGHT OUTER JOIN emp_dept ed ON e.emp id = ed.emp_id RIGHT OUTER JOIN Dept d ON d. Dept_id = ed.Dept_id; g. SELECT ed.emp_id, ed. Dept_id FROM emp_dept ed WHERE EXISTS (SELECT 1 FROM emp_dept e WHERE e.emp_id = ed.emp_id) AND Percentage time > 50