hotel reservation system table design

No one here to tell you about table design..you have set your logic for this.
You need to clear your database concept first.

have an idea about hotel reservation
Do you have any idea on what all features would be there in hotel reservation? Even if someone gives you DB, how will you work out?

Now, DB design would happen but it would greatly depend on kind of features your application would provide. It's your application, your features, how come we can design a DB for you?

No doubt, this is your college project. You should put some effort.

We expect you to put some time in trying the issue that you are facing and then some time in formulating the question while posting here. Right now, I see both missing. :doh:

Here is what is expected by enquirers:
1. TRY first what you want to do!
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.