i need to design a database for real estate agency, the price is based on the size of the unit multiplied with the meter price, for example if an unit size is 200 meter and the price for 1 meter is 10 US$ so the price for this unit is 2000 US$.
the problem i face now is i need to but the price in multi currency in a separate table so i can change it easily, like this:-
table1 (unit_id, unit_size, unit_finish, Unit Description)
table 2(price_standard_US$, price_turn_key_US$, price_standard_EUR, price_turn_key_EUR)
the problem now i can't make a relationship between those tables, any ideas?
Thanks a lot in advance for your help and time