[Database Management]

Describe referential integrity and cascade options. How can they be helpful and when can they be a downright pain in the neck?

Describe the security model used by MySQL. Be specific as to the different aspects of authentication and where permissions come from (i.e. what tables are they stored in?). Describe how permissions are determined.

Describe the role of the database administrator from the point of developing a new database system through administering such a system. Make sure to include points of development that make the administration easier/harder and the database well accepted by all.

Discuss two ways in which database processing can lead to increased productivity for an organization. Be specific as to the causes and effects of the implemented database system.