How is it possible to shard the database based on ShowID when there are so many other tables like Seats, Hall, and Movie? If we are sharding database servers, and we are using a relational database, then how would any of the entity relationships work?

Perhaps there are just missing details in the explanation?