Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

Coldfusion Reservations Site

I am familiar with access and coldfusion and how they interact.  I would like to figure out how to setup a site that people can make reservations on.  The database would have a set number of reservations and a waitlist that would open once the reservations were maxed.  Any guidance?
0
bjv211
Asked:
bjv211
1 Solution
 
James RodgersWeb Applications DeveloperCommented:
yes - first dump access
access is ok for testign and for single user or a maximum user group of 5 connections after that the usability deteriorats and access is memory intesive and expands to consume more harddrive spce with every read/write, use oracle or sql, if you don't have the money then get mysql, its free.

next database design
you need to normalize all your data in order to reduce redundant data being carried in multple tables, if you are not familiar with data normalization then you will need some help, this is a big part of making data storage and reteival easier

tables - off teh top of my head
Members - you will need some kind of members or user list to track the major details of the site users, the kind of info you gather will depend on your site needs,
memberid (pk), lastName, firstName, email, address, phone ... you get the idea

reservationdetails
resid, typeid, locationid, maxreservations, costper (maybe, only if cost per reservation is fixed), closeDate

reservationamenities
resid, amenityId

amenities
amenityId, amenityDesc

reservationList
memberId, resId, dateResMade (inc time), deposit (y/n), depositType(cash, cc etc.), depositAmount

resType (used if you take multiple reservation types, air, bus, train, hotel, restraunt etc.)
typeID, typeDesc

like i said just off the top of my head, without having more details it would be impossiblre to properly desing a database

once the db is designed the input output is easier to design and implement
0
 
bjv211Author Commented:
ok so i'll look into mySQL and get back to you, thanks for the start.  Oh sorry not to specify that this is a reservations site for tickets at a play theater.  So the info collected would be name address phone email quantity date of performance.  There would need to be a maximum of tickets reserved and then once those are filled, a waitlist.  In any case i'll try to get mySQL since you say that Access will be too much for multiple users.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now