is this database relationship looks good? anybody can commen

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
polly89
Forum Newbie
Posts: 8
Joined: Thu Mar 18, 2010 9:44 am

is this database relationship looks good? anybody can commen

Post by polly89 »

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.
Attachments
roomreservation ERD.png
roomreservation ERD.png (22.75 KiB) Viewed 392 times
DaiLaughing
Forum Commoner
Posts: 76
Joined: Thu Jul 16, 2009 8:03 am

Re: is this database relationship looks good? anybody can commen

Post by DaiLaughing »

PHPMyAdmin comes with a design view which works much like Access's ERD tool.

There are a couple of problems if you want to normalise properly but it should work fine like that.

The problems I saw are the calculated fields which in normalisation is not acceptable but in the real world make sense (because yours allow you to change the room type price but still record the price charged for a booking).
Post Reply