Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLESPACE COMPANIA
- DATAFILE 'C:\COMPANIA.dbf'
- SIZE 50M;
- CREATE USER PASAJERO
- IDENTIFIED BY abc
- DEFAULT TABLESPACE COMPANIA
- TEMPORARY TABLESPACE temp;
- GRANT CONNECT, RESOURCE, CREATE VIEW
- TO PASAJERO;
- CREATE TABLE PASAJERO
- (
- DNI INT PRIMARY KEY,
- NOMBRE VARCHAR2(30) NOT NULL
- );
- CREATE TABLE PERSONAL
- (
- PID INT PRIMARY KEY,
- NOMBRE VARCHAR2(30) NOT NULL,
- CATEGORÍA VARCHAR2(30) NOT NULL
- );
- CREATE TABLE AVION
- (
- MATRICULA INT PRIMARY KEY,
- FABRICANTE VARCHAR2(30) NOT NULL,
- MODELO VARCHAR2(30) NOT NULL,
- CAPACIDAD INT NOT NULL,
- AUTONOMIA VARCHAR2(30) NOT NULL
- );
- CREATE TABLE VUELO
- (
- VID INT PRIMARY KEY,
- FECHA DATE NOT NULL,
- ORIGEN VARCHAR2(30) NOT NULL,
- DESTINO VARCHAR2(30) NOT NULL,
- MATRICULA INT REFERENCES AVION
- );
- CREATE TABLE TRIPULACION
- (
- PID INT REFERENCES PERSONAL,
- VID INT REFERENCES VUELO,
- PUESTO VARCHAR2(30) NOT NULL,
- CONSTRAINT supplier_pk PRIMARY KEY (PID, VID)
- );
- CREATE TABLE PASAJE
- (
- VID INT REFERENCES VUELO,
- DNI INT REFERENCES PASAJERO,
- ASIENTO CHAR(3) NOT NULL,
- CLASE VARCHAR2(20),
- CONSTRAINT supplier_pk_2 PRIMARY KEY(VID, DNI)
- );
- INSERT INTO PASAJERO
- VALUES (71526667, 'Renzo Castillo');
- INSERT INTO PASAJERO
- VALUES (71526668, 'Mario Vargas');
- INSERT INTO PASAJERO
- VALUES (71526669, 'Rocio Lavalle');
- INSERT INTO PERSONAL
- VALUES (1, 'Juan Gomez', 'Copiloto');
- INSERT INTO PERSONAL
- VALUES (2, 'Jose Martinez', 'Piloto');
- INSERT INTO PERSONAL
- VALUES (3, 'Ricardo Rojas', 'Mozo');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement