Con Edison Interview Question

Basic concepts regarding database design