USE [QL_dangky]
GO
/****** Object:  Table [dbo].[MonHoc]    Script Date: 10/29/2014 01:20:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MonHoc](
    [MaMon] [VARCHAR](10) NOT NULL,
    [TenMon] [nvarchar](50) NOT NULL,
    [STC] [SMALLINT] NOT NULL,
 CONSTRAINT [PK_MonHoc] PRIMARY KEY CLUSTERED
(
    [MaMon] 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
/****** Object:  Table [dbo].[Lop]    Script Date: 10/29/2014 01:20:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Lop](
    [MaLop] [VARCHAR](10) NOT NULL,
    [TenLop] [nvarchar](50) NOT NULL,
    [SoSV] [INT] NOT NULL,
 CONSTRAINT [PK_Lop] PRIMARY KEY CLUSTERED
(
    [MaLop] 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
/****** Object:  Table [dbo].[SV]    Script Date: 10/29/2014 01:20:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SV](
    [MaSV] [VARCHAR](10) NOT NULL,
    [TenSV] [nvarchar](50) NOT NULL,
    [MaLop] [VARCHAR](10) NOT NULL,
    [NamSinh] [smalldatetime] NULL,
    [Gtinh] [bit] NULL,
 CONSTRAINT [PK_SV] PRIMARY KEY CLUSTERED
(
    [MaSV] 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
/****** Object:  Table [dbo].[DangKy]    Script Date: 10/29/2014 01:20:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DangKy](
    [MaSV] [VARCHAR](10) NOT NULL,
    [MaMon] [VARCHAR](10) NOT NULL,
    [HocKy] [SMALLINT] NOT NULL,
 CONSTRAINT [PK_DangKy] PRIMARY KEY CLUSTERED
(
    [MaSV] ASC,
    [MaMon] 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
/****** Object:  ForeignKey [FK_DangKy_MonHoc]    Script Date: 10/29/2014 01:20:10 ******/
ALTER TABLE [dbo].[DangKy]  WITH CHECK ADD  CONSTRAINT [FK_DangKy_MonHoc] FOREIGN KEY([MaMon])
REFERENCES [dbo].[MonHoc] ([MaMon])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DangKy] CHECK CONSTRAINT [FK_DangKy_MonHoc]
GO
/****** Object:  ForeignKey [FK_DangKy_SV]    Script Date: 10/29/2014 01:20:10 ******/
ALTER TABLE [dbo].[DangKy]  WITH CHECK ADD  CONSTRAINT [FK_DangKy_SV] FOREIGN KEY([MaSV])
REFERENCES [dbo].[SV] ([MaSV])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DangKy] CHECK CONSTRAINT [FK_DangKy_SV]
GO
/****** Object:  ForeignKey [FK_SV_Lop]    Script Date: 10/29/2014 01:20:10 ******/
ALTER TABLE [dbo].[SV]  WITH CHECK ADD  CONSTRAINT [FK_SV_Lop] FOREIGN KEY([MaLop])
REFERENCES [dbo].[Lop] ([MaLop])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[SV] CHECK CONSTRAINT [FK_SV_Lop]
GO