CAR HIRE

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 373,931 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,295 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser:

Thread Tools Display Modes

Views: 1092 | Replies: 6

Previous Post in Thread

Next Post in Thread

•

Join Date: Jul 2006

Posts: 14

Reputation: salim is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

salim

Offline

Newbie Poster

CAR HIRE

Mar 18th, 2008

I am trying to design a web base system for A1 Holloway car hire, I am not sure about my Entity Relationship diagram as when I try to make the relationship between two table it never goes the way, here it is:

booking_tbl ( PK booking_id, FK vehicle_reg, FK customer_id, booking date, booking duration)

vehicle_tbl ( vehicle_reg, vehicle coulour, vehicle make, vehicle)

relationship between two tables is as follow
booking_tbl m: 1 vehicle_tbl ( many to one)

but it shows the opposite ? would that be because booking_tbl has a compound PK key ( more than PK and some FK)

Note that I haven't included the other table ( customer )as i only have the problem with this relationship between those two tables.
thanks