Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
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...especially part where the data relationship between the booking table and customer table.
is this database relationship looks good? anybody can comment
Started by faith89, Mar 25 2010 12:25 AM
3 replies to this topic
#1
Posted 25 March 2010 - 12:25 AM
faith89
-
- Members
-
- 14 posts
Newbie
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...especially part where the data relationship between the booking table and customer table.
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...especially part where the data relationship between the booking table and customer table.
Back to top|
|
|
#2
Posted 25 March 2010 - 07:21 AM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
It looks OK to me.
#3
Posted 25 March 2010 - 09:53 PM
chirag.jain18
-
- Members
-
- 10 posts
Newbie
I dont understand why relation between booking and room and room and roomtype is one to many? As booking id is primary key,one booking id will have only one corresponding room id. Similarly,one roomid will have only one corresponding roomtype id
#4
Posted 26 March 2010 - 04:48 PM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
A room will have multiple bookings. Similarly, a room type will have multiple rooms.
