Page 1 of 1

is this database relationship looks good? anybody can commen

Posted: Thu Mar 25, 2010 3:38 am
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.

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

Posted: Fri Mar 26, 2010 1:15 am
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).