Which of the following is generally a benefit of normalisation?

Performance is improved

Insertion anomalies are avoided

Selection anomalies are avoided

Number of tables is reduced

None of the above

MySQL is ACID compliant.

True

False

Which of the following statement is CORRECT about normalisation?

		A database that is not in at least third normal form cannot be implemented with MySQL.
		A database that is only is first normal form would breach the CAP theorem.
		Normalisation ensures consistent formatting, for example that all the phone numbers would have the same number of digits.
		All of the above
		None of the above