silvery — 2010-03-25T04:35:03-04:00 — #1
i have created a database for a room reservation. for this database i'm using mysql phpmyadmin.
Right now it's just have the simple basic data that needed in the database. I hope someone can commeneted wether this database relationship look good or not...(eventhough i'm using mysql, i just make the ERD in access so that i can see relationship between the tables) especially part where the data relationship between the booking table and customer table.
guido2004 — 2010-03-25T04:46:40-04:00 — #2
The relationships look good to me.
dr_john — 2010-03-27T03:09:15-04:00 — #3
What if there was a party booking for, say, 10 people wanting five rooms?
You'd be recording five bookings against the one customer using that design. So you might need a link table between booking and room, with just the two table ids, removing roomid from the booking table. Assuming that the one customer making the party booking was paying for it all.