A
A
altertable2020-04-25 00:52:10
MySQL
altertable, 2020-04-25 00:52:10

How do you like the DB - ticket sales. what's bad, what's good? what is the best way to link the table "Hall" and "Sector"?

Not strong in database design, so please help.
It seems that everything is normal, but it seems that everything is not so simple)
I'm waiting for your answers)

corrected a bit.
what is the best way to link table "Hall" and "Sector"???
5ea41394b176e521399783.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2020-04-25
@vityareabko

1. Why is there a "hall" field in the ticket when it is in the session?
2. Why is there a "sector" field in the ticket when it is included in the price?
3. Why is the "sector" field in the price unrelated to anything?
4. Why in the Field1 session?
5. What determines the price? Perhaps there should be a table of the form (room, sector, date interval, price) or (session, sector, price)?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question