database normal form

1.  Find or create a violation of 1st normal form and demonstrate how you would fix it.
2.  Find or create a violation of 2nd normal form and demonstrate how you would fix it.
3.  Find or create a violation of BCNF and demonstrate how you would fix it.
4. Find or create an example of a violation of a normal form that you would allow, tell why you are allowing the violation and explain how you would protect against anomalies.