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.