The following questions provide practice with outer joins.
(a) Repeat the database queries in Exercises 6.11 (a)–(d), but this time include all
modules in the list, even those that currently have no module leader.
(b) Produce a list of all staff and the modules they lead. Include staff who do not currently lead any modules.
(c) Produce a list of staff from the computing department, showing the modules they
lead. Include staff who do not currently lead any modules.
(d) Produce a list of staff from the computing and business departments, showing
the modules they lead. Include staff who do not currently lead any modules.
(e) Produce a list showing all staff and all modules, clearly indicating which staff currently lead which modules, those modules that have no leader and those staff
who do not currently lead a module.
(f) Produce a list showing all staff and their line manager. (Hint: You will need to use
a self join.)