i want to develop a apointment booking system. but not able to create right database structer. please help me with a database schema. this project will be in php, so it would be very good if you tell me how to show avalible apointment time in a calender. sorry if i ask noncence type question, but i really need help.
You are going to need a large number of tables, it's not practical to detail what the structure should be here. First up, have a look at the systems that already exist and either go through them and their databases so that you understand what they've done and why. If you can't get access because the system is proprietary you should be able to still see some screen shots or maybe a demo which will give you an idea of the type of data being collected. Then you need to look at what you want your system to do. What can you leave out? What needs to be added in? Are you going to use a base system like WordPress or Joomla to handle user management or do you need to build in all that security/user stuff? Once you've got your business plan drawn up you'll have a better idea about data collection and competitors etc.
The question has been asked many times before, try google for example and you come up with this http://stackoverflow.com/questions/267579/how-would-i-make-a-calendar-appointment-scheduler-in-php You could take a look at a fairly complex application to see how they structure their database in order to get an idea on how to structure yours http://sourceforge.net/projects/phpscheduleit/