Database design usually tries to strike a balance between complexity and simplicity. What are the advantages and disadvantages of either extreme? In you opinion, under what circumstances would you favor one over the other? Provide some scenario examples.