it wont really take anything tricky to set up the data base,
concertID - Primary Key
and any other columns you would like for the concert info
the order details table will store the venue name and the convert date. on the tickets, you can create a unique ticket number by using the orderID and converting the date to a time stamp, so if the concert date is 2011-10-5 and the order id is 12 your ticket number would be 121317787200:
To limit ticket sales, you will need to hand code logic to update the concertTicketsAvailable column after the transaction goes through, I cant offer a lot of support for this part, if you need help with that, I would suggest signing up for a premium incident where we could work with you in a one on one session.