Interview challenge with databases

As part of the interview process, I've been asked to solve this problem: A railway company has to build a database to manage its booking system. The database has to store: Users: id, name, email address, and city of residence. Cities: id, name. Ri...