What is the relationship between the 'seats' and 'halls' tables in a cinema database?

In a cinema database, there is usually a "one-to-many" relationship between the "seats" and "halls" tables. This means that one hall contains many seats, but each seat belongs to only one hall.

Example:

• The Halls table has a unique identifier HallID.
• The Seats table contains a HallID field as a foreign key, indicating which hall the seat belongs to.

This relationship allows for efficient storage and management of seating arrangements in each hall.