Event Booking Database Module

• Robert Fyffe

  Valued Member

  Points: 63

  More actions

  October 25, 2010 at 12:06 pm

  #228415

  Hi Everyone,

  I'm, new to this forum and was recommended it by a friend.

  I am new to database design so I have been working on MySQL Workbench to try design a database for an event booking system.

  So far my EER diagram looks like the attached image and I'm looking for some advice/help on weather it is the best way to do it and how I could improve it etc.

  How I want the system to work is the administrator will create a new event including Name, Date, Price, Ticket Types etc which will then be stored in the relevant DB tables. The customer can then select this event along with a ticket type o nthe front end and complete a form to purchase.

  I would really appreciate some help on this as I am very keen to learn more.

  Thanks

  Robert