Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE CIUDAD(
- nom varchar2(20),
- nom_pais varchar2(20),
- num_habitants number(10),
- constraint pk_ciudad
- primary key(nom, nom_pais)
- );
- insert into ciudad values('Paris','Francia',5000000);
- CREATE TABLE HABITANT(
- DNI CHAR(9),
- nom varchar2(20),
- nom_ciudad varchar2(20),
- nom_pais varchar2(20),
- constraint pk_habitant primary key(dni),
- constraint fk_habitant foreign key (nom_ciudad, nom_pais)
- references ciudad(nom, nom_pais)
- );
- INSERT INTO Habitant values('11111A','Maria','Paris','Francia');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement