Thank you for reply
in start package table 
I need to write sql query  calculate hotel costs between two periods per package and the final result must show in total...

full script for database 
Im sorry for errors
USE [NileTravel3]
GO
/****** Object: Table [dbo].[DayDetails]  Script Date: 14/07/2017 11:16:59 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER...

are any thing not clear

thank you for reply
im sorry for post in multi thread 
Why are package and package duration different tables?
because package have multi duration
Do packages have multiple duration? 
yes...

I have more questions 
first question
I have relation between hotel table and package and in same time have relation between hotel and day details table are this circular reference 

this is database design expected to website http://www.egypte.nl
* every package have only one hotel .
* every package have only one program .
* package have more duration may be...

can you help me please i will work and if some thing wrong tell me please

I need to do design site like that and i have some problem to design database

i start building what i need from first step by step
cbecause i have some point problem before i write i must introduce to it

I will work then if you see any thing wrong help me .
I need to make database design to booking hotel and program tourists
to  this site from scratch

im sorry for late 
this is actually what i need 
thanks

OK actually i face problem
in my design above i make relation between
hotel and package to assign period per hotel
and
hotel and day of package to get cost

Thank you for reply
this is my result
HiltonPackage    4    3    day1    1    1    1    1    1    1    1    ms750    2017-07-01 00:00:00.000
HiltonPackage    4    3    day4    4    4    2    1    NULL    NULL    2    ms800    2017-08-02 00:00:00.000

because if design is correct i can clcultae correctly