using Entity Framework Core, Code First/Database First to create database for random topics like managing movie ticket, managing football match and including some functions

Using Entity Framework Core in Code First or Database First to create database for football app management, movie theater ticket management, etc.. including with functions :
(example)
Code First
Displaying movie theater list (at least have name, how many empty slot )
Displaying movie list ( at least have movie name, movie duration)
Displaying movie schedule (at least have movie name, which movie theater, show time )
Book movie tickets for each specific showtime
- the person who booked the ticket is also the viewer just save the phone number
- The ticket booking screen only shows a dropdown to select showtimes for those that have not yet shown time
- Tickets can only be booked with the remaining number of theaters corresponding to the showtimes (assuming the booking is confirmed. For example: Movie X showing at theater A has a capacity of 50, audience A orders 10 tickets, the following times only for booking up to 40 tickets)
Look up the list of booked tickets according to each showtime


If you're interested please dm me for more detail