Proyecto

SCRIPTS DE CREAR TABLAS
AULA

CREATE TABLE [dbo].[Aula] (
[CodAula] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
[DescripcionAula] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,[UbiAula] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Aula] ADD
CONSTRAINT [PK_Aula] PRIMARY KEY CLUSTERED
([CodAula] ) ON [PRIMARY]
GODETALLE INSCRIPCION

CREATE TABLE [dbo].[DetalleInscripcion] (
[CodInscripcion] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
[CodMateria] [varchar] (10) COLLATE Modern_Spanish_CI_AS NULL ,[NotaICorte] [money] NULL ,
[NotaIICorte] [money] NULL ,
[NotaIIICorte] [money] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[DetalleInscripcion] ADD
CONSTRAINT[FK_DetalleInscripcion_Inscripcion] FOREIGN KEY
(
[CodInscripcion]
) REFERENCES [dbo].[Inscripcion] (
[CodInscripcion]
),
CONSTRAINT [FK_DetalleInscripcion_Materia] FOREIGN KEY
(
[CodMateria]
) REFERENCES[dbo].[Materia] (
[codmateria]
)

ALTER TABLE [dbo].[Especialidad] ADD
CONSTRAINT [PK_Especialidad] PRIMARY KEY CLUSTERED
(
[CodEspecialidad]
) ON [PRIMARY]
GO

ALTER TABLE[dbo].[Especialidad] ADD
CONSTRAINT [FK_Especialidad_Personal] FOREIGN KEY
(
[CodPersonal]
) REFERENCES [dbo].[Personal] (
[CodPersonal]
)
GO

ESTUDIANTE

CREATE TABLE[dbo].[Estudiante] (
[CodEst] [varchar] (20) COLLATE Modern_Spanish_CI_AS NOT NULL ,
[cedula] [varchar] (20) COLLATE Modern_Spanish_CI_AS NULL ,
[nacionalidad] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,[nombres] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,
[apellidos] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,
[direccion] [text] COLLATE Modern_Spanish_CI_AS NULL ,
[telefono][varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,
[sexo] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[fechanacimiento] [datetime] NULL ,
[correo] [varchar] (50) COLLATE Modern_Spanish_CI_AS...