Прoeктирoвaниe ceтeвoй бaзы дaнныx "Aэрoпoрт"

FROM dbo.airplan INNER JOIN

dbo.fly ON dbo.airplan.airplan_id = dbo.fly.airplan_id INNER JOIN

dbo.pilot ON dbo.airplan.pilot_id = dbo.pilot.pilot_id INNER JOIN

dbo.place ON dbo.fly.place_id = dbo.place.place_id INNER JOIN

dbo.terminal ON dbo.fly.terminal_id = dbo.terminal.terminal_id

GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]

Begin DesignProperties =

Begin PaneConfigurations =

Begin PaneConfiguration = 0

NumPanes = 4

Configuration = "(H (1[40] 4[20] 2[20] 3) )"

End

Begin PaneConfiguration = 1

NumPanes = 3

Configuration = "(H (1 [50] 4 [25] 3))"

End

Begin PaneConfiguration = 2

NumPanes = 3

Configuration = "(H (1 [50] 2 [25] 3))"

End

Begin PaneConfiguration = 3

NumPanes = 3

Configuration = "(H (4 [30] 2 [40] 3))"

End

Begin PaneConfiguration = 4

NumPanes = 2

Configuration = "(H (1 [56] 3))"

End

Begin PaneConfiguration = 5

NumPanes = 2

Configuration = "(H (2 [66] 3))"

End

Begin PaneConfiguration = 6

NumPanes = 2

Configuration = "(H (4 [50] 3))"

End

Begin PaneConfiguration = 7

NumPanes = 1

Configuration = "(V (3))"

End

Begin PaneConfiguration = 8

NumPanes = 3

Configuration = "(H (1[56] 4[18] 2) )"

End

Begin PaneConfiguration = 9

NumPanes = 2

Configuration = "(H (1 [75] 4))"

End

Begin PaneConfiguration = 10

NumPanes = 2

Configuration = "(H (1[66] 2) )"

End

Begin PaneConfiguration = 11

NumPanes = 2

Configuration = "(H (4 [60] 2))"

End

Begin PaneConfiguration = 12

NumPanes = 1

Configuration = "(H (1) )"

End

Begin PaneConfiguration = 13

NumPanes = 1

Configuration = "(V (4))"

End

Begin PaneConfiguration = 14

NumPanes = 1

Configuration = "(V (2))"

End

ActivePaneConfig = 0

End

Begin DiagramPane =

Begin Origin =

Top = 0

Left = 0

End

Begin Tables =

Begin Table = "airplan"

Begin Extent =

Top = 6

Left = 38

Bottom = 121

Right = 199

End

DisplayFlags = 280

TopColumn = 0

End

Begin Table = "fly"

Begin Extent =

Top = 6

Left = 237

Bottom = 201

Right = 398

End

DisplayFlags = 280

TopColumn = 0

End

Begin Table = "pilot"

Begin Extent =

Top = 6

Left = 436

Bottom = 91

Right = 597

End

DisplayFlags = 280

TopColumn = 0

End

Begin Table = "place"

Begin Extent =

Top = 96

Left = 436

Bottom = 215

Right = 597

End

DisplayFlags = 280

TopColumn = 0

End

Begin Table = "terminal"

Begin Extent =

Top = 126

Left = 38

Bottom = 211

Right = 201

End

DisplayFlags = 280

TopColumn = 0

End

End

End

Begin SQLPane =

End

Begin DataPane =

Begin ParameterDefaults = ""

End

End

Begin CriteriaPane =

Begin ColumnWidths = 11

Column = 1440

Alias = 900

Table = 1170

Output = 720

Append = 1400

NewValue = 1170

SortType = 1350

SortOrder = 1410

GroupBy = 1350

Filter = 1350

Or = 1350

Or = 1350

Or = 1350

En' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'FLY_VIEW'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'd

End

End

' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'FLY_VIEW'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'FLY_VIEW'

GO

/****** Object: StoredProcedure [dbo].[GET_FLY_BY_PLACE] Script Date: 06/06/2011 23:58:37 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: <Author,,Name>

-- Create date: <Create Date,,>

-- Description: <Description,,>

-- =============================================

CREATE PROCEDURE [dbo].[GET_FLY_BY_PLACE]

@PLACE_ID int

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

-- Insert statements for procedure here

SELECT time_in, time_out, place_name, airplan_number, airplan_name

from FLY_VIEW where place_id = @PLACE_ID

END

GO

/****** Object: ForeignKey [FK_airplan_pilot] Script Date: 06/06/2011 23:58:03 ******/

ALTER TABLE [dbo].[airplan] WITH CHECK ADD CONSTRAINT [FK_airplan_pilot] FOREIGN KEY([pilot_id])

REFERENCES [dbo].[pilot] ([pilot_id])

GO

ALTER TABLE [dbo].[airplan] CHECK CONSTRAINT [FK_airplan_pilot]

GO

/****** Object: ForeignKey [FK_fly_airplan] Script Date: 06/06/2011 23:58:03 ******/

ALTER TABLE [dbo].[fly] WITH CHECK ADD CONSTRAINT [FK_fly_airplan] FOREIGN KEY([airplan_id])

REFERENCES [dbo].[airplan] ([airplan_id])

GO

ALTER TABLE [dbo].[fly] CHECK CONSTRAINT [FK_fly_airplan]

GO

/****** Object: ForeignKey [FK_fly_place] Script Date: 06/06/2011 23:58:03 ******/

ALTER TABLE [dbo].[fly] WITH CHECK ADD CONSTRAINT [FK_fly_place] FOREIGN KEY([place_id])

REFERENCES [dbo].[place] ([place_id])

GO

ALTER TABLE [dbo].[fly] CHECK CONSTRAINT [FK_fly_place]

GO

/****** Object: ForeignKey [FK_fly_terminal] Script Date: 06/06/2011 23:58:03 ******/

ALTER TABLE [dbo].[fly] WITH CHECK ADD CONSTRAINT [FK_fly_terminal] FOREIGN KEY([terminal_id])

REFERENCES [dbo].[terminal] ([terminal_id])

GO

ALTER TABLE [dbo].[fly] CHECK CONSTRAINT [FK_fly_terminal]

GO

Размещено на Allbest.ru