Create Table

CREATE TABLE [AEROLINEA] ( [RUC] [NOMBRE] ) go char(11) NOT NULL , varchar(40) NOT NULL ALTER TABLE [AEROLINEA] ADD CO

Views 111 Downloads 0 File size 236KB

Recommend stories

Create Table CLIENTES

create table CLIENTES ( NUM_CLIE INTEGER not null, EMPRESA VARCHAR (50)not null, REP_CLIE INTEGER not null, LIMITE_CREDI

0 0 271KB Read more

Create Table Person( Id Integer, Firstname Varchar, Lastname Varchar ); Create Table Student( Credit Varchar )

CREATE TABLE Person( id Integer, firstName Varchar, lastName Varchar ); CREATE TABLE Student( credit Varchar ) INHERITS

6 0 557KB Read more

fox create

Raindrop the little Fox by Zipzipdreams This is the original pattern of Raindrop the little Fox by Elif T. This purchas

38 2 2MB Read more

How to Create a Custom SOLIDWORKS Sheet Metal Bend Table

10/18/2017 How to create a Custom SOLIDWORKS Sheet Metal Bend Table HOME TECH TIPS SOLIDWORKS 2018 WEBSITE Search

25 0 830KB Read more

Create ABAP Dialog Screen Dynpro Table Control Within SAP

31 0 259KB Read more

Create: Tblusuarios

40 1 602KB Read more

Coffee Table

47 1 3MB Read more

Erlang Table

Erlang B Traffic Table Maximum Offered Load Versus B and N B is in % 0.5 1.0 2 5 10 N/B 0.01 0.05 0.1 15 20 30 4

47 3 23KB Read more

Ei-table

Reservoir Eng Hndbk Ch 06a 2001-10-25 11:23 Page 377 377 Fundamentals of Reservoir Fluid Flow Table 6-1 Values of the

46 1 93KB Read more

Integral Table

57 14 144KB Read more

Author / Uploaded
JanethHallasiYucra

Citation preview

CREATE TABLE [AEROLINEA] ( [RUC] [NOMBRE] ) go

char(11) NOT NULL , varchar(40) NOT NULL

ALTER TABLE [AEROLINEA] ADD CONSTRAINT [XPKAEROLINEA] PRIMARY KEY go CREATE TABLE [AEROPUERTO] ( [IDAERO] [NOMBRE] [IDPAIS] ) go

NONCLUSTERED ([RUC] ASC)

char(5) NOT NULL , varchar(40) NOT NULL , char(4) NOT NULL

ALTER TABLE [AEROPUERTO] ADD CONSTRAINT [XPKAEROPUERTO] PRIMARY KEY ASC) go

NONCLUSTERED ([IDAERO]

CREATE NONCLUSTERED INDEX [XIF1AEROPUERTO] ON [AEROPUERTO] ( [IDPAIS] ASC ) go CREATE TABLE [APROVISIONAMIENTO] ( [IDAPROV] integer [FECHA] datetime [GALONES] integer [IDCOMBUSTIBLE] integer [IDRUTA] integer [IDAVION] char(5) ) go

NOT NULL , NOT NULL , NOT NULL , NOT NULL , NOT NULL , NOT NULL

ALTER TABLE [APROVISIONAMIENTO] ADD CONSTRAINT [XPKAPROVISIONAMIENTO] PRIMARY KEY CLUSTERED ([IDAPROV] ASC,[IDCOMBUSTIBLE] ASC,[IDRUTA] ASC,[IDAVION] ASC) go CREATE NONCLUSTERED INDEX [XIF1APROVISIONAMIENTO] ON [APROVISIONAMIENTO] ( [IDCOMBUSTIBLE] ASC ) go CREATE NONCLUSTERED INDEX [XIF2APROVISIONAMIENTO] ON [APROVISIONAMIENTO] ( [IDRUTA] ASC )

go CREATE NONCLUSTERED INDEX [XIF3APROVISIONAMIENTO] ON [APROVISIONAMIENTO] ( [IDAVION] ASC ) go CREATE TABLE [ASIENTO] ( [NUMVUELO] [LETRA] [FILA] ) go

int NOT NULL , char(2) NOT NULL , int NOT NULL

ALTER TABLE [ASIENTO] ADD CONSTRAINT [XPKASIENTO] PRIMARY KEY ASC) go CREATE TABLE [AVION] ( [IDAVION] [RUC] [COMPAÑIA] [TIPO] [PASAJEROS] [IDCOMBUSTIBLE] ) go

