How to calculate cost per every day(cost hotel + cost flight) depending on flight date ?

SQLServerCentral » Latest topics

How to calculate cost per every day(cost hotel + cost flight) depending on flight date ?

I need to make database design relations   to  calculate cost per tour for tourists in Egypt
Flight  cost + hotel cost per every day for person based on flight date
Suppose I have flight

more info...