This task starts off quite simple and a little more complexity is added during the interview. If you have a good understanding database design and structures then this should be a straight forward task. There are no trick questions and the interviewer works with you if you get stuck, so don't be afraid to not know something or look for some guidance. I did this task on a whiteboard and talked through decisions and considerations but I believe this can also be coded if you prefer.