Movie Theatre Database Design: Step-by-Step

A movie theatre or movie booking website seems like a simple concept, but there is a lot of structure behind the scenes to ensure the movies are displayed, show times are correct, and that users can make a booking and customise it.

In this video, you'll watch me browse a real movie booking website, view movies, and book tickets, creating a database design diagram (ERD) as we go, and even writing the SQL statements to create the tables and insert the data.

⏱ TIMESTAMPS:
00:00 - Our first table
04:41 - Writing the SQL
07:30 - A SELECT query
10:11 - Cinemas
11:58 - Showing times
13:30 - Attributes
17:15 - Start a booking
19:02 - We've found a problem
21:35 - Ticket types and snacks
24:40 - Complete our booking

[leoaung]

Awesome video, really informative and easy to follow. I wish I've seen this video before my database exam haha. I'll be rewatching your videos to practice. Thank you!!

[AndreMantas]

Not everything you see in a website has to be in a table. For example the status for a movie could be a calculated value based on the date of the first and last showing. Otherwise you need to have a cron job somewhere checking this and updating the movie status.

Another thing I wonder is how the website will know how to render the theater structure and exactly where to put the seat icons just from the seat location. Sounds like a cool challenge

Besides that I think the explanation makes sense and was well presented 👍

[OsteenOmega]

Thank you so much for this content. can we have a session where you give a set of requirements and allow us to come up with our designs and then release your solution in a future video and see how we were to the actual design. i believe this way your content will be more interactive for us follow up

[ClintonomoBay]

17:38 so for this legend, would it be a good idea to put an extra field in seat and try to keep up with the status of it to avoid a double booking? I feel like seat availability is the only thing I don't understand how it's being tracked, having watched the whole video. Other than that, great tutorial!

[Cesarkzz]

Hi, thanks for your work! Can you make a video for a payroll with check in and out of employees, extra hours. etc.

[MOHAMEDMAHMOUD-zrds]

I Liked you tutorial, but how website for this database work? & I'm beginner

[danishali]

can you do for a financial System like a complex one