firstly if possible are relation between package and flight
and package and hotel 
and package and transfer
and package and excursion is correct or wrong this is main question i...

Can you help me to do calculate for flight and transfer and excursion and hotel
or you can tell me any one from above and i will do others

to get details for day i write following :
SELECT   dbo.Package.PackageID, dbo.Package.PackageName, dbo.Package.Duration, dbo.PackageDuration.PackageDuration, dbo.DurationDetails.Days,
         dbo.DayDetails.FlightTypeID, dbo.DayDetails.HotelID, dbo.DayDetails.ExcursionID, dbo.DayDetails.TransferTypeID
FROM    dbo.Package INNER JOIN
         dbo.PackageDuration ON dbo.Package.PackageID = dbo.PackageDuration.PackageID INNER...

Thank you 
I dont request from us do home work for me
but i give you all details to help me
but until now now any one can help so...

if you see this image it will explain every thing in my database
and every thing i need to do it

USE [NileTravel]
GO
/****** Object: Table [dbo].[DayDetails]  Script Date: 05/07/2017 9:08:12 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DayDetails](
    [DayDetailsID] [int] NOT...

data as following
USE [NileTravel]
GO
INSERT [dbo].[Type] ([ProgramTypeID], [ProgramType]) VALUES (1, N'NileCruize')
INSERT [dbo].[Type] ([ProgramTypeID], [ProgramType]) VALUES (2, N'Sun')
INSERT [dbo].[Type] ([ProgramTypeID], [ProgramType]) VALUES (3, N'Sea')
INSERT...

this is my DDL
USE [NileTravel]
GO
/****** Object: Table [dbo].[DayDetails]  Script Date: 05/07/2017 3:20:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE...

thank you for reply
this is my diagram

Actually i need to is to know is to calculate cost of flight and hotel and transfer and excursion per every day based on program duration

Days | Hotel | Flight | transfers
 Day1 | Hilton | amsterdam to luxor |
airport to hotel ||
Day2 | Hilton |   | AbuSimple...

I need to get cost of hotel and flight based on table duration details table as following

Thank you for reply
what i do as following
CREATE TABLE program( ProgramID int primary key not null, ProgramName varchar(30) ) GO insert into program values(1,'Alexia'),(2,'Amon'),(3,'Sfinx') GOCREATE...

thank you for reply
I have designed my database as following
my problem How to join between days and costs like screen shoot above
day1 
day2
day3
cost per day1

thank you for reply
i can give you any details you need 
Calculation of hotel cost and flight cost depend on fixed program tour as image below
in left picture program for 15...