· 8 years ago · Mar 02, 2018, 12:28 AM
1
2/****** Object: Database [QLHocVien] Script Date: 02/20/2012 16:19:38 ******/
3IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'QLHocVien')
4BEGIN
5CREATE DATABASE [QLHocVien]
6END
7GO
8IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
9begin
10EXEC [QLHocVien].[dbo].[sp_fulltext_database] @action = 'enable'
11end
12GO
13ALTER DATABASE [QLHocVien] SET ANSI_NULL_DEFAULT OFF
14GO
15ALTER DATABASE [QLHocVien] SET ANSI_NULLS OFF
16GO
17ALTER DATABASE [QLHocVien] SET ANSI_PADDING OFF
18GO
19ALTER DATABASE [QLHocVien] SET ANSI_WARNINGS OFF
20GO
21ALTER DATABASE [QLHocVien] SET ARITHABORT OFF
22GO
23ALTER DATABASE [QLHocVien] SET AUTO_CLOSE OFF
24GO
25ALTER DATABASE [QLHocVien] SET AUTO_CREATE_STATISTICS ON
26GO
27ALTER DATABASE [QLHocVien] SET AUTO_SHRINK OFF
28GO
29ALTER DATABASE [QLHocVien] SET AUTO_UPDATE_STATISTICS ON
30GO
31ALTER DATABASE [QLHocVien] SET CURSOR_CLOSE_ON_COMMIT OFF
32GO
33ALTER DATABASE [QLHocVien] SET CURSOR_DEFAULT GLOBAL
34GO
35ALTER DATABASE [QLHocVien] SET CONCAT_NULL_YIELDS_NULL OFF
36GO
37ALTER DATABASE [QLHocVien] SET NUMERIC_ROUNDABORT OFF
38GO
39ALTER DATABASE [QLHocVien] SET QUOTED_IDENTIFIER OFF
40GO
41ALTER DATABASE [QLHocVien] SET RECURSIVE_TRIGGERS OFF
42GO
43ALTER DATABASE [QLHocVien] SET READ_WRITE
44GO
45ALTER DATABASE [QLHocVien] SET RECOVERY FULL
46GO
47ALTER DATABASE [QLHocVien] SET MULTI_USER
48GO
49if ( ((@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 760)) or
50 (@@microsoftversion / power(2, 24) >= 9) )begin
51 exec dbo.sp_dboption @dbname = N'QLHocVien', @optname = 'db chaining', @optvalue = 'OFF'
52 end
53GO
54USE [QLHocVien]
55GO
56/****** Object: ForeignKey [FK_Table1_LOPHOC] Script Date: 02/20/2012 16:19:45 ******/
57IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Table1_LOPHOC]') AND type = 'F')
58ALTER TABLE [dbo].[HOCVIEN] DROP CONSTRAINT [FK_Table1_LOPHOC]
59GO
60/****** Object: ForeignKey [FK_KETQUA_MONHOC] Script Date: 02/20/2012 16:19:45 ******/
61IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_KETQUA_MONHOC]') AND type = 'F')
62ALTER TABLE [dbo].[KETQUA] DROP CONSTRAINT [FK_KETQUA_MONHOC]
63GO
64/****** Object: ForeignKey [FK_KETQUA_Table1] Script Date: 02/20/2012 16:19:45 ******/
65IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_KETQUA_Table1]') AND type = 'F')
66ALTER TABLE [dbo].[KETQUA] DROP CONSTRAINT [FK_KETQUA_Table1]
67GO
68/****** Object: ForeignKey [FK_PHANCONG_GIAOVIEN] Script Date: 02/20/2012 16:19:45 ******/
69IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_GIAOVIEN]') AND type = 'F')
70ALTER TABLE [dbo].[PHANCONG] DROP CONSTRAINT [FK_PHANCONG_GIAOVIEN]
71GO
72/****** Object: ForeignKey [FK_PHANCONG_LOPHOC] Script Date: 02/20/2012 16:19:45 ******/
73IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_LOPHOC]') AND type = 'F')
74ALTER TABLE [dbo].[PHANCONG] DROP CONSTRAINT [FK_PHANCONG_LOPHOC]
75GO
76/****** Object: ForeignKey [FK_PHANCONG_MONHOC] Script Date: 02/20/2012 16:19:45 ******/
77IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_MONHOC]') AND type = 'F')
78ALTER TABLE [dbo].[PHANCONG] DROP CONSTRAINT [FK_PHANCONG_MONHOC]
79GO
80/****** Object: ForeignKey [FK_LOPHOC_GIAOVIEN] Script Date: 02/20/2012 16:19:46 ******/
81IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_LOPHOC_GIAOVIEN]') AND type = 'F')
82ALTER TABLE [dbo].[LOPHOC] DROP CONSTRAINT [FK_LOPHOC_GIAOVIEN]
83GO
84/****** Object: ForeignKey [FK_LOPHOC_Table1] Script Date: 02/20/2012 16:19:46 ******/
85IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_LOPHOC_Table1]') AND type = 'F')
86ALTER TABLE [dbo].[LOPHOC] DROP CONSTRAINT [FK_LOPHOC_Table1]
87GO
88/****** Object: ForeignKey [FK_GIAOVIEN_GIAOVIEN] Script Date: 02/20/2012 16:19:46 ******/
89IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_GIAOVIEN]') AND type = 'F')
90ALTER TABLE [dbo].[GIAOVIEN] DROP CONSTRAINT [FK_GIAOVIEN_GIAOVIEN]
91GO
92/****** Object: ForeignKey [FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN] Script Date: 02/20/2012 16:19:46 ******/
93IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN]') AND type = 'F')
94ALTER TABLE [dbo].[GIAOVIEN_DAY_MONHOC] DROP CONSTRAINT [FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN]
95GO
96/****** Object: ForeignKey [FK_GIAOVIEN_DAY_MONHOC_MONHOC] Script Date: 02/20/2012 16:19:46 ******/
97IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_DAY_MONHOC_MONHOC]') AND type = 'F')
98ALTER TABLE [dbo].[GIAOVIEN_DAY_MONHOC] DROP CONSTRAINT [FK_GIAOVIEN_DAY_MONHOC_MONHOC]
99GO
100/****** Object: Table [dbo].[GIAOVIEN_DAY_MONHOC] Script Date: 02/20/2012 16:19:46 ******/
101IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN]') AND type = 'F')
102ALTER TABLE [dbo].[GIAOVIEN_DAY_MONHOC] DROP CONSTRAINT [FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN]
103GO
104IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_DAY_MONHOC_MONHOC]') AND type = 'F')
105ALTER TABLE [dbo].[GIAOVIEN_DAY_MONHOC] DROP CONSTRAINT [FK_GIAOVIEN_DAY_MONHOC_MONHOC]
106GO
107IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[GIAOVIEN_DAY_MONHOC]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
108DROP TABLE [dbo].[GIAOVIEN_DAY_MONHOC]
109GO
110/****** Object: Table [dbo].[GIAOVIEN] Script Date: 02/20/2012 16:19:46 ******/
111IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_GIAOVIEN]') AND type = 'F')
112ALTER TABLE [dbo].[GIAOVIEN] DROP CONSTRAINT [FK_GIAOVIEN_GIAOVIEN]
113GO
114IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[GIAOVIEN]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
115DROP TABLE [dbo].[GIAOVIEN]
116GO
117/****** Object: Table [dbo].[LOPHOC] Script Date: 02/20/2012 16:19:46 ******/
118IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_LOPHOC_GIAOVIEN]') AND type = 'F')
119ALTER TABLE [dbo].[LOPHOC] DROP CONSTRAINT [FK_LOPHOC_GIAOVIEN]
120GO
121IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_LOPHOC_Table1]') AND type = 'F')
122ALTER TABLE [dbo].[LOPHOC] DROP CONSTRAINT [FK_LOPHOC_Table1]
123GO
124IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[LOPHOC]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
125DROP TABLE [dbo].[LOPHOC]
126GO
127/****** Object: Table [dbo].[PHANCONG] Script Date: 02/20/2012 16:19:45 ******/
128IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_GIAOVIEN]') AND type = 'F')
129ALTER TABLE [dbo].[PHANCONG] DROP CONSTRAINT [FK_PHANCONG_GIAOVIEN]
130GO
131IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_LOPHOC]') AND type = 'F')
132ALTER TABLE [dbo].[PHANCONG] DROP CONSTRAINT [FK_PHANCONG_LOPHOC]
133GO
134IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_MONHOC]') AND type = 'F')
135ALTER TABLE [dbo].[PHANCONG] DROP CONSTRAINT [FK_PHANCONG_MONHOC]
136GO
137IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[PHANCONG]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
138DROP TABLE [dbo].[PHANCONG]
139GO
140/****** Object: Table [dbo].[MONHOC] Script Date: 02/20/2012 16:19:45 ******/
141IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MONHOC]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
142DROP TABLE [dbo].[MONHOC]
143GO
144/****** Object: Table [dbo].[KETQUA] Script Date: 02/20/2012 16:19:45 ******/
145IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_KETQUA_MONHOC]') AND type = 'F')
146ALTER TABLE [dbo].[KETQUA] DROP CONSTRAINT [FK_KETQUA_MONHOC]
147GO
148IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_KETQUA_Table1]') AND type = 'F')
149ALTER TABLE [dbo].[KETQUA] DROP CONSTRAINT [FK_KETQUA_Table1]
150GO
151IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[KETQUA]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
152DROP TABLE [dbo].[KETQUA]
153GO
154/****** Object: Table [dbo].[HOCVIEN] Script Date: 02/20/2012 16:19:45 ******/
155IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Table1_LOPHOC]') AND type = 'F')
156ALTER TABLE [dbo].[HOCVIEN] DROP CONSTRAINT [FK_Table1_LOPHOC]
157GO
158IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[HOCVIEN]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
159DROP TABLE [dbo].[HOCVIEN]
160GO
161/****** Object: Table [dbo].[HOCVIEN] Script Date: 02/20/2012 16:19:45 ******/
162SET ANSI_NULLS ON
163GO
164SET QUOTED_IDENTIFIER ON
165GO
166IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[HOCVIEN]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
167BEGIN
168CREATE TABLE [dbo].[HOCVIEN](
169 [MaHocVien] [nchar](10) NOT NULL,
170 [TenHocVien] [nvarchar](50) NULL,
171 [NgaySinh] [datetime] NULL,
172 [TinhTrang] [nvarchar](50) NULL,
173 [MaLop] [nchar](10) NULL,
174 CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
175(
176 [MaHocVien] ASC
177) ON [PRIMARY]
178) ON [PRIMARY]
179END
180GO
181INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000001 ', N'Nguyá»…n Thùy Linh', CAST(0x0000808700000000 AS DateTime), N'buá»™c thôi há»c', N'LH000001 ')
182INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000002 ', N'Nguyá»…n Thị Kiá»u Trang', CAST(0x0000861100000000 AS DateTime), N'Ä‘ang há»c', N'LH000001 ')
183INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000003 ', N'Nguyá»…n Xuân Thu', CAST(0x0000878800000000 AS DateTime), N'Ä‘ang há»c', N'LH000002 ')
184INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000004 ', N'Trần Trung ChÃnh', CAST(0x0000838900000000 AS DateTime), N'Ä‘ang há»c', N'LH000003 ')
185INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000005 ', N'Trần Minh An', CAST(0x0000832500000000 AS DateTime), N'Ä‘ang há»c', N'LH000003 ')
186INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000006 ', N'Trương Mỹ Linh', CAST(0x0000805400000000 AS DateTime), N'đã tốt nghiệp', N'LH000004 ')
187INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000007 ', N'Trần Hà o', CAST(0x00007F1B00000000 AS DateTime), N'đã tốt nghiệp', N'LH000004 ')
188INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000008 ', N'Nguyá»…n Huỳnh', CAST(0x0000838000000000 AS DateTime), N'Ä‘ang há»c', N'LH000004 ')
189INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000009 ', N'Nguyá»…n Xuân TrÆ°á»ng', CAST(0x000084F700000000 AS DateTime), N'Ä‘ang há»c', N'LH000005 ')
190INSERT [dbo].[HOCVIEN] ([MaHocVien], [TenHocVien], [NgaySinh], [TinhTrang], [MaLop]) VALUES (N'HV000010 ', N'Nguyá»…n Bình Minh', CAST(0x0000838900000000 AS DateTime), N'Ä‘ang há»c', N'LH000004 ')
191/****** Object: Table [dbo].[KETQUA] Script Date: 02/20/2012 16:19:45 ******/
192SET ANSI_NULLS ON
193GO
194SET QUOTED_IDENTIFIER ON
195GO
196IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[KETQUA]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
197BEGIN
198CREATE TABLE [dbo].[KETQUA](
199 [MaHV] [nchar](10) NOT NULL,
200 [MaMonHoc] [nchar](10) NOT NULL,
201 [LanThi] [int] NOT NULL,
202 [Diem] [float] NULL,
203 CONSTRAINT [PK_KETQUA] PRIMARY KEY CLUSTERED
204(
205 [MaHV] ASC,
206 [MaMonHoc] ASC,
207 [LanThi] ASC
208) ON [PRIMARY]
209) ON [PRIMARY]
210END
211GO
212INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000001 ', N'MH00001 ', 1, 5.5)
213INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000001 ', N'MH00004 ', 1, 6)
214INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000002 ', N'MH00001 ', 1, 7)
215INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000002 ', N'MH00004 ', 1, 8)
216INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000003 ', N'MH00008 ', 1, 8.7)
217INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000003 ', N'MH00009 ', 1, 9)
218INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000003 ', N'MH00010 ', 1, 10)
219INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000004 ', N'MH00008 ', 1, 4)
220INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000004 ', N'MH00008 ', 2, 3)
221INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000004 ', N'MH00009 ', 1, 2)
222INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000004 ', N'MH00009 ', 2, 5)
223INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000004 ', N'MH00010 ', 1, 6)
224INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000005 ', N'MH00008 ', 1, 7.5)
225INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000005 ', N'MH00009 ', 1, 1)
226INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000005 ', N'MH00009 ', 2, 7)
227INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000005 ', N'MH00010 ', 1, 1)
228INSERT [dbo].[KETQUA] ([MaHV], [MaMonHoc], [LanThi], [Diem]) VALUES (N'HV000005 ', N'MH00010 ', 2, 3.5)
229/****** Object: Table [dbo].[MONHOC] Script Date: 02/20/2012 16:19:45 ******/
230SET ANSI_NULLS ON
231GO
232SET QUOTED_IDENTIFIER ON
233GO
234IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[MONHOC]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
235BEGIN
236CREATE TABLE [dbo].[MONHOC](
237 [MaMonHoc] [nchar](10) NOT NULL,
238 [TenMonHoc] [nvarchar](50) NULL,
239 [SoChi] [int] NULL,
240 CONSTRAINT [PK_MONHOC] PRIMARY KEY CLUSTERED
241(
242 [MaMonHoc] ASC
243) ON [PRIMARY]
244) ON [PRIMARY]
245END
246GO
247INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00001 ', N'Cơ sở dữ liệu', 5)
248INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00002 ', N'Cấu trúc dữ liệu', 6)
249INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00003 ', N'Mạng máy tÃnh', 4)
250INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00004 ', N'Toán cao cấp', 6)
251INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00005 ', N'Tin há»c cÆ¡ sở', 3)
252INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00006 ', N'Công nghệ phân má»m', 4)
253INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00007 ', N'Trà tuệ nhân tạo', 4)
254INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00008 ', N'Khai thác dữ liệu', 3)
255INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00009 ', N'Phân tÃch thiết kế hệ thống thông tin', 3)
256INSERT [dbo].[MONHOC] ([MaMonHoc], [TenMonHoc], [SoChi]) VALUES (N'MH00010 ', N'Hệ thống thông minh', 4)
257/****** Object: Table [dbo].[PHANCONG] Script Date: 02/20/2012 16:19:45 ******/
258SET ANSI_NULLS ON
259GO
260SET QUOTED_IDENTIFIER ON
261GO
262IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[PHANCONG]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
263BEGIN
264CREATE TABLE [dbo].[PHANCONG](
265 [MaGV] [nchar](10) NOT NULL,
266 [MaMH] [nchar](10) NOT NULL,
267 [MaLop] [nchar](10) NOT NULL,
268 CONSTRAINT [PK_PHANCONG] PRIMARY KEY CLUSTERED
269(
270 [MaGV] ASC,
271 [MaMH] ASC,
272 [MaLop] ASC
273) ON [PRIMARY]
274) ON [PRIMARY]
275END
276GO
277INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00001 ', N'MH00001 ', N'LH000001 ')
278INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00001 ', N'MH00004 ', N'LH000001 ')
279INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00003 ', N'MH00010 ', N'LH000005 ')
280INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00004 ', N'MH00009 ', N'LH000004 ')
281INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00005 ', N'MH00008 ', N'LH000002 ')
282INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00005 ', N'MH00008 ', N'LH000004 ')
283INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00006 ', N'MH00008 ', N'LH000003 ')
284INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00006 ', N'MH00009 ', N'LH000002 ')
285INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00006 ', N'MH00009 ', N'LH000003 ')
286INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00006 ', N'MH00010 ', N'LH000004 ')
287INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00007 ', N'MH00010 ', N'LH000002 ')
288INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00007 ', N'MH00010 ', N'LH000003 ')
289INSERT [dbo].[PHANCONG] ([MaGV], [MaMH], [MaLop]) VALUES (N'GV00008 ', N'MH00002 ', N'LH000004 ')
290/****** Object: Table [dbo].[LOPHOC] Script Date: 02/20/2012 16:19:46 ******/
291SET ANSI_NULLS ON
292GO
293SET QUOTED_IDENTIFIER ON
294GO
295IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[LOPHOC]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
296BEGIN
297CREATE TABLE [dbo].[LOPHOC](
298 [MaLop] [nchar](10) NOT NULL,
299 [SiSo] [int] NULL,
300 [LopTruong] [nchar](10) NULL,
301 [GVQuanLi] [nchar](10) NULL,
302 [NamBatDau] [int] NULL,
303 [NamKetThuc] [int] NULL,
304 CONSTRAINT [PK_LOPHOC] PRIMARY KEY CLUSTERED
305(
306 [MaLop] ASC
307) ON [PRIMARY]
308) ON [PRIMARY]
309END
310GO
311INSERT [dbo].[LOPHOC] ([MaLop], [SiSo], [LopTruong], [GVQuanLi], [NamBatDau], [NamKetThuc]) VALUES (N'LH000001 ', 1, N'HV000002 ', N'GV00001 ', 2010, 2014)
312INSERT [dbo].[LOPHOC] ([MaLop], [SiSo], [LopTruong], [GVQuanLi], [NamBatDau], [NamKetThuc]) VALUES (N'LH000002 ', 1, N'HV000003 ', N'GV00003 ', 2009, 2013)
313INSERT [dbo].[LOPHOC] ([MaLop], [SiSo], [LopTruong], [GVQuanLi], [NamBatDau], [NamKetThuc]) VALUES (N'LH000003 ', 2, N'HV000004 ', N'GV00008 ', 2010, 2014)
314INSERT [dbo].[LOPHOC] ([MaLop], [SiSo], [LopTruong], [GVQuanLi], [NamBatDau], [NamKetThuc]) VALUES (N'LH000004 ', 4, N'HV000008 ', N'GV00010 ', 2011, 2015)
315INSERT [dbo].[LOPHOC] ([MaLop], [SiSo], [LopTruong], [GVQuanLi], [NamBatDau], [NamKetThuc]) VALUES (N'LH000005 ', 1, N'HV000009 ', N'GV00009 ', 2010, 2014)
316/****** Object: Table [dbo].[GIAOVIEN] Script Date: 02/20/2012 16:19:46 ******/
317SET ANSI_NULLS ON
318GO
319SET QUOTED_IDENTIFIER ON
320GO
321IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[GIAOVIEN]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
322BEGIN
323CREATE TABLE [dbo].[GIAOVIEN](
324 [MaGV] [nchar](10) NOT NULL,
325 [TenGV] [nvarchar](50) NULL,
326 [NgaySinh] [datetime] NULL,
327 [GioiTinh] [nvarchar](10) NULL,
328 [DienThoai] [nchar](10) NULL,
329 [MaGVQuanLi] [nchar](10) NULL,
330 CONSTRAINT [PK_GIAOVIEN] PRIMARY KEY CLUSTERED
331(
332 [MaGV] ASC
333) ON [PRIMARY]
334) ON [PRIMARY]
335END
336GO
337INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00001 ', N'Nguyễn Văn An', CAST(0x0000739200000000 AS DateTime), N'Nam', NULL, N'GV00002 ')
338INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00002 ', N'Nguyễn Thị Như Lan', CAST(0x0000792800000000 AS DateTime), N'Nữ', NULL, N'GV00005 ')
339INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00003 ', N'Trần Minh Anh', CAST(0x00007B0400000000 AS DateTime), N'Nam', N'0909123999', N'GV00002 ')
340INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00004 ', N'TrÆ°Æ¡ng TÆ°á»ng Vi', CAST(0x00007DAC00000000 AS DateTime), N'Nữ', N'0998990909', N'GV00008 ')
341INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00005 ', N'Hà Anh Tuấn', CAST(0x00007C0300000000 AS DateTime), N'Nam', N'0909909000', N'GV00008 ')
342INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00006 ', N'Trần Anh Dũng', CAST(0x0000711300000000 AS DateTime), N'Nam', NULL, N'GV00010 ')
343INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00007 ', N'Trần Duy Tân', CAST(0x00006F4C00000000 AS DateTime), N'Nam', NULL, N'GV00002 ')
344INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00008 ', N'Nguyễn Thị Linh', CAST(0x0000717200000000 AS DateTime), N'Nữ', N'0938079700', N'GV00009 ')
345INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00009 ', N'Trần Thị Kiá»u', CAST(0x00006DDE00000000 AS DateTime), N'Nữ', NULL, NULL)
346INSERT [dbo].[GIAOVIEN] ([MaGV], [TenGV], [NgaySinh], [GioiTinh], [DienThoai], [MaGVQuanLi]) VALUES (N'GV00010 ', N'Trần Phương Loan', CAST(0x00006FC000000000 AS DateTime), N'Nữ', NULL, NULL)
347/****** Object: Table [dbo].[GIAOVIEN_DAY_MONHOC] Script Date: 02/20/2012 16:19:46 ******/
348SET ANSI_NULLS ON
349GO
350SET QUOTED_IDENTIFIER ON
351GO
352IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[GIAOVIEN_DAY_MONHOC]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
353BEGIN
354CREATE TABLE [dbo].[GIAOVIEN_DAY_MONHOC](
355 [MaGV] [nchar](10) NOT NULL,
356 [MaMH] [nchar](10) NOT NULL,
357 [ThamNien] [int] NULL,
358 [SoLopDaDay] [int] NULL,
359 CONSTRAINT [PK_GIAOVIEN_DAY_MONHOC] PRIMARY KEY CLUSTERED
360(
361 [MaGV] ASC,
362 [MaMH] ASC
363) ON [PRIMARY]
364) ON [PRIMARY]
365END
366GO
367INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00001 ', N'MH00001 ', 3, NULL)
368INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00001 ', N'MH00004 ', 2, NULL)
369INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00002 ', N'MH00001 ', 1, NULL)
370INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00002 ', N'MH00002 ', 1, NULL)
371INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00003 ', N'MH00006 ', 2, NULL)
372INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00003 ', N'MH00007 ', 3, NULL)
373INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00003 ', N'MH00010 ', 4, NULL)
374INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00004 ', N'MH00009 ', 6, NULL)
375INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00004 ', N'MH00010 ', 1, NULL)
376INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00005 ', N'MH00008 ', 4, NULL)
377INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00005 ', N'MH00010 ', 2, NULL)
378INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00006 ', N'MH00008 ', 4, NULL)
379INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00006 ', N'MH00009 ', 2, NULL)
380INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00006 ', N'MH00010 ', 4, NULL)
381INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00007 ', N'MH00010 ', 7, NULL)
382INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00008 ', N'MH00001 ', 2, NULL)
383INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00008 ', N'MH00002 ', 1, NULL)
384INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00009 ', N'MH00010 ', 2, NULL)
385INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00010 ', N'MH00001 ', 3, NULL)
386INSERT [dbo].[GIAOVIEN_DAY_MONHOC] ([MaGV], [MaMH], [ThamNien], [SoLopDaDay]) VALUES (N'GV00010 ', N'MH00002 ', 1, NULL)
387/****** Object: ForeignKey [FK_Table1_LOPHOC] Script Date: 02/20/2012 16:19:45 ******/
388IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Table1_LOPHOC]') AND type = 'F')
389ALTER TABLE [dbo].[HOCVIEN] WITH CHECK ADD CONSTRAINT [FK_Table1_LOPHOC] FOREIGN KEY([MaLop])
390REFERENCES [dbo].[LOPHOC] ([MaLop])
391GO
392IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Table1_LOPHOC]') AND type = 'F')
393ALTER TABLE [dbo].[HOCVIEN] CHECK CONSTRAINT [FK_Table1_LOPHOC]
394GO
395/****** Object: ForeignKey [FK_KETQUA_MONHOC] Script Date: 02/20/2012 16:19:45 ******/
396IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_KETQUA_MONHOC]') AND type = 'F')
397ALTER TABLE [dbo].[KETQUA] WITH CHECK ADD CONSTRAINT [FK_KETQUA_MONHOC] FOREIGN KEY([MaMonHoc])
398REFERENCES [dbo].[MONHOC] ([MaMonHoc])
399GO
400IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_KETQUA_MONHOC]') AND type = 'F')
401ALTER TABLE [dbo].[KETQUA] CHECK CONSTRAINT [FK_KETQUA_MONHOC]
402GO
403/****** Object: ForeignKey [FK_KETQUA_Table1] Script Date: 02/20/2012 16:19:45 ******/
404IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_KETQUA_Table1]') AND type = 'F')
405ALTER TABLE [dbo].[KETQUA] WITH CHECK ADD CONSTRAINT [FK_KETQUA_Table1] FOREIGN KEY([MaHV])
406REFERENCES [dbo].[HOCVIEN] ([MaHocVien])
407GO
408IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_KETQUA_Table1]') AND type = 'F')
409ALTER TABLE [dbo].[KETQUA] CHECK CONSTRAINT [FK_KETQUA_Table1]
410GO
411/****** Object: ForeignKey [FK_PHANCONG_GIAOVIEN] Script Date: 02/20/2012 16:19:45 ******/
412IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_GIAOVIEN]') AND type = 'F')
413ALTER TABLE [dbo].[PHANCONG] WITH CHECK ADD CONSTRAINT [FK_PHANCONG_GIAOVIEN] FOREIGN KEY([MaGV])
414REFERENCES [dbo].[GIAOVIEN] ([MaGV])
415GO
416IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_GIAOVIEN]') AND type = 'F')
417ALTER TABLE [dbo].[PHANCONG] CHECK CONSTRAINT [FK_PHANCONG_GIAOVIEN]
418GO
419/****** Object: ForeignKey [FK_PHANCONG_LOPHOC] Script Date: 02/20/2012 16:19:45 ******/
420IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_LOPHOC]') AND type = 'F')
421ALTER TABLE [dbo].[PHANCONG] WITH CHECK ADD CONSTRAINT [FK_PHANCONG_LOPHOC] FOREIGN KEY([MaLop])
422REFERENCES [dbo].[LOPHOC] ([MaLop])
423GO
424IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_LOPHOC]') AND type = 'F')
425ALTER TABLE [dbo].[PHANCONG] CHECK CONSTRAINT [FK_PHANCONG_LOPHOC]
426GO
427/****** Object: ForeignKey [FK_PHANCONG_MONHOC] Script Date: 02/20/2012 16:19:45 ******/
428IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_MONHOC]') AND type = 'F')
429ALTER TABLE [dbo].[PHANCONG] WITH CHECK ADD CONSTRAINT [FK_PHANCONG_MONHOC] FOREIGN KEY([MaMH])
430REFERENCES [dbo].[MONHOC] ([MaMonHoc])
431GO
432IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PHANCONG_MONHOC]') AND type = 'F')
433ALTER TABLE [dbo].[PHANCONG] CHECK CONSTRAINT [FK_PHANCONG_MONHOC]
434GO
435/****** Object: ForeignKey [FK_LOPHOC_GIAOVIEN] Script Date: 02/20/2012 16:19:46 ******/
436IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_LOPHOC_GIAOVIEN]') AND type = 'F')
437ALTER TABLE [dbo].[LOPHOC] WITH CHECK ADD CONSTRAINT [FK_LOPHOC_GIAOVIEN] FOREIGN KEY([GVQuanLi])
438REFERENCES [dbo].[GIAOVIEN] ([MaGV])
439GO
440IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_LOPHOC_GIAOVIEN]') AND type = 'F')
441ALTER TABLE [dbo].[LOPHOC] CHECK CONSTRAINT [FK_LOPHOC_GIAOVIEN]
442GO
443/****** Object: ForeignKey [FK_LOPHOC_Table1] Script Date: 02/20/2012 16:19:46 ******/
444IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_LOPHOC_Table1]') AND type = 'F')
445ALTER TABLE [dbo].[LOPHOC] WITH CHECK ADD CONSTRAINT [FK_LOPHOC_Table1] FOREIGN KEY([LopTruong])
446REFERENCES [dbo].[HOCVIEN] ([MaHocVien])
447GO
448IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_LOPHOC_Table1]') AND type = 'F')
449ALTER TABLE [dbo].[LOPHOC] CHECK CONSTRAINT [FK_LOPHOC_Table1]
450GO
451/****** Object: ForeignKey [FK_GIAOVIEN_GIAOVIEN] Script Date: 02/20/2012 16:19:46 ******/
452IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_GIAOVIEN]') AND type = 'F')
453ALTER TABLE [dbo].[GIAOVIEN] WITH CHECK ADD CONSTRAINT [FK_GIAOVIEN_GIAOVIEN] FOREIGN KEY([MaGVQuanLi])
454REFERENCES [dbo].[GIAOVIEN] ([MaGV])
455GO
456IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_GIAOVIEN]') AND type = 'F')
457ALTER TABLE [dbo].[GIAOVIEN] CHECK CONSTRAINT [FK_GIAOVIEN_GIAOVIEN]
458GO
459/****** Object: ForeignKey [FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN] Script Date: 02/20/2012 16:19:46 ******/
460IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN]') AND type = 'F')
461ALTER TABLE [dbo].[GIAOVIEN_DAY_MONHOC] WITH CHECK ADD CONSTRAINT [FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN] FOREIGN KEY([MaGV])
462REFERENCES [dbo].[GIAOVIEN] ([MaGV])
463GO
464IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN]') AND type = 'F')
465ALTER TABLE [dbo].[GIAOVIEN_DAY_MONHOC] CHECK CONSTRAINT [FK_GIAOVIEN_DAY_MONHOC_GIAOVIEN]
466GO
467/****** Object: ForeignKey [FK_GIAOVIEN_DAY_MONHOC_MONHOC] Script Date: 02/20/2012 16:19:46 ******/
468IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_DAY_MONHOC_MONHOC]') AND type = 'F')
469ALTER TABLE [dbo].[GIAOVIEN_DAY_MONHOC] WITH CHECK ADD CONSTRAINT [FK_GIAOVIEN_DAY_MONHOC_MONHOC] FOREIGN KEY([MaMH])
470REFERENCES [dbo].[MONHOC] ([MaMonHoc])
471GO
472IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_GIAOVIEN_DAY_MONHOC_MONHOC]') AND type = 'F')
473ALTER TABLE [dbo].[GIAOVIEN_DAY_MONHOC] CHECK CONSTRAINT [FK_GIAOVIEN_DAY_MONHOC_MONHOC]
474GO