USE [students]
GO
/****** Object:  Table [dbo].[exams]    Script Date: 04/02/2010 10:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[exams](
	[ExamID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](50) NULL,
 CONSTRAINT [PK_exams] PRIMARY KEY CLUSTERED 
(
	[ExamID] 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 IDENTITY_INSERT [dbo].[exams] ON
INSERT [dbo].[exams] ([ExamID], [Title]) VALUES (1, N'math')
INSERT [dbo].[exams] ([ExamID], [Title]) VALUES (2, N'arabic')
SET IDENTITY_INSERT [dbo].[exams] OFF
/****** Object:  Table [dbo].[students]    Script Date: 04/02/2010 10:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[students](
	[studentID] [int] IDENTITY(1,1) NOT NULL,
	[name] [nchar](10) NULL,
 CONSTRAINT [PK_students] PRIMARY KEY CLUSTERED 
(
	[studentID] 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 IDENTITY_INSERT [dbo].[students] ON
INSERT [dbo].[students] ([studentID], [name]) VALUES (1, N'hady      ')
INSERT [dbo].[students] ([studentID], [name]) VALUES (2, N'mohamed   ')
SET IDENTITY_INSERT [dbo].[students] OFF
/****** Object:  Table [dbo].[Exams_students]    Script Date: 04/02/2010 10:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Exams_students](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ExamID] [int] NOT NULL,
	[StudentID] [int] NULL,
	[Score] [float] NULL,
 CONSTRAINT [PK_Exams_students] PRIMARY KEY CLUSTERED 
(
	[ID] 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 IDENTITY_INSERT [dbo].[Exams_students] ON
INSERT [dbo].[Exams_students] ([ID], [ExamID], [StudentID], [Score]) VALUES (1, 1, 1, 10)
INSERT [dbo].[Exams_students] ([ID], [ExamID], [StudentID], [Score]) VALUES (2, 2, 1, 50)
SET IDENTITY_INSERT [dbo].[Exams_students] OFF
/****** Object:  ForeignKey [FK_Exams_students_exams]    Script Date: 04/02/2010 10:58:40 ******/
ALTER TABLE [dbo].[Exams_students]  WITH CHECK ADD  CONSTRAINT [FK_Exams_students_exams] FOREIGN KEY([ExamID])
REFERENCES [dbo].[exams] ([ExamID])
GO
ALTER TABLE [dbo].[Exams_students] CHECK CONSTRAINT [FK_Exams_students_exams]
GO
/****** Object:  ForeignKey [FK_Exams_students_students]    Script Date: 04/02/2010 10:58:40 ******/
ALTER TABLE [dbo].[Exams_students]  WITH CHECK ADD  CONSTRAINT [FK_Exams_students_students] FOREIGN KEY([StudentID])
REFERENCES [dbo].[students] ([studentID])
GO
ALTER TABLE [dbo].[Exams_students] CHECK CONSTRAINT [FK_Exams_students_students]
GO