NONCLUSTERED ([NUMVUELO]

char(5) NOT NULL , char(11) NOT NULL , varchar(40) NOT NULL , varchar(30) NOT NULL , int NOT NULL , integer NOT NULL

ALTER TABLE [AVION] ADD CONSTRAINT [XPKAVION] PRIMARY KEY go

NONCLUSTERED ([IDAVION] ASC)

CREATE NONCLUSTERED INDEX [XIF1AVION] ON [AVION] ( [RUC] ASC ) go CREATE NONCLUSTERED INDEX [XIF2AVION] ON [AVION] ( [IDCOMBUSTIBLE] ASC ) go CREATE TABLE [COMBUSTIBLE] ( [IDCOMBUSTIBLE] integer NOT NULL , [NOMBRE] varchar(30) NOT NULL ) go ALTER TABLE [COMBUSTIBLE]

ADD CONSTRAINT [XPKCOMBUSTIBLE] PRIMARY KEY ([IDCOMBUSTIBLE] ASC) go CREATE TABLE [DETALLEEQUIPAJE] ( [IDEQUIPAJE] integer NOT [IDPASAJERO] char(5) NOT [UNIDAD] integer NOT [DETALLE] varchar(40) [PESO] numeric(7,2) [IDAVION] char(5) NOT ) go

CLUSTERED

NULL , NULL , NULL , NOT NULL , NOT NULL , NULL

ALTER TABLE [DETALLEEQUIPAJE] ADD CONSTRAINT [XPKDETALLEEQUIPAJE] PRIMARY KEY ([IDEQUIPAJE] ASC,[IDPASAJERO] ASC,[IDAVION] ASC) go

CLUSTERED

CREATE NONCLUSTERED INDEX [XIF1DETALLEEQUIPAJE] ON [DETALLEEQUIPAJE] ( [IDEQUIPAJE] ASC, [IDPASAJERO] ASC, [IDAVION] ASC ) go CREATE TABLE [EQUIPAJE] ( [IDEQUIPAJE] [IDPASAJERO] [IDAVION] ) go

integer char(5) char(5)

NOT NULL , NOT NULL , NOT NULL

ALTER TABLE [EQUIPAJE] ADD CONSTRAINT [XPKEQUIPAJE] PRIMARY KEY ASC,[IDPASAJERO] ASC,[IDAVION] ASC) go

CLUSTERED ([IDEQUIPAJE]

CREATE UNIQUE NONCLUSTERED INDEX [XIF1EQUIPAJE] ON [EQUIPAJE] ( [IDPASAJERO] ASC ) go CREATE NONCLUSTERED INDEX [XIF2EQUIPAJE] ON [EQUIPAJE] ( [IDAVION] ASC ) go CREATE TABLE [HORARIO] ( [IDHORARIO] [HORAARRIBO]

integer NOT NULL , char(10) NOT NULL ,

[HORALLEGADA]

char(10)

NOT NULL

) go ALTER TABLE [HORARIO] ADD CONSTRAINT [XPKHORARIO] PRIMARY KEY ASC) go CREATE TABLE [PAGO] ( [NUMPAGO] [IDRESERVA] [IDPASAJERO] [FECHA] [MONTO] ) go

CLUSTERED ([IDHORARIO]

int NOT NULL , int NOT NULL , char(5) NOT NULL , datetime NOT NULL , money NOT NULL

ALTER TABLE [PAGO] ADD CONSTRAINT [XPKPAGO] PRIMARY KEY ASC,[IDRESERVA] ASC,[IDPASAJERO] ASC) go

