I'm creating database for travel agency, when the sales agent chose the hotel they chose also the check in and check out date.
in the back office the hotel rates are entered and each hotel has different periods with different rates.
i was able to get the rate when the check in and check out is falling in 2 periods by relating the check-in date the table and relating the check-out date to the table occurrence
>>>> but faced a problem when its falling into 3 periods like the in the first and second pics above
and if its more than 3.
hope you can help solving this problem.
this is my first post and i wanna thank everyone here as this website has been one of my best references.