Help needed to design database for online ticket booking

  • I have to create local database and remote database.

    i want to update database when ever the changes comes(update both database)..

    example:

    in online ticket booking , user can book ticket on web and in cinema theater itself.

    whenever the user book a seat , need to update both databases.

    please suggest some ideas for this problem??

    my idea to keeping local and remote database may be wrong .

    please help me to find out a solution??????????????????????

  • Hi,

    Why do you need two databases? What is the advantage of having two databases?

    Having one database with a good backup strategy is enough. This is in use at quite big systems.

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com

  • k. thnkx

  • if we use desktop application and web application for ticket booking,

    how the database will update:

    in booking ticket using web and desktop application concurrently..?????

  • have the desktop application e use some web services you will need to create whichreturn available tickets and another to book tickets.

    maybe an additional web service so you can see what has already been booked foir admin purposes.

    That way everything is centralized at one location(the web database), but can be extended to a desktop applicaiton, and then a iphone app, and then an android app,blackberry,kindle etc.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply