Y
Yoavgold
Question for the vbcode DB forum:
I'm trying to build a DB that will help getting info about movies and
theater plays.
I have tables for the Movies, Plays and Theatres data.
BUT
When I tried to define the time table for each movie it got messy, I don't
know what to do, how to define the time for each movie and play, almost
every movie shows in a different days and different hours – should I set a
table for each movie? Or maybe some more columns in the movie table…
How should I design the tables in order to manage each movie's time?
I'm trying to build a DB that will help getting info about movies and
theater plays.
I have tables for the Movies, Plays and Theatres data.
BUT
When I tried to define the time table for each movie it got messy, I don't
know what to do, how to define the time for each movie and play, almost
every movie shows in a different days and different hours – should I set a
table for each movie? Or maybe some more columns in the movie table…
How should I design the tables in order to manage each movie's time?