Question:
(a) Describe fully with example the two access control methods available to implement database security.
(b) Discuss why database statistics (meta data) provide essential information for query optimization. Give four examples of typical statistics which are maintained by a database system.
(c) Discuss why query optimization is important in database systems in terms of its role in enhancing the system performance. Your answer should include descriptions of various stages involved in the optimization process.