Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Empresa
create database Empresa use Empresa create table proyecto (Numproy int not null primary key, nombreProy varchar(100), LocProy varchar(50) ); create table departamento (NDepto int not null primary key, nombre_Depto varchar(100), Id_Jefe int, FechaNctoJefe datetime ); create table empleado (IdEmpleado int primary key, Nombre varchar(100), Apellido varchar(100), Fecha_Nac datetime, Direccion varchar(100), sexo_emp char(1), salario float(50), Id_Superv int, NDepto int constraint fk_EmpDepto references Departamento (NDepto)on update cascade on delete cascade ); create table LocDepto (correlativo int Primary Key, NDepto int, LocaDepto varchar(100), constraint fk_LocDepto foreign key (NDepto) references departamento(NDepto) on update cascade on delete cascade, ); create table dependiente (Id_Depend int primary key, IdEmpleado int, nombreDep varchar(100), sexo char(1), FechaNac datetime, parentesco varchar(50), constraint fk_dependEmp foreign key (IdEmpleado) references Empleado(IdEmpleado) on update cascade on delete cascade ); create table Trabaja_En (IdEmpleado int, Numproy int, Horas float, constraint pk_EmpProy primary key(IdEmpleado,Numproy), constraint fk_trabdEmp foreign key(IdEmpleado) references Empleado(IdEmpleado) on update cascade on delete cascade, constraint fk_trabProy foreign key(Numproy) references Proyecto(Numproy) on update cascade on delete cascade, );
run
|
edit
|
history
|
help
0
Fff
nandhu
SQL Server Rank Query Optimization
Cine latinoamericano
aaa
Lab assessment 2
Lisber-SQL-Example(CASE)
customers table
Basic Except
ex2