File:Diagrama Entidad Relacion.svg
From Wikimedia Commons, the free media repository
Jump to navigation
Jump to search
Size of this PNG preview of this SVG file: 800 × 546 pixels. Other resolutions: 320 × 218 pixels | 640 × 437 pixels | 1,024 × 699 pixels | 1,280 × 873 pixels | 2,560 × 1,747 pixels | 932 × 636 pixels.
Original file (SVG file, nominally 932 × 636 pixels, file size: 66 KB)
File information
Structured data
Captions
Summary[edit]
DescriptionDiagrama Entidad Relacion.svg |
Español: Diagrama entidad relación con la siguiente estructura SQL equivalente. Create Table Persona(
CI int PRIMARY KEY CHECK (CI>=100000 and CI<= 99999999),
Nombre VARCHAR(15) not null,
Apellido VARCHAR(20) not null,
email varchar(50)
)
CREATE TABLE Profesor(
CI_P INT foreign key references Persona ON DELETE CASCADE ON UPDATE CASCADE,
Nacionalidad VARCHAR(55) default 'Venezolano',
Calle VARCHAR(20) not null,
Ciudad VARCHAR(40) not null,
Login VARCHAR(8) not null unique,
Password VARCHAR(8) not null,
PRIMARY KEY (CI_P)
)
CREATE TABLE Alumno(
CI_A INT foreign key references Persona ON UPDATE CASCADE ON DELETE CASCADE,
tipo varchar(9) check(tipo='Pre-Grado' or tipo='Post-Grado')
default 'Pre-grado' not null,
PRIMARY KEY (CI_A)
)
CREATE TABLE Materia(
Cod_Mat varchar(7) PRIMARY KEY
check (cod_Mat like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
Materia varchar(55) not null
)
CREATE TABLE Carrera(
Cod_car varchar(3) primary key
check (cod_car like '[0-9][0-9][0-9]'),
Carrera varchar(30)unique not null
)
CREATE TABLE Escuela(
Cod_E int primary key,
Escuela varchar(40) unique
)
Create table tiene(
Cod_E int foreign key references Escuela ON DELETE CASCADE ON UPDATE CASCADE,
Cod_Car varchar(3) foreign key references Carrera ON DELETE CASCADE ON UPDATE CASCADE,
CI_P int foreign key references Profesor ON DELETE CASCADE ON UPDATE CASCADE
)
CREATE TABLE Historial(
Tipo_E varchar (20) not null,
Descrip varchar (45) not null,
Cuidad varchar (50) not null,
Pais varchar (50) not null,
Fecha datetime,
CI_P INT FOREIGN KEY REFERENCES PROFESOR ON DELETE CASCADE ON UPDATE CASCADE,
UNIQUE (CI_P, Tipo_E,Descrip)
)
CREATE TABLE CURSO(
Tipo varchar (10) not null
check(tipo='Curso'or tipo='Taller'),
Nombre varchar (50) not null,
Pais varchar (50) not null,
cuidad varchar (50) not null,
Instituto varchar (30) not null,
CI_P int foreign key references profesor ON DELETE CASCADE ON UPDATE CASCADE,
duracion varchar(10) not null,
nivel varchar(20) default 'Unico' not null,
unique (ci_p,nombre,nivel)
)
Create table buzon(
titulo varchar (20),
mensaje text not null,
remitente varchar (30),
CI_P int foreign key references profesor ON DELETE CASCADE ON UPDATE CASCADE
)
Create table cartelera(
fecha datetime not null,
Mens text not null,
CI_P int foreign key references profesor ON DELETE CASCADE ON UPDATE CASCADE
)
Create table bibliografia(
Autor varchar (20) not null,
Titulo varchar (30) not null,
Cod_mat varchar (7) foreign key references materia ON DELETE CASCADE ON UPDATE CASCADE,
unique(Autor,titulo)
)
Create table foro(
Tema varchar (60) not null,
Fecha_f datetime,
Primary key(tema,fecha_f)
)
Create table propone(
CI int foreign key references Persona ON DELETE CASCADE ON UPDATE CASCADE,
Resp text not null,
Fecha_r datetime,
Fecha_f datetime,
Tema varchar(60),
foreign key (Tema,Fecha_f) references Foro ON DELETE CASCADE ON UPDATE CASCADE
)
Create Table Planifica(
Cod_mat varchar(7) foreign key references materia ON DELETE CASCADE ON UPDATE CASCADE,
CI_P int foreign key references Profesor ON DELETE CASCADE ON UPDATE CASCADE,
Num_eva tinyint not null,
Tipo_eva varchar(15) not null,
puntaje int not null,
fecha datetime,
Sec tinyint check(sec >=01 and sec<=99)
)
Create table Dicta(
CI_P int foreign key references Profesor ON DELETE CASCADE ON UPDATE CASCADE,
Cod_mat varchar(7) foreign key references Materia ON DELETE CASCADE ON UPDATE CASCADE,
Periodo char(1) not null
check (periodo like '1''2'or periodo like 'I''II'),
año int not null check (año>=1800 and año<=2504)
)
Create table Cursa (
Cod_mat varchar(7) foreign key references Materia ON DELETE CASCADE ON UPDATE CASCADE,
CI_A int foreign key references Alumno ON DELETE CASCADE ON UPDATE CASCADE,
Peri char(1) not null check (peri like '1''2'or peri like 'I''II'),
año int check (año>=1800 and año<=2504),
Sec_a tinyint check(sec_a >=01 and sec_a<=99)
)
Create table Evalua (
Num tinyint not null,
Nota tinyint not null check(nota>=0 and nota<=10),
CI_A int foreign key references Alumno,
CI_P int foreign key references Profesor,
Cod_mat varchar(7) foreign key references Materia,
unique(CI_P,CI_A,Cod_mat,Num)
)
Create table Contiene (
cod_mat varchar(7) foreign key references Materia ON DELETE CASCADE ON UPDATE CASCADE,
cod_Car varchar(3) foreign key references Carrera ON DELETE CASCADE ON UPDATE CASCADE
)
|
Date | |
Source | selft work |
Author | User:Wilfredor |
Licensing[edit]
I, the copyright holder of this work, hereby publish it under the following licenses:
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the section entitled GNU Free Documentation License.http://www.gnu.org/copyleft/fdl.htmlGFDLGNU Free Documentation Licensetruetrue |
This file is licensed under the Creative Commons Attribution-Share Alike 4.0 International, 3.0 Unported, 2.5 Generic, 2.0 Generic and 1.0 Generic license.
- You are free:
- to share – to copy, distribute and transmit the work
- to remix – to adapt the work
- Under the following conditions:
- attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- share alike – If you remix, transform, or build upon the material, you must distribute your contributions under the same or compatible license as the original.
You may select the license of your choice.
File history
Click on a date/time to view the file as it appeared at that time.
Date/Time | Thumbnail | Dimensions | User | Comment | |
---|---|---|---|---|---|
current | 17:16, 20 March 2008 | 932 × 636 (66 KB) | Wilfredor (talk | contribs) | == Summary == {{Information |Description= |Source= selft work |Date= 2003 |Author= |Permission= |other_versions= }} == Licensing: == {{self|GFDL|cc-by-sa-all}} | |
17:06, 20 March 2008 | 1,052 × 744 (67 KB) | Wilfredor (talk | contribs) | {{Information |Description= |Source= selft work |Date= 2003 |Author= |Permission= |other_versions= }} |
You cannot overwrite this file.
File usage on Commons
The following page uses this file:
File usage on other wikis
The following other wikis use this file:
- Usage on es.wikipedia.org
Metadata
This file contains additional information such as Exif metadata which may have been added by the digital camera, scanner, or software program used to create or digitize it. If the file has been modified from its original state, some details such as the timestamp may not fully reflect those of the original file. The timestamp is only as accurate as the clock in the camera, and it may be completely wrong.
Width | 931.78656 |
---|---|
Height | 635.8938 |