Creacion de Tablas en SQL 2008

use ControlEscolar

CREATE TABLE Carreras
( NoC INT IDENTITY (1,1) PRIMARY KEY,
NombreC VARCHAR (50)
)
DROP TABLE Grupos

INSERT INTO dbo.Carreras (NombreC)
values ('Ingenieria Civil')
GO
INSERT INTO dbo.Carreras (NombreC)
values ('Abogado')
GO
INSERT INTO dbo.Carreras (NombreC)
values ('Lic. en Admon')
GO
INSERT INTO dbo.Carreras (NombreC)
values ('Contador Publico')
GO

CREATE TABLE dbo.Alumnos (
NC INT PRIMARY KEY,
NombreA VARCHAR(50),
Sexo VARCHAR(1),
Domicilio VARCHAR(50),
Edad TINYINT,
NoC INT
FOREIGN KEY (NoC) REFERENCES Carreras)
GO

INSERT INTO dbo.Alumnos
VALUES(76, 'Jose Martinez', 'M', 'Fresno # 503', 22, 1)
GO
INSERT INTO dbo.Alumnos
VALUES(95, 'Ramon Ramos', 'M', 'Valle # 301', 23, 1)
GO
INSERT INTO dbo.Alumnos
VALUES(16, 'Alicia Jimenez', 'F', 'bravo # 23', 25, 3)
GO
INSERT INTO dbo.Alumnos
VALUES(19, 'Jaime Ruiz', 'M', 'rosas # 10', 24, 2)
GO
INSERT INTO dbo.Alumnos
VALUES(51, 'Benjamon Rios', 'M', 'sol # 300', 21, 3)
GO
INSERT INTO dbo.Alumnos
VALUES(68, 'Rodrigo Salas', 'M', 'Vicente # 171', 23, 3)
GO
INSERT INTO dbo.Alumnos
VALUES(24, 'Rocio Torres', 'F', 'pera # 43', 20, 2)
GO
INSERT INTO dbo.Alumnos
VALUES(33, 'Leticia Flores', 'F', 'roble # 50', 25, 2)
GO

CREATE TABLE dbo.Grupos (
NG VARCHAR (5),
NCC INT,
NM VARCHAR (5),
NC INT,
Calificacion INT,
FOREIGN KEY (NC) REFERENCES Alumnos
)
GO

INSERT INTO dbo.Grupos
VALUES('A1', 130, 'E7H', 95, 90)
GO
INSERT INTO dbo.Grupos
VALUES('A1', 130, 'E7H', 76, 80)
GO
INSERT INTO dbo.Grupos
VALUES('B1', 537, 'C1C', 68, 60)
GO
INSERT INTO dbo.Grupos
VALUES('B1', 537, 'C1C', 16, 85)
GO
INSERT INTO dbo.Grupos
VALUES('C1', 375, 'M5A', 76, 75)
GO
INSERT INTO dbo.Grupos
VALUES('C1', 375, 'M5A', 16, 95)
GO
INSERT INTO dbo.Grupos
VALUES('C1', 375, 'M5A', 68, 60)
GO
INSERT INTO dbo.Grupos
VALUES('C1', 375, 'M5A', 33, 85)
GO
INSERT INTO dbo.Grupos
VALUES('C2', 130, 'M5A', 95, 90)
GO
INSERT INTO dbo.Grupos
VALUES('C2', 130, 'M5A', 19, 60)
GO
INSERT INTO dbo.Grupos
VALUES('C2', 130, 'M5A', 24, 70)
GO

CREATE TABLE dbo.Catedraticos (
NCC INT,
NombreC VARCHAR (50),
Departamento VARCHAR (50),
Ext INT,
Sexo VARCHAR(1)
)
GO

INSERT INTO dbo.Catedraticos
VALUES(537, 'Lucia R', 'Administracion', 5320, 'F')
GO
INSERT INTO dbo.Catedraticos
VALUES(130, 'Marco H', 'Ciencias Basicas', 5430, 'M')
GO
INSERT INTO dbo.Catedraticos
VALUES(375, 'Silvia A', 'Ciencias Basicas', 5410, 'F')
GO
INSERT INTO dbo.Catedraticos
VALUES(291, 'Alberto Z', 'Humanidades', 5110, 'M')
GO

CREATE TABLE dbo.Materias (
NM VARCHAR (5),
NombreM VARCHAR (50)
)
GO

INSERT INTO dbo.Materias
VALUES('M5A', 'Matematicas I')
GO
INSERT INTO dbo.Materias
VALUES('D3B', 'Derecho Laboral')
GO
INSERT INTO dbo.Materias
VALUES('C1C', 'Contabilidad')
GO
INSERT INTO dbo.Materias
VALUES('E7H', 'Estadistica')
GO