Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS ALUMNOS (
- CODIGO INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- NOMBRE VARCHAR(20),
- APELLIDOS VARCHAR(40),
- EDAD INT NOT NULL,
- FECHA_NACIMIENTO DATE
- );
- CREATE TABLE IF NOT EXISTS ASIGNATURAS (
- CODIGO INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- NOMBRE VARCHAR(30)
- );
- CREATE TABLE IF NOT EXISTS NOTAS (
- CODIGO INT NOT NULL auto_increment PRIMARY KEY,
- CODIGO_ALUMNO INT,
- CODIGO_ASIGNATURA INT,
- NOTA INT,
- FOREIGN KEY (CODIGO_ALUMNO) REFERENCES ALUMNOS(CODIGO),
- FOREIGN KEY (CODIGO_ASIGNATURA) REFERENCES ASIGNATURAS(CODIGO)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement