Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE POBLACION (
- COD_POB INT(2) NOT NULL,
- NOMBRE VARCHAR(20),
- CONSTRAINT POBLACION_CODPOB_PK PRIMARY KEY (COD_POB));
- CREATE TABLE SOCIO (
- COD_SOC INT(2) NOT NULL,
- NOMBRE VARCHAR(20),
- APELLIDOS VARCHAR(20),
- DIRECCION VARCHAR(20),
- TELEFONO VARCHAR(10),
- COD_POB INT(2),
- EDAD INT(2),
- FECHAALTA DATE,
- CUOTA INT(5),
- CONSTRAINT SOCIO_CODSOC_PK PRIMARY KEY (COD_SOC),
- FOREIGN KEY (COD_POB) REFERENCES POBLACION(COD_POB));
- INSERT INTO POBLACION VALUES (1,'CORNELLA');
- INSERT INTO POBLACION VALUES (2,'ESPLUGUES');
- INSERT INTO POBLACION VALUES (3,'VALLECAS');
- INSERT INTO SOCIO VALUES (1,'MARIA','GOMEZ GOMEZ','BONAVISTA s/n','936877899',1,20, '81-11-17', 2000);
- INSERT INTO SOCIO VALUES (2,'TONI','PEREZ RUIZ','BONAVISTA s/n','933453455',1,22,'81-11-17',3000);
- INSERT INTO SOCIO VALUES (3,'MIGUEL','LOPEZ GOMEZ','BONAVISTA s/n','936437899',1,21, '81-11-17', 1000);
- INSERT INTO SOCIO VALUES (4,'PEPE','SORIANO SORIANO','REP. ARGENTINA s/n','936872899',1,21, '99-11-17', 4000);
- INSERT INTO SOCIO VALUES (5,'SONIA','GARRIDO GOMEZ','BONAVISTA s/n','936875399',1,22, '99-10-17', 6000);
- INSERT INTO SOCIO VALUES (6,'MARCOS','RUIZ SERRANO','BONAVISTA s/n','935437899',1,23, '99-11-17', 7000);
- INSERT INTO SOCIO VALUES (7,'JORGE','MILLAN MILLAN','BONAVISTA s/n','935577899',1,24, '99-11-17', 3000);
- INSERT INTO SOCIO VALUES (8,'JESUS','RODRIGUEZ RODRIGUEZ','BONAVISTA s/n','935577899',2,26, '00-10-13', 4000);
- INSERT INTO SOCIO VALUES (9,'MARIA','LUZ AGUA','AVDA. EL SOL s/n','935477899',3,18, '00-01-09', 6000);
- CREATE TABLE PELICULA (
- COD_PEL INT(4) NOT NULL,
- TITULO VARCHAR(20),
- DURACION INT(4),
- DIRECTOR VARCHAR(20),
- CONSTRAINT PELICULA_CODPEL_PK PRIMARY KEY (COD_PEL));
- INSERT INTO PELICULA VALUES (0001,'LA SIRENITA',100,'WARNER BROS');
- INSERT INTO PELICULA VALUES (0002,'EL REY LEON',140,'WARNER BROS');
- INSERT INTO PELICULA (cod_pel, titulo, duracion) VALUES (0003,'THE MATRIX',200);
- CREATE TABLE TIENE(
- COD_SOC INT(2) NOT NULL REFERENCES SOCIO(COD_SOC),
- COD_PEL INT(4) NOT NULL REFERENCES PELICULA(COD_PEL),
- FECHA_ADQ DATE,
- FECHA_DEV DATE,
- CONSTRAINT TIENE_CODIGOS_PK PRIMARY KEY (COD_SOC,COD_PEL));
- INSERT INTO TIENE VALUES (1,0001, '99-02-18', '99-03-18');
- INSERT INTO TIENE VALUES (1,0002, '99-03-17', '99-04-17');
- INSERT INTO TIENE (cod_soc,cod_pel,fecha_adq) VALUES (2,0001, '00-04-11');
- INSERT INTO TIENE (cod_soc,cod_pel) VALUES (3,0002);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement