Con Edison interview question

Basic concepts regarding database design