Библиографический список

1 Евсеева О.Н., Работа с базами данных на языке С#. Технология АDO.NET / О.Н. Евсеева, А.Б. Шамшев – Ульяновск: УГТУ, 2009. – 171 с.

2 Бейли, Л. Изучаем SQL / Линн Бейли; пер. с англ. Е. Матвеева. – СПб.: Питер, 2012. – 592 с.

3 Дейт, К. Введение в системы базы данных / Крис Дейт; пер. с англ. К. Птицина – Киев:Вильямс, 2006. – 1328 с.

 

ПРИЛОЖЕНИЕ А

CREATETABLE[dbo].[airplanes_race](

[_id][int]IDENTITY(1,1)NOTNULL,

[name][nvarchar](50)NOT NULL,

[cost][money]NULL,

CONSTRAINT[PK_airplanes_race]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

CREATETABLE[dbo].[excurs](

[_id][int]IDENTITY(1,1)NOTNULL,

[name][nvarchar](50)NOTNULL,

[cost][money]NULL,

CONSTRAINT[PK_excurs]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

CREATETABLE[dbo].[excurs_agency](

[_id][int]IDENTITY(1,1)NOTNULL,

[name][nvarchar](50)NOT NULL,

[multiply_cost][float]NULL,

CONSTRAINT[PK_excurs_agency]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

CREATETABLE[dbo].[excurs_summary](

[_id][int]IDENTITY(1,1)NOTNULL,

[tourist_id][int] NOTNULL,

[excurs_id][int]NOT NULL,

[agency_id][int]NOT NULL,

[date][date]NULL,

CONSTRAINT[PK_excurs_summary]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

 

CREATETABLE[dbo].[hotels](

[_id][int]IDENTITY(1,1)NOTNULL,

[name][nvarchar](50)NOTNULL,

[cost][money]NOTNULL,

CONSTRAINT[PK_hotels]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

 

CREATETABLE[dbo].[income_category](

[_id][int]IDENTITY(1,1)NOTNULL,

[name][nvarchar](50)NOTNULL,

CONSTRAINT[PK_income_category]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

 

CREATETABLE[dbo].[income_summary](

[_id][int]IDENTITY(1,1)NOTNULL,

[income_id][int]NOTNULL,

[total][money]NOTNULL,

[date][date]NOTNULL,

[tour_id][int]NOTNULL,

CONSTRAINT[PK_income_summary]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

 

CREATETABLE[dbo].[outcome_summary](

[_id][int]IDENTITY(1,1)NOTNULL,

[outcome_id][int]NOTNULL,

[total][money]NOTNULL,

[date][date]NOTNULL,

[tour_id][int]NOTNULL,

CONSTRAINT[PK_outcome_summary]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

 

CREATETABLE[dbo].[tourist](

[_id][int]IDENTITY(1,1)NOTNULL,

[fio][nvarchar](50)NOTNULL,

[passport][nvarchar](50)NOTNULL,

[sex][nchar](10)NOTNULL,

[birhday][date]NOTNULL,

CONSTRAINT[PK_tourist]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

 

CREATETABLE[dbo].[tours](

[_id][int]IDENTITY(1,1)NOTNULL,

[tourist_id][int]NOTNULL,

[type_tourist_id][int]NOTNULL,

[hotel_id][int]NOTNULL,

[hotel_room_n][int]NOTNULL,

[start_day][date]NOTNULL,

[end_date][date]NOTNULL,

[start_race_id][int]NOTNULL,

[end_race_id][int]NOTNULL,

CONSTRAINT[PK_tours]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

 

CREATETABLE[dbo].[type_tourist](

[_id][int]IDENTITY(1,1)NOTNULL,

[name][nvarchar](50)NOTNULL,

CONSTRAINT[PK_type_tourist]PRIMARYKEYCLUSTERED

(

[_id]ASC

 

DROPTABLE [airplanes_race]

DROPTABLE [excurs]

DROPTABLE [excurs_agency]

DROPTABLE [excurs_summary]

DROPTABLE [hotels]

DROPTABLE [income_category]

DROPTABLE [income_summary]

DROPTABLE [outcome_summary]

DROPTABLE [tourist]

DROPTABLE [tours]

DROPTABLE [type_tourist]