coffee_bean
asked on
Reservation system for resources for 365days?
How to design a reservation system for resources that user can book any time & day they select?
Currently, my application design only do booking for today. As:
I am using a JTable to populate a list of resources with details for user to view. It also indicate the block of time that other user had booked. I joined the workstation table, pc table, peripheral table, and timeslot table. When a user booking is successful it will insert the name of the user to the block of time booked in this timeslot table.
I do have a Reservation table where by it stores all the reservation details such as the date, time, the workstation reserved, user id etc.
However, I can't possibly create a timeslot table for the 365days. It didn't make sense. How is such system(reservation system) implemented for real/in the market?
Currently, my application design only do booking for today. As:
I am using a JTable to populate a list of resources with details for user to view. It also indicate the block of time that other user had booked. I joined the workstation table, pc table, peripheral table, and timeslot table. When a user booking is successful it will insert the name of the user to the block of time booked in this timeslot table.
I do have a Reservation table where by it stores all the reservation details such as the date, time, the workstation reserved, user id etc.
However, I can't possibly create a timeslot table for the 365days. It didn't make sense. How is such system(reservation system) implemented for real/in the market?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I still don't get what you mean :-(
What do you mean by "I can't create a timeslot for 365days"
Sorry... It's probably too early in the morning ;-)
What do you mean by "I can't create a timeslot for 365days"
Sorry... It's probably too early in the morning ;-)
ASKER
i meant Timeslot table inside Microsoft Access database.
This timeslot table is where I had columns of the time (eg0830,0930 ...etc)
Timeslot table is one of the tables I used it to joined it with workstation table, pc table, peripheral table. so that I can display the columns of timeslot together with other workstation details. Whenever user successfully reserve a workstation, it will insert their name and user id into this Timeslot table.
Screenshot if it helps.
http://acupofcoffee.multiply.com/photos/photo/6/1.jpg
This timeslot table is where I had columns of the time (eg0830,0930 ...etc)
Timeslot table is one of the tables I used it to joined it with workstation table, pc table, peripheral table. so that I can display the columns of timeslot together with other workstation details. Whenever user successfully reserve a workstation, it will insert their name and user id into this Timeslot table.
Screenshot if it helps.
http://acupofcoffee.multiply.com/photos/photo/6/1.jpg
Yeah, what I meant was instead of creating a table with a column for every time over a year, and a row for every resource, just create a table where it has a start time, and end time, and a resource id...
You can then find timeslots for a specified time by using a "where" clause in your SQL
You can then find timeslots for a specified time by using a "where" clause in your SQL
ASKER
no no this qn has not been abondon. I will close this question myself. Thanks.
ASKER
Tim Yates, bochgoch
Thanks for the advice. I have closed this qn.
Thanks for the advice. I have closed this qn.
ASKER
>>I do have a Reservation table where by it stores all the reservation details such as the date, time, the workstation reserved, user id etc.
Here is a screenshot of my resource reservation if it's helps. It's still very basic at the moment.
http://acupofcoffee.multiply.com/photos/photo/5/1.jpg
You see my table has the time block (columns) and information of the user who booked at that timeslot.
I can do so becos I had a table (timeslot) that is created to handle reservation for that day. Whenever user successfully reserve a workstation, the name +id of the user is inserted into the timeslot table.
As said, I can't create a timeslot for 365days. So how am I suppose to create a table view of the resources, their timeslot availability and info of the user who booked on that slot??