CREATE TABLE Libros
(
libro_id INTEGER NOT NULL ,
nombre_libro VARCHAR2 (500) NOT NULL ,
autor_id INTEGER
) ;
ALTER TABLE Libros ADD CONSTRAINT Libros_PK PRIMARY KEY ( libro_id ) ;
CREATE TABLE autores
( autor_id INTEGER NOT NULL
) ;
ALTER TABLE autores ADD CONSTRAINT autores_PK PRIMARY KEY ( autor_id ) ;
CREATE TABLE publica
(
Libros_libro_id INTEGER NOT NULL ,
autores_autor_id INTEGER NOT NULL
) ;
ALTER TABLE publica ADD CONSTRAINT publica__IDX PRIMARY KEY ( Libros_libro_id, autores_autor_id ) ;
ALTER TABLE publica ADD CONSTRAINT FK_ASS_1 FOREIGN KEY ( Libros_libro_id ) REFERENCES Libros ( libro_id ) ;
ALTER TABLE publica ADD CONSTRAINT FK_ASS_2 FOREIGN KEY ( autores_autor_id ) REFERENCES autores ( autor_id ) ;
-- Informe de Resumen de Oracle SQL Developer Data Modeler:
--
-- CREATE TABLE 3
-- CREATE INDEX 0
-- ALTER TABLE 5
-- CREATE VIEW 0
-- CREATE PACKAGE 0
-- CREATE PACKAGE BODY 0
-- CREATE PROCEDURE 0
-- CREATE FUNCTION 0
-- CREATE TRIGGER 0
-- ALTER TRIGGER 0
-- CREATE COLLECTION TYPE 0
-- CREATE STRUCTURED TYPE 0
-- CREATE STRUCTURED TYPE BODY 0
-- CREATE CLUSTER 0
-- CREATE CONTEXT 0
-- CREATE DATABASE 0
-- CREATE DIMENSION 0
-- CREATE DIRECTORY 0
-- CREATE DISK GROUP 0
-- CREATE ROLE 0
-- CREATE ROLLBACK SEGMENT 0
-- CREATE SEQUENCE 0
-- CREATE MATERIALIZED VIEW 0
-- CREATE SYNONYM 0
-- CREATE TABLESPACE 0
-- CREATE USER 0
--
-- DROP TABLESPACE 0
-- DROP DATABASE 0
--
-- REDACTION POLICY 0
--
-- ERRORS 0
-- WARNINGS 0
