How to save seat data when booking online?

Question

MySQL

Let's say there are M sectors of the hall. Each sector has a certain number of seats N ( N<=500 ). A ticket is formed for a specific seat in the sector with a certain price depending on the session of the event.
It turns out that if we have 5,000 seats in the hall, then the "Ticketing" table and the "Seats" table in the database will contain 5,000 records each for one session of the event.
Is there a more versatile and optimized way to implement this solution?

Answer 1

If it turns out to formPricing - then you can stir up something. But why?
Does the number 5000 scare you? In general, it is not at all scary for a DBMS.
However, it is worth trying those economists who invented pricing. It is possible that then a couple of other entities such as categories / classes of places and sectors and coefficients will appear.
Such as "side", "central", "near", "far" seats in the sector + the sectors themselves of several varieties a'la stands at the stadium. Then the price of a particular place will be obtained as Session Price * Coefficient By Sectors * Coefficient By Places