3 edited title
| link

Hotel Managment -Management database

2 grammar and spelling, formatting
source | link

I need help with the design of my databaseschema.

  I'm almost new at this and i'mI'm not sure ifwhether my relationships in database are correct between the tables ROOMROOM, GUESTGUEST and RESERVATION??RESERVATION below are correct.

Also i, I have problem withproblems figuring out what to do with possibillityregarding the possibility of ROOM CHANGE (example: An example: 

Michael Keaton has one reservation in which he took two rooms. FirstThe first time, he didn't like the room so the hotel moved him to another room, and the second time there was pluminga plumbing problem in the same room so they moved him again. DatabaseMy database needs to keep all datarecord about every room change.) I give you my database picture with some explanation on it (1:N means one to many

Here's the entity relationship)....Thanx in advance diagram:-)

http://i.imgur.com/RmkIrap.jpgER diagram

I need help with my database.

  I'm almost new at this and i'm not sure if my relationships in database are correct between tables ROOM, GUEST and RESERVATION??

Also i have problem with figuring what to do with possibillity of ROOM CHANGE (example: Michael Keaton has one reservation in which he took two rooms. First time he didn't like the room so hotel moved him to another room, and second time there was pluming problem in the same room so they moved him again. Database needs to keep all data about every room change.) I give you my database picture with some explanation on it (1:N means one to many relationship)....Thanx in advance:-)

http://i.imgur.com/RmkIrap.jpg

I need help with the design of my schema. I'm almost new at this and I'm not sure whether my relationships between the tables ROOM, GUEST and RESERVATION below are correct.

Also, I have problems figuring out what to do regarding the possibility of ROOM CHANGE: An example: 

Michael Keaton has one reservation in which he took two rooms. The first time, he didn't like the room so the hotel moved him to another room, and the second time there was a plumbing problem in the same room so they moved him again. My database needs to keep record about every room change.

Here's the entity relationship diagram:

ER diagram

1
source | link

Hotel Managment - database

I need help with my database.

I'm almost new at this and i'm not sure if my relationships in database are correct between tables ROOM, GUEST and RESERVATION??

Also i have problem with figuring what to do with possibillity of ROOM CHANGE (example: Michael Keaton has one reservation in which he took two rooms. First time he didn't like the room so hotel moved him to another room, and second time there was pluming problem in the same room so they moved him again. Database needs to keep all data about every room change.) I give you my database picture with some explanation on it (1:N means one to many relationship)....Thanx in advance:-)

http://i.imgur.com/RmkIrap.jpg