Answer the question
In order to leave comments, you need to log in
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"???
Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question