Netsmart Interview Question

What are the pros and cons of database normalization?