Scribd
Upload
45 views8 pages

Análisis de Datos de Aerolínea SENA

This document contains the SQL script for creating the database tables for an airline database. The tables created are Pasajeros (Passengers), Aviones (Aircrafts), Rutas (Routes), Vuelos (Flights), and PasaVuelos (PassengerFlights). Primary keys are defined for each table and foreign key constraints are created between the tables to link them together.

Uploaded by

dianabalcero52
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
45 views8 pages

Análisis de Datos de Aerolínea SENA

This document contains the SQL script for creating the database tables for an airline database. The tables created are Pasajeros (Passengers), Aviones (Aircrafts), Rutas (Routes), Vuelos (Flights), and PasaVuelos (PassengerFlights). Primary keys are defined for each table and foreign key constraints are created between the tables to link them together.

Uploaded by

dianabalcero52
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

TRABAJO:

BASE DE DATOS

NOMBRE:
DIANA MILENA BALCERO PRIMO
40130

ANALISIS Y DESARROLLO DEL SISTEMA DE INFORMACION


SENA
BOGOTA D.C 2010
TRABAJO:
BASE DE DATOS

ENTREGADO POR:
DIANA MILENA BALCERO PRIMO
40130

PARA:
SANDRA RUEDA

ANALISIS Y DESARROLLO DEL SISTEMA DE INFORMACION


SENA
BOGOTA D.C 2010
TALLER DE AEROLINIA HECHO POR EN EL DISEÑADOR

SCRIPT
USE [AEROLINEA]

GO

/****** Object: Table [dbo].[Pasajeros] Script Date: 08/09/2010 [Link] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO
CREATE TABLE [dbo].[Pasajeros](

[P_IdenPasa] [int] NOT NULL,

[P_NombPasa] [varchar](35) NOT NULL,

[P_Direccion] [varchar](35) NOT NULL,

[P_Telefono] [int] NOT NULL,

CONSTRAINT [PK_Pasajeros] PRIMARY KEY CLUSTERED

[P_IdenPasa] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,


IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object: Table [dbo].[Aviones] Script Date: 08/09/2010 [Link] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Aviones](

[A_CodiAvi] [int] NOT NULL,

[A_Descripcion] [varchar](35) NOT NULL,

[A_Capacidad] [int] NOT NULL,


CONSTRAINT [PK_Aviones] PRIMARY KEY CLUSTERED

[A_CodiAvi] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,


IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object: Table [dbo].[Rutas] Script Date: 08/09/2010 [Link] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Rutas](

[R_CodiRuta] [int] NOT NULL,

[R_Destino] [varchar](35) NOT NULL,

[R_ValorPasa] [money] NOT NULL,

CONSTRAINT [PK_Rutas] PRIMARY KEY CLUSTERED

[R_CodiRuta] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,


IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object: Table [dbo].[Vuelos] Script Date: 08/09/2010 [Link] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Vuelos](

[V_NumeVuelo] [int] NOT NULL,

[V_CodiAvi] [int] NOT NULL,

[V_CodiRuta] [int] NOT NULL,

[V_FechaVuelo] [datetime] NOT NULL,

[V_Comfirmado] [bit] NOT NULL,

CONSTRAINT [PK_Vuelos_1] PRIMARY KEY CLUSTERED

[V_NumeVuelo] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,


IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object: Table [dbo].[PasaVuelos] Script Date: 08/09/2010 [Link]


******/

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[PasaVuelos](

[PA_NumeVuelo] [int] NOT NULL,

[PA_IdenPasa] [int] NOT NULL,

CONSTRAINT [PK_PasaVuelos_1] PRIMARY KEY CLUSTERED

[PA_NumeVuelo] ASC,

[PA_IdenPasa] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,


IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object: ForeignKey [FK_Vuelos_Aviones] Script Date: 08/09/2010


[Link] ******/

ALTER TABLE [dbo].[Vuelos] WITH CHECK ADD CONSTRAINT


[FK_Vuelos_Aviones] FOREIGN KEY([V_CodiAvi])

REFERENCES [dbo].[Aviones] ([A_CodiAvi])

GO

ALTER TABLE [dbo].[Vuelos] CHECK CONSTRAINT [FK_Vuelos_Aviones]

GO

/****** Object: ForeignKey [FK_Vuelos_Rutas] Script Date: 08/09/2010


[Link] ******/

ALTER TABLE [dbo].[Vuelos] WITH CHECK ADD CONSTRAINT


[FK_Vuelos_Rutas] FOREIGN KEY([V_CodiRuta])
REFERENCES [dbo].[Rutas] ([R_CodiRuta])

GO

ALTER TABLE [dbo].[Vuelos] CHECK CONSTRAINT [FK_Vuelos_Rutas]

GO

/****** Object: ForeignKey [FK_PasaVuelos_Pasajeros] Script Date:


08/09/2010 [Link] ******/

ALTER TABLE [dbo].[PasaVuelos] WITH CHECK ADD CONSTRAINT


[FK_PasaVuelos_Pasajeros] FOREIGN KEY([PA_IdenPasa])

REFERENCES [dbo].[Pasajeros] ([P_IdenPasa])

GO

ALTER TABLE [dbo].[PasaVuelos] CHECK CONSTRAINT


[FK_PasaVuelos_Pasajeros]

GO

/****** Object: ForeignKey [FK_PasaVuelos_Vuelos] Script Date: 08/09/2010


[Link] ******/

ALTER TABLE [dbo].[PasaVuelos] WITH CHECK ADD CONSTRAINT


[FK_PasaVuelos_Vuelos] FOREIGN KEY([PA_NumeVuelo])

REFERENCES [dbo].[Vuelos] ([V_NumeVuelo])

GO

ALTER TABLE [dbo].[PasaVuelos] CHECK CONSTRAINT


[FK_PasaVuelos_Vuelos]

GO

You might also like