Programar un formulario que permita agregar y buscar elementos de la tabla Alumnos(codalu, nomalu, apealu, ciclo, turno, codcar).
Usando la tabla carreras para seleccionar la carrera respectiva.
Carreras(codcar, nomcar).
Script de la base de datos en SQL Server:
USE [master]
GO
CREATE DATABASE [BDUNIVERSIDAD]
GO
USE [BDUNIVERSIDAD]
GO
CREATE TABLE [dbo].[ALUMNOS](
[CODALU] [nchar](5) NOT NULL,
[NOMALU] [nvarchar](150) NULL,
[APEALU] [nvarchar](150) NULL,
[CICLO] [nchar](10) NULL,
[TURNO] [nvarchar](50) NULL,
[CODCAR] [nchar](10) NULL,
CONSTRAINT [PK_ALUMNOS] PRIMARY KEY CLUSTERED
(
[CODALU] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CARRERAS](
[CODCAR] [nchar](10) NOT NULL,
[NOMCAR] [nvarchar](150) NULL,
CONSTRAINT [PK_CARRERAS] PRIMARY KEY CLUSTERED
(
[CODCAR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
Solicitar código fuente a:
cgprognet@hotmail.com
cgprognet@gmail.com
Gracias.
ResponderEliminar