Stadium Representation in a Database
How would I represent a stadium object in a database?
I'm designing a ticketing application to sell tickets to events. These events take place in stadiums. A stadium has stands, stands have tiers, tiers have sections and sections have seats.
But how do I represent all that in a database? Or should the ticket have all those properties associated with it? i.e. a ticket is for a seat in a section in a tier in a stand in a stadium?
Just some pointers on which way I should go with this please?