NONCLUSTERED ([NUMPAGO]

CREATE NONCLUSTERED INDEX [XIF1PAGO] ON [PAGO] ( [IDRESERVA] ASC ) go CREATE NONCLUSTERED INDEX [XIF2PAGO] ON [PAGO] ( [IDPASAJERO] ASC ) go CREATE TABLE [PAIS] ( [IDPAIS] [PAIS] ) go

char(4) NOT NULL , varchar(30) NOT NULL

ALTER TABLE [PAIS] ADD CONSTRAINT [XPKPAIS] PRIMARY KEY go CREATE TABLE [PASAJERO] ( [IDPASAJERO] [NOMBRES] [IDPAIS] [TELEFONO] [EMAIL] ) go

NONCLUSTERED ([IDPAIS] ASC)

char(5) NOT NULL , varchar(50) NOT NULL , char(4) NOT NULL , char(15) NOT NULL , varchar(50) NOT NULL

ALTER TABLE [PASAJERO] ADD CONSTRAINT [XPKPASAJERO] PRIMARY KEY ([IDPASAJERO] ASC) go

NONCLUSTERED

CREATE NONCLUSTERED INDEX [XIF1PASAJERO] ON [PASAJERO] ( [IDPAIS] ASC ) go CREATE TABLE [PILOTO] ( [IDPILOTO] [NOMBRE] [IDPAIS] ) go

integer NOT NULL , varchar(40) NOT NULL , char(4) NOT NULL

ALTER TABLE [PILOTO] ADD CONSTRAINT [XPKPILOTO] PRIMARY KEY go

CLUSTERED ([IDPILOTO] ASC)

CREATE NONCLUSTERED INDEX [XIF1PILOTO] ON [PILOTO] ( [IDPAIS] ASC ) go CREATE TABLE [RESERVA] ( [IDRESERVA] int NOT NULL IDENTITY ( 1,1 ) , [COSTO] money NULL CONSTRAINT [Default_Value_191_2124331110] DEFAULT 0, [FECHA] datetime NULL CONSTRAINT [Default_Value_193_1901411474] DEFAULT GetDate( ) ) go ALTER TABLE [RESERVA] ADD CONSTRAINT [XPKRESERVA] PRIMARY KEY ASC) go CREATE TABLE [RUTA] ( [IDRUTA] [ORIGEN] [DESTINO] [DISTANCIA] [ESCALA] ) go ALTER TABLE [RUTA]

integer NOT varchar(30) varchar(30) integer NOT varchar(30)

NONCLUSTERED ([IDRESERVA]

NULL , NOT NULL , NOT NULL , NULL , NULL

ADD CONSTRAINT [XPKRUTA] PRIMARY KEY

CLUSTERED ([IDRUTA] ASC)

go CREATE TABLE [TARIFA] ( [CLASE] [PRECIO] [IMPUESTO] ) go

varchar(20) NOT NULL , money NOT NULL , money NOT NULL

ALTER TABLE [TARIFA] ADD CONSTRAINT [XPKTARIFA] PRIMARY KEY go CREATE TABLE [VUELO] ( [NUMVUELO] [IDAERO] [IDRESERVA] [IDAVION] [CLASE] [IDRUTA] [IDHORARIO] [IDPILOTO] [FECHAVUELO] ) go

NONCLUSTERED ([CLASE] ASC)

int NOT NULL , char(5) NOT NULL , int NOT NULL , char(5) NOT NULL , varchar(20) NOT NULL , integer NOT NULL , integer NOT NULL , integer NOT NULL , datetime NOT NULL

ALTER TABLE [VUELO] ADD CONSTRAINT [XPKVUELO] PRIMARY KEY NONCLUSTERED ([NUMVUELO] ASC,[IDAERO] ASC,[IDRESERVA] ASC,[IDAVION] ASC,[CLASE] ASC,[IDRUTA] ASC,[IDHORARIO] ASC,[IDPILOTO] ASC) go CREATE NONCLUSTERED INDEX [XIF1VUELO] ON [VUELO] ( [IDAERO] ASC ) go CREATE UNIQUE NONCLUSTERED INDEX [XIF2VUELO] ON [VUELO] ( [IDRESERVA] ASC ) go CREATE NONCLUSTERED INDEX [XIF3VUELO] ON [VUELO] ( [IDAVION] ASC ) go CREATE NONCLUSTERED INDEX [XIF4VUELO] ON [VUELO] ( [CLASE] ASC )

go CREATE NONCLUSTERED INDEX [XIF5VUELO] ON [VUELO] ( [NUMVUELO] ASC ) go CREATE NONCLUSTERED INDEX [XIF6VUELO] ON [VUELO] ( [IDRUTA] ASC ) go CREATE NONCLUSTERED INDEX [XIF7VUELO] ON [VUELO] ( [IDHORARIO] ASC ) go CREATE NONCLUSTERED INDEX [XIF8VUELO] ON [VUELO] ( [IDPILOTO] ASC ) go ALTER TABLE [AEROPUERTO] ADD CONSTRAINT [R_11] FOREIGN KEY ([IDPAIS]) REFERENCES [PAIS]([IDPAIS]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [APROVISIONAMIENTO] ADD CONSTRAINT [R_24] FOREIGN KEY ([IDCOMBUSTIBLE]) REFERENCES [COMBUSTIBLE]([IDCOMBUSTIBLE]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [APROVISIONAMIENTO] ADD CONSTRAINT [R_25] FOREIGN KEY ([IDRUTA]) REFERENCES [RUTA]([IDRUTA]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [APROVISIONAMIENTO] ADD CONSTRAINT [R_26] FOREIGN KEY ([IDAVION]) REFERENCES [AVION]([IDAVION]) ON DELETE NO ACTION ON UPDATE NO ACTION go

ALTER TABLE [AVION] ADD CONSTRAINT [R_4] FOREIGN KEY ([RUC]) REFERENCES [AEROLINEA]([RUC]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [AVION] ADD CONSTRAINT [R_22] FOREIGN KEY ([IDCOMBUSTIBLE]) REFERENCES [COMBUSTIBLE]([IDCOMBUSTIBLE]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [DETALLEEQUIPAJE] ADD CONSTRAINT [R_20] FOREIGN KEY ([IDEQUIPAJE],[IDPASAJERO],[IDAVION]) REFERENCES [EQUIPAJE]([IDEQUIPAJE],[IDPASAJERO],[IDAVION]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [EQUIPAJE] ADD CONSTRAINT [R_19] FOREIGN KEY ([IDPASAJERO]) REFERENCES [PASAJERO]([IDPASAJERO]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [EQUIPAJE] ADD CONSTRAINT [R_21] FOREIGN KEY ([IDAVION]) REFERENCES [AVION]([IDAVION]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [PAGO] ADD CONSTRAINT [R_2] FOREIGN KEY ([IDRESERVA]) REFERENCES [RESERVA]([IDRESERVA]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [PAGO] ADD CONSTRAINT [R_3] FOREIGN KEY ([IDPASAJERO]) REFERENCES [PASAJERO]([IDPASAJERO]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [PASAJERO] ADD CONSTRAINT [R_12] FOREIGN KEY ([IDPAIS]) REFERENCES [PAIS]([IDPAIS])

ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [PILOTO] ADD CONSTRAINT [R_18] FOREIGN KEY ([IDPAIS]) REFERENCES [PAIS]([IDPAIS]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [VUELO] ADD CONSTRAINT [R_5] FOREIGN KEY ([IDAERO]) REFERENCES [AEROPUERTO]([IDAERO]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [VUELO] ADD CONSTRAINT [R_6] FOREIGN KEY ([IDRESERVA]) REFERENCES [RESERVA]([IDRESERVA]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [VUELO] ADD CONSTRAINT [R_7] FOREIGN KEY ([IDAVION]) REFERENCES [AVION]([IDAVION]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [VUELO] ADD CONSTRAINT [R_8] FOREIGN KEY ([CLASE]) REFERENCES [TARIFA]([CLASE]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [VUELO] ADD CONSTRAINT [R_10] FOREIGN KEY ([NUMVUELO]) REFERENCES [ASIENTO]([NUMVUELO]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [VUELO] ADD CONSTRAINT [R_14] FOREIGN KEY ([IDRUTA]) REFERENCES [RUTA]([IDRUTA]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [VUELO]

ADD CONSTRAINT [R_15] FOREIGN KEY ([IDHORARIO]) REFERENCES [HORARIO]([IDHORARIO]) ON DELETE NO ACTION ON UPDATE NO ACTION go ALTER TABLE [VUELO] ADD CONSTRAINT [R_17] FOREIGN KEY ([IDPILOTO]) REFERENCES [PILOTO]([IDPILOTO]) ON DELETE NO ACTION ON UPDATE NO ACTION go