How to properly design a movie database?

Question

Database design

Good afternoon. I think how best to design the database, the problem is that there will be a lot of duplicate data, but they all refer to different films and I can’t know their exact number . I took SQLITE
for the database . There is a film, and it has many cinemas, each cinema also has a lot of time. How to properly design a database?

Answer 1

This task is for learning, this must be solved independently.
You write the first version, you start working with it, you understand where it is wrong / inconvenient, you write the second version, you start working with it .. and so on until you're blue in the face. The end result is a real experience.
PS When designing a database, one must take into account not only the object, but also what work will be done with it in the future, roughly speaking, the structure of the database for selling tickets and for "what movie, where is it now" can differ significantly.

Answer 2

I would make tables фильмы, времена, кинотеатры; then the table sessionswould store in it фильм_id-кинотеатр_id-время_id.

offtopic

Есть большой шанс того, что кинотеатры и время у многих фильмов совпадают.

Т. е., в большом количестве кинотеатров два зала?