際際滷

際際滷Share a Scribd company logo

Presentacion de sql

Download as PPTX, PDF
Agustin Adames
Agustin Adames

MySql server, presentacion para charlas

1 of 3
Download to read offline
CREATE_TABLE JUGADORES ( ID_J int(10) not null, Nombre varchar2(20) not null, Apellido varchar2(20) not null, ID_J primary key, CONSTRAINT ID_J pk Primary Key (ID_J) ); CREATE_TABLE ENTRENADORES ( ID_E int(10) not null, Nombre varchar2(20) not null, Apellido varchar2(20) not null, ID_E primary key, ID_J REFERENCES table_jugadores( ID_J), CONSTRAINT ID_E pk Primary Key (ID_E), CONSTRAINT ID_J fk Foreign Key (ID_E), ); Agust鱈n Gonz叩lez A.
CREATE_TABLE PARTIDOS ( ID_P int (10) not null, Fecha DATE not null, Duracion int (5)not null, ID_P primary key, CONSTRAINT ID_P pk Primary Key (ID_P), ); CREATE_TABLE ESTADIOS ( ID_estadio int(10) not null, Nombre varchar2(20) not null, Ubicaci坦n varchar2(25) ID_estadio primary key , ID_P REFERENCES table_partidos( ID_P), CONSTRAINT ID_estadio pk Primary Key (ID_estadio), ); Agust鱈n Gonz叩lez A.
CREATE_TABLE AFICIONADOS ( ID_A int (10) not null, Nombre varchar2(15) not null, Equipo var char2(15) not null, ID_A primary key, CONSTRAINT ID_A pk Primary Key (ID_A), ); Agust鱈n Gonz叩lez A.

More Related Content

Presentacion de sql

  • 1. CREATE_TABLE JUGADORES ( ID_J int(10) not null, Nombre varchar2(20) not null, Apellido varchar2(20) not null, ID_J primary key, CONSTRAINT ID_J pk Primary Key (ID_J) ); CREATE_TABLE ENTRENADORES ( ID_E int(10) not null, Nombre varchar2(20) not null, Apellido varchar2(20) not null, ID_E primary key, ID_J REFERENCES table_jugadores( ID_J), CONSTRAINT ID_E pk Primary Key (ID_E), CONSTRAINT ID_J fk Foreign Key (ID_E), ); Agust鱈n Gonz叩lez A.
  • 2. CREATE_TABLE PARTIDOS ( ID_P int (10) not null, Fecha DATE not null, Duracion int (5)not null, ID_P primary key, CONSTRAINT ID_P pk Primary Key (ID_P), ); CREATE_TABLE ESTADIOS ( ID_estadio int(10) not null, Nombre varchar2(20) not null, Ubicaci坦n varchar2(25) ID_estadio primary key , ID_P REFERENCES table_partidos( ID_P), CONSTRAINT ID_estadio pk Primary Key (ID_estadio), ); Agust鱈n Gonz叩lez A.
  • 3. CREATE_TABLE AFICIONADOS ( ID_A int (10) not null, Nombre varchar2(15) not null, Equipo var char2(15) not null, ID_A primary key, CONSTRAINT ID_A pk Primary Key (ID_A), ); Agust鱈n Gonz叩lez A.