Um Projeto Universidade
Por: Hugo.bassi • 5/3/2018 • 763 Palavras (4 Páginas) • 301 Visualizações
...
[cidade] [varchar](30) NOT NULL,
PRIMARY KEY CLUSTERED
(
[RA] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Alunos] ([RA], [nome], [endereco], [cidade]) VALUES (1, N'aaaa', N'bbb', N'wwww')
INSERT [dbo].[Alunos] ([RA], [nome], [endereco], [cidade]) VALUES (10, N'Teste', N'aaaa', N'mogi guaçu')
INSERT [dbo].[Alunos] ([RA], [nome], [endereco], [cidade]) VALUES (5400001, N'ANA PAULA RODRIGUES', N'RUA Z, 11', N'CAMPINAS')
INSERT [dbo].[Alunos] ([RA], [nome], [endereco], [cidade]) VALUES (5400121, N'ALEX DA SILVA', N'RUA X, 10', N'MOGI')
INSERT [dbo].[Alunos] ([RA], [nome], [endereco], [cidade]) VALUES (12345678, N'MARIA DA SILVA', N'RUA X, 105', N'MOGI')
INSERT [dbo].[Alunos] ([RA], [nome], [endereco], [cidade]) VALUES (200400345, N'MINERVINA DOS SANTOS', N'RUA Y, 1012', N'CAMPINAS')
INSERT [dbo].[Alunos] ([RA], [nome], [endereco], [cidade]) VALUES (200600213, N'JORGE DOS SANTOS', N'RUA B, 102', N'JUNDIAI')
INSERT [dbo].[Alunos] ([RA], [nome], [endereco], [cidade]) VALUES (200600454, N'JOSÉ DA SILVA', N'RUA A, 101', N'JUNDIAI')
/****** Object: Table [dbo].[Professores] Script Date: 05/30/2016 17:18:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Professores](
[COD_PROF] [int] NOT NULL,
[nome] [varchar](40) NOT NULL,
[endereco] [varchar](40) NOT NULL,
[cidade] [varchar](30) NOT NULL,
PRIMARY KEY CLUSTERED
(
[COD_PROF] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Professores] ([COD_PROF], [nome], [endereco], [cidade]) VALUES (1, N'JOSE APARECIDO CARRILHO', N'RUA W, 102', N'CAMPINAS')
INSERT [dbo].[Professores] ([COD_PROF], [nome], [endereco], [cidade]) VALUES (2, N'MARCIO HENRIQUE ZUCHINI', N'RUA A, 10212', N'JUNDIAÍ')
INSERT [dbo].[Professores] ([COD_PROF], [nome], [endereco], [cidade]) VALUES (3, N'RAIMUNDO CLAUDIO DA SILVA VASCONCELOS', N'RUA b, 212', N'CAMPINAS')
INSERT [dbo].[Professores] ([COD_PROF], [nome], [endereco], [cidade]) VALUES (4, N'PETER JANDL', N'RUA C, 212', N'MOGI')
/****** Object: Table [dbo].[Turma] Script Date: 05/30/2016 17:18:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Turma](
[COD_DISC] [varchar](6) NOT NULL,
[COD_TURMA] [int] NOT NULL,
[COD_PROF] [int] NOT NULL,
[ANO] [int] NOT NULL,
[horario] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[COD_DISC] ASC,
[COD_TURMA] ASC,
[COD_PROF] ASC,
[ANO] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Turma] ([COD_DISC], [COD_TURMA], [COD_PROF], [ANO], [horario]) VALUES (N'BD', 1, 1, 2013, 1)
INSERT [dbo].[Turma] ([COD_DISC], [COD_TURMA], [COD_PROF], [ANO], [horario]) VALUES (N'EDA', 23, 4, 2013, 12)
/****** Object: Table [dbo].[Historico] Script Date: 05/30/2016 17:18:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Historico](
[RA] [int] NOT NULL,
[COD_DISC] [varchar](6) NOT NULL,
[COD_TURMA] [int] NOT NULL,
[COD_PROF]
...