xin script của Quản lý hàng hoa và quản lý sinh viên.

anh em nào có script (có lun phần insert) của Quản lý hàng hoa và quản lý sinh viên thì share cho ae với. Thanks nhìu nhìu :lol!:

mình mới tạo một bản scrip của sinh viên,bạn coi thử nha, còn ai có bản hàng hóa rồi, thì post lên cho anh em coi luôn nha.


CREATE DATABASE QUAN_LY_SINH_VIEN
USE QUAN_LY_SINH_VIEN

CREATE TABLE KHOA
(
MA VARCHAR(10) NOT NULL,
TENKHOA NVARCHAR(100),
NAMTHANHLAP INT,
CONSTRAINT PK_KHOA PRIMARY KEY (MA)
)

CREATE TABLE KHOA_HOC
(
MA VARCHAR(10) NOT NULL,
NAMBATDAU INT,
NAMKETTHUC INT,
CONSTRAINT PK_KHOA_HOC PRIMARY KEY(MA)
)

CREATE TABLE SINH_VIEN
(
MA VARCHAR(10) NOT NULL,
HOTEN NVARCHAR(100),
NAMSINH INT,
DANTOC NVARCHAR(20),
MALOP VARCHAR(10),
CONSTRAINT PK_SINH_VIEN PRIMARY KEY(MA)
)

CREATE TABLE CHUONG_TRINH
(
MA VARCHAR(10) NOT NULL,
TENCHUONGTRINH NVARCHAR(100),
CONSTRAINT PK_CHUONG_TRINH PRIMARY KEY(MA)
)

CREATE TABLE MON_HOC
(
MA VARCHAR(10) NOT NULL,
TENMONHOC NVARCHAR(100),
MAKHOA VARCHAR(10),
CONSTRAINT PK_MON_HOC PRIMARY KEY(MA)
)

CREATE TABLE KET_QUA
(
MASINHVIEN VARCHAR(10) NOT NULL,
MAMONHOC VARCHAR(10) NOT NULL,
LANTHI INT NOT NULL,
DIEM FLOAT,
CONSTRAINT PK_KET_QUA PRIMARY KEY(MASINHVIEN,MAMONHOC,LANTHI)
)

CREATE TABLE GIANG_KHOA
(
MACHUONGTRINH VARCHAR(10) NOT NULL,
MAKHOA VARCHAR(10) NOT NULL,
MAMONHOC VARCHAR(10) NOT NULL,
NAMHOC INT,
HOCKY INT,
SOTIETLYTHUYET INT,
SOTIETTHUCHANH INT,
SOTINCHI INT,
CONSTRAINT PK_GIANG_KHOA PRIMARY KEY(MACHUONGTRINH,MAKHOA,MAMONHOC)
)

CREATE TABLE LOP
(
MA VARCHAR(10) NOT NULL,
MAKHOAHOC VARCHAR(10),
MAKHOA VARCHAR(10),
MACHUONGTRINH VARCHAR(10),
SOTHUTU INT,
CONSTRAINT PK_LOP PRIMARY KEY(MA)
)

ALTER TABLE MON_HOC
ADD CONSTRAINT FK_MONHOC__KHOA FOREIGN KEY(MAKHOA) REFERENCES KHOA(MA)

ALTER TABLE GIANG_KHOA
ADD CONSTRAINT FK_GIANG_KHOA__KHOA FOREIGN KEY(MAKHOA) REFERENCES KHOA(MA)

ALTER TABLE LOP
ADD CONSTRAINT FK_LOP__KHOA_HOC FOREIGN KEY(MAKHOAHOC) REFERENCES KHOA_HOC(MA)

ALTER TABLE KET_QUA
ADD CONSTRAINT FK_KET_QUA__MON_HOC FOREIGN KEY(MAMONHOC) REFERENCES MON_HOC(MA)

ALTER TABLE GIANG_KHOA
ADD CONSTRAINT FK_GIANG_KHOA__MON_HOC FOREIGN KEY(MAMONHOC) REFERENCES MON_HOC(MA)

ALTER TABLE GIANG_KHOA
ADD CONSTRAINT FK_GIANG_KHOA__CHUONG_TRINH FOREIGN KEY(MACHUONGTRINH) REFERENCES CHUONG_TRINH(MA)

ALTER TABLE LOP
ADD CONSTRAINT FK_LOP__KHOA FOREIGN KEY(MAKHOA) REFERENCES KHOA(MA)

ALTER TABLE LOP
ADD CONSTRAINT FK_LOP__CHUONG_TRINH FOREIGN KEY(MACHUONGTRINH) REFERENCES CHUONG_TRINH(MA)

ALTER TABLE SINH_VIEN
ADD CONSTRAINT FK_SINH_VIEN__LOP FOREIGN KEY(MALOP) REFERENCES LOP(MA)

ALTER TABLE KET_QUA
ADD CONSTRAINT FK_KET_QUA__SINH_VIEN FOREIGN KEY(MASINHVIEN) REFERENCES SINH_VIEN(MA)

INSERT INTO KHOA VALUES('CNTT',N'Công Ngh? Thông Tin',1995)
INSERT INTO KHOA VALUES('VL',N'V?t Lý',1970)

INSERT INTO KHOA_HOC VALUES('K2002',2002,2006)
INSERT INTO KHOA_HOC VALUES('K2003',2003,2007)
INSERT INTO KHOA_HOC VALUES('K2004',2004,2008)

INSERT INTO CHUONG_TRINH VALUES('CQ',N'Chính Qui')

INSERT INTO MON_HOC VALUES('THT01',N'Toán Cao C?p A1','CNTT')
INSERT INTO MON_HOC VALUES('VLT01',N'Toán Cao C?p A1','VL')
INSERT INTO MON_HOC VALUES('THT02',N'Toán R?i R?c','CNTT')
INSERT INTO MON_HOC VALUES('THCS01',N'C?u Trúc D? Li?u 1','CNTT')
INSERT INTO MON_HOC VALUES('THCS02',N'H? Ði?u Hành','CNTT')

INSERT INTO GIANG_KHOA VALUES('CQ','CNTT','THT01',2003,1,60,0,5)
INSERT INTO GIANG_KHOA VALUES('CQ','CNTT','THT02',2003,2,45,0,4)
INSERT INTO GIANG_KHOA VALUES('CQ','CNTT','THCS01',2004,1,45,30,4)

INSERT INTO LOP VALUES('TH2002/01','K2002','CNTT','CQ',1)
INSERT INTO LOP VALUES('TH2002/02','K2002','CNTT','CQ',2)
INSERT INTO LOP VALUES('VL2003/01','K2003','VL','CQ',1)

INSERT INTO SINH_VIEN VALUES('0212001',N'Nguy?n Vinh An',1984,'Kinh','TH2002/01')
INSERT INTO SINH_VIEN VALUES('0212002',N'Nguy?n Thanh Bình',1985,'Kinh','TH2002/01')
INSERT INTO SINH_VIEN VALUES('0212003',N'Nguy?n Thanh Cu?ng',1984,'Kinh','TH2002/02')
INSERT INTO SINH_VIEN VALUES('0212004',N'Nguy?n Qu?c Duy',1983,'Kinh','TH2002/02')
INSERT INTO SINH_VIEN VALUES('0311001',N'Phan Tu?n Anh',1985,'Kinh','VL2003/01')
INSERT INTO SINH_VIEN VALUES('0311002',N'Hu?nh Thanh Sang',1984,'Kinh','VL2003/01')

INSERT INTO KET_QUA VALUES('0212001','THT01',1,4)
INSERT INTO KET_QUA VALUES('0212001','THT01',2,7)
INSERT INTO KET_QUA VALUES('0212002','THT01',1,8)
INSERT INTO KET_QUA VALUES('0212003','THT01',1,6)
INSERT INTO KET_QUA VALUES('0212004','THT01',1,9)
INSERT INTO KET_QUA VALUES('0212001','THT02',1,8)
INSERT INTO KET_QUA VALUES('0212002','THT02',1,5.5)
INSERT INTO KET_QUA VALUES('0212003','THT02',1,4)
INSERT INTO KET_QUA VALUES('0212003','THT02',1,6)
INSERT INTO KET_QUA VALUES('0212001','THCS01',1,6.5)
INSERT INTO KET_QUA VALUES('0212002','THCS01',1,4)
INSERT INTO KET_QUA VALUES('0212003','THCS01',1,7)

Mình cũng đã tạo một file scrip của DiaOc, các bạn xem thử nha:

CREATE DATABASE QLDO
USE QLDO
GO

CREATE TABLE NGUOI_BAN
(
MANB CHAR(9) NOT NULL,
HOTEN NVARCHAR(50),
DIACHI NVARCHAR(70),
SODT CHAR(10),
CONSTRAINT PK_NGUOI_BAN PRIMARY KEY(MANB)
)

CREATE TABLE DIA_OC
(
MADO CHAR(9) NOT NULL,
SO NVARCHAR(10),
DUONG NVARCHAR(30),
PHUONG NVARCHAR(30),
QUAN NVARCHAR(30),
DTDAT REAL,
DTXD REAL,
HUONG NVARCHAR(10),
VITRI NVARCHAR(20),
MOTA NVARCHAR(100),
MALDO INT,
CONSTRAINT PK_DIA_OC PRIMARY KEY(MADO)
)

CREATE TABLE LOAI_DIA_OC
(
MALDO INT NOT NULL,
TENLDO NVARCHAR(50),
CONSTRAINT PK_LOAI_DIA_OC PRIMARY KEY(MALDO)
)


CREATE TABLE DICH_VU
(
MADV INT NOT NULL,
TENDV NVARCHAR(50),
TIENDV MONEY,
CONSTRAINT PK_DICH_VU PRIMARY KEY(MADV)

)
CREATE TABLE PHIEU_DANG_KY
(
MAPDK CHAR(10) NOT NULL,
NGAYDK DATETIME,
TONGSODV INT,
TONGTIEN MONEY,
MANB CHAR(9),
CONSTRAINT PK_PHIEU_DANG_KY PRIMARY KEY(MAPDK)
)

CREATE TABLE CT_PDK
(
MAPDK CHAR(10) NOT NULL,
MADO CHAR(9) NOT NULL,
MADV INT NOT NULL,
TUNGAY DATETIME,
DENNGAY DATETIME,
SOTIEN MONEY
CONSTRAINT PK_CT_PDK PRIMARY KEY(MAPDK,MADO,MADV)
)

CREATE TABLE PHIEU_THU
(
MAPT CHAR(10) NOT NULL,
PHIEUDK CHAR(10),
NGAYTHU DATETIME,
LANTHU INT,
SOTIEN MONEY,
MAPTGOC CHAR(10),
CONSTRAINT PK_PHIEU_THU PRIMARY KEY(MAPT)
)

CREATE TABLE PHIEU_GIA_HAN
(
MAPGH CHAR(10) NOT NULL,
PHIEUDK CHAR(10),
MADO CHAR(9),
MADV INT,
NGAYGIAHAN DATETIME,
TUNGAY DATETIME,
DENNGAY DATETIME,
CONSTRAINT PK_PHIEU_GIA_HAN PRIMARY KEY(MAPGH)
)

ALTER TABLE PHIEU_DANG_KY
ADD CONSTRAINT FK_PHIEU_DANG_KY__NGUOI_BAN FOREIGN KEY(MANB) REFERENCES NGUOI_BAN(MANB)
GO

ALTER TABLE DIA_OC
ADD CONSTRAINT FK_DIA_OC__LOAI_DIA_OC FOREIGN KEY(MALDO) REFERENCES LOAI_DIA_OC(MALDO)
GO

ALTER TABLE PHIEU_THU
ADD CONSTRAINT FK_PHIEU_THU__PHIEU_DANG_KY FOREIGN KEY(PHIEUDK)REFERENCES PHIEU_DANG_KY(MAPDK)
GO

ALTER TABLE CT_PDK
ADD CONSTRAINT FK_CT_PDK__PHIEU_DNG_KY FOREIGN KEY(MAPDK) REFERENCES PHIEU_DANG_KY(MAPDK)
GO

ALTER TABLE CT_PDK
ADD CONSTRAINT FK_CT_PKD__DIA_OC FOREIGN KEY(MADO) REFERENCES DIA_OC(MADO)
GO

ALTER TABLE CT_PDK
ADD CONSTRAINT FK_CT_PDK__DICH_VU FOREIGN KEY(MADV) REFERENCES DICH_VU(MADV)
GO

ALTER TABLE PHIEU_GIA_HAN
ADD CONSTRAINT FK_PHIEU_GIA_HAN__CT_PDK FOREIGN KEY(PHIEUDK,MADO,MADV) REFERENCES CT_PDK(MAPDK,MADO,MADV)
GO

ALTER TABLE PHIEU_THU
ADD CONSTRAINT FK_PHIEU_THU__PHIEU_THU FOREIGN KEY(MAPTGOC) REFERENCES PHIEU_THU(MAPT)
GO

INSERT INTO NGUOI_BAN VALUES('111222333',N'Nguy?n Tu?ng Vân',N'330/2 Lê H?ng Phong Qu?n 5','8111222')
INSERT INTO NGUOI_BAN VALUES('222333444',N'Tr?n Thanh Tùng',N'111 Truong Ð?nh Qu?n 3','8222333')
INSERT INTO NGUOI_BAN VALUES('333444555',N'Nguy?n Ng?c Nga',N'315 An Duong Vuong Qu?n 5','8333444')

INSERT INTO LOAI_DIA_OC VALUES(1,N'Ð?A ?C LO?I 1')
INSERT INTO LOAI_DIA_OC VALUES(2,N'Ð?A ?C LO?I 2')


INSERT INTO DIA_OC VALUES('DO111','731',N'Tr?n Hung Ð?o','7','1','1000','800',N'Ðông',N'M?t ti?n',NULL,1)
INSERT INTO DIA_OC VALUES('DO222','638',N'Nguy?n Van C?','5','5','500','450',N'Tây',N'M?t ti?n','NULL',2)
INSERT INTO DIA_OC VALUES('DO333','332/1',N'Nguy?n Thái H?c','9','1','100','100',N'Nam',N'H?m','NULL',1)
INSERT INTO DIA_OC VALUES('DO444','980',N'Lê H?ng Phong','4','5','450','450',N'B?c',N'M?t ti?n','NULL',2)
INSERT INTO DIA_OC VALUES('DO555','111/45',N'Truong Ð?nh','10','3','85','85',N'Ðông Nam',N'H?m','NULL',1)

INSERT INTO DICH_VU VALUES(1,N'T? bu?m qu?ng cáo 200 t?',200.000)
INSERT INTO DICH_VU VALUES(2,N'T? bu?m qu?ng cáo 100 t?',100.000)
INSERT INTO DICH_VU VALUES(3,N'Qu?ng cáo trên báo',300.000)

INSERT INTO PHIEU_DANG_KY VALUES('PDK111','5/1/2005',1,1040000,'111222333')
INSERT INTO PHIEU_DANG_KY VALUES('PDK222','10/19/2005',2,2600000,'222333444')
INSERT INTO PHIEU_DANG_KY VALUES('PDK333','9/7/2005',3,1000000,'333444555')

INSERT INTO PHIEU_THU VALUES('PT111','PDK111','5/1/2005',1,400000,NULL)
INSERT INTO PHIEU_THU VALUES('PT222','PDK222','10/19/2005',1,400000,NULL)
INSERT INTO PHIEU_THU VALUES('PT333',NULL,'12/15/2005',2,200000,NULL)
INSERT INTO PHIEU_THU VALUES('PT444',NULL,'7/5/2005',2,320000,NULL)
INSERT INTO PHIEU_THU VALUES('PT555',NULL,'11/1/2005',3,320000,NULL)
INSERT INTO PHIEU_THU VALUES('PT666','PDK333','9/7/2005',1,600000,NULL)
INSERT INTO PHIEU_THU VALUES('PT777',NULL,'11/15/2005',2,400000,NULL)

UPDATE PHIEU_THU
SET MAPTGOC='PT222' WHERE MAPT='PT333'
UPDATE PHIEU_THU
SET MAPTGOC='PT111' WHERE MAPT='PT444'
UPDATE PHIEU_THU
SET MAPTGOC='PT666' WHERE MAPT='PT777'
UPDATE PHIEU_THU
SET MAPTGOC='PT111' WHERE MAPT='PT555'
SELECT*FROM PHIEU_THU

INSERT INTO CT_PDK VALUES('PDK111','DO111',1,'5/5/2005','7/5/2005',400000)
INSERT INTO CT_PDK VALUES('PDK222','DO222',1,'11/1/2005','12/31/2005',400000)
INSERT INTO CT_PDK VALUES('PDK222','DO333',2,'11/1/2005','12/31/2005',200000)
INSERT INTO CT_PDK VALUES('PDK333','DO444',1,'9/15/2005','10/15/2005',200000)
INSERT INTO CT_PDK VALUES('PDK333','DO444',2,'9/15/2005','10/15/2005',100000)
INSERT INTO CT_PDK VALUES('PDK333','DO555',3,'9/15/2005','10/15/2005',300000)

INSERT INTO PHIEU_GIA_HAN VALUES('PGH111','PDK111','DO111',1,'7/5/2005','7/5/2005','9/5/2005')
INSERT INTO PHIEU_GIA_HAN VALUES('PGH222','PDK111','DO111',1,'11/1/2005','11/1/2005','12/31/2005')
INSERT INTO PHIEU_GIA_HAN VALUES('PGH444','PDK333','DO444',1,'11/15/2005','11/15/2005','12/15/2005')
INSERT INTO PHIEU_GIA_HAN VALUES('PGH444','PDK333','DO555',3,'11/15/2005','11/15/2005','12/15/2005')

SELECT NB.MANB,NB.HOTEN,NB.DIACHI
FROM PHIEU_DANG_KY PDK,NGUOI_BAN NB
WHERE MONTH(PDK.NGAYDK)<=10 AND PDK.MANB=NB.MANB
NOT EXISTS(SELECT*FROM DICH_VU DV
WHERE DV.TIENDV>=100000 AND DV.TIENDV<=200000
NOT EXISTS(SELECT*FROM CT_PDK CTDK
WHERE CTDK.MAPDK=PDK.MAPDK AND CTDK.MADV=DV.MADV

Cứ tiep tuc phat huy :105:

Thanks Bạn VoDuyQuang nha, chúc bạn học tốt

không có gì, không biết anh em nào đã tạo scrip của quản lý hàng hóa chưa, post lên cho anh em đi, đỡ mất công phải ngồi mày mò

create database QLSV
use QLSV

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkGIANGKHOA_CHUONGTRINH]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[GIANGKHOA] DROP CONSTRAINT fkGIANGKHOA_CHUONGTRINH
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkLOP_CHUONGTRINH]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[LOP] DROP CONSTRAINT fkLOP_CHUONGTRINH
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkGIANGKHOA_KHOA]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[GIANGKHOA] DROP CONSTRAINT fkGIANGKHOA_KHOA
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkLOP_KHOA]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[LOP] DROP CONSTRAINT fkLOP_KHOA
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkMONHOC_KHOA]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[MONHOC] DROP CONSTRAINT fkMONHOC_KHOA
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkLOP_KHOAHOC]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[LOP] DROP CONSTRAINT fkLOP_KHOAHOC
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkSinhVien_Lop]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[SINHVIEN] DROP CONSTRAINT fkSinhVien_Lop
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkGIANGKHOA_MONHOC]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[GIANGKHOA] DROP CONSTRAINT fkGIANGKHOA_MONHOC
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkKETQUA_MONHOC]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[KETQUA] DROP CONSTRAINT fkKETQUA_MONHOC
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkKETQUA_SINHVIEN]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[KETQUA] DROP CONSTRAINT fkKETQUA_SINHVIEN
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fkXEPLOAI_SINHVIEN]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[XEPLOAI] DROP CONSTRAINT fkXEPLOAI_SINHVIEN
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CHUONGTRINH]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CHUONGTRINH]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GIANGKHOA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GIANGKHOA]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KETQUA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KETQUA]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KHOA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KHOA]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KHOAHOC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KHOAHOC]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LOP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LOP]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MONHOC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MONHOC]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SINHVIEN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SINHVIEN]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XEPLOAI]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[XEPLOAI]
GO

CREATE TABLE [dbo].[CHUONGTRINH] (
[MaCT] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[TenCT] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[GIANGKHOA] (
[MaCT] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Khoa] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MaMH] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[NamHoc] [int] NULL ,
[Hocky] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Sotiet_LT] [int] NULL ,
[Sotiet_TH] [int] NULL ,
[Sotinchi] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[KETQUA] (
[MaSV] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MaMH] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Lanthi] [int] NOT NULL ,
[Diem] [float] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[KHOA] (
[MaKhoa] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[TenKhoa] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[NamThanhLap] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[KHOAHOC] (
[MaKhoahoc] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Nambatdau] [int] NULL ,
[Namketthuc] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[LOP] (
[MaLop] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Khoahoc] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Khoa] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Chuongtrinh] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[STTLop] [int]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MONHOC] (
[MaMH] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[TenMH] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Khoa] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SINHVIEN] (
[MaSV] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Hoten] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[NamSinh] [datetime] NULL ,
[Dantoc] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MaLop] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[XEPLOAI] (
[MaSV] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DiemTB] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[KetQua] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[HocLuc] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CHUONGTRINH] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[MaCT]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[GIANGKHOA] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[MaCT],
[Khoa],
[MaMH]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[KETQUA] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[MaSV],
[MaMH],
[Lanthi]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[KHOA] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[MaKhoa]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[KHOAHOC] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[MaKhoahoc]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[LOP] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[MaLop]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[MONHOC] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[MaMH]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SINHVIEN] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[MaSV]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[XEPLOAI] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[MaSV]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[GIANGKHOA] ADD
CONSTRAINT [fkGIANGKHOA_CHUONGTRINH] FOREIGN KEY
(
[MaCT]
) REFERENCES [dbo].[CHUONGTRINH] (
[MaCT]
),
CONSTRAINT [fkGIANGKHOA_KHOA] FOREIGN KEY
(
[Khoa]
) REFERENCES [dbo].[KHOA] (
[MaKhoa]
),
CONSTRAINT [fkGIANGKHOA_MONHOC] FOREIGN KEY
(
[MaMH]
) REFERENCES [dbo].[MONHOC] (
[MaMH]
)
GO

ALTER TABLE [dbo].[KETQUA] ADD
CONSTRAINT [fkKETQUA_MONHOC] FOREIGN KEY
(
[MaMH]
) REFERENCES [dbo].[MONHOC] (
[MaMH]
),
CONSTRAINT [fkKETQUA_SINHVIEN] FOREIGN KEY
(
[MaSV]
) REFERENCES [dbo].[SINHVIEN] (
[MaSV]
)
GO

ALTER TABLE [dbo].[LOP] ADD
CONSTRAINT [fkLOP_CHUONGTRINH] FOREIGN KEY
(
[Chuongtrinh]
) REFERENCES [dbo].[CHUONGTRINH] (
[MaCT]
),
CONSTRAINT [fkLOP_KHOA] FOREIGN KEY
(
[Khoa]
) REFERENCES [dbo].[KHOA] (
[MaKhoa]
),
CONSTRAINT [fkLOP_KHOAHOC] FOREIGN KEY
(
[Khoahoc]
) REFERENCES [dbo].[KHOAHOC] (
[MaKhoahoc]
)
GO

ALTER TABLE [dbo].[MONHOC] ADD
CONSTRAINT [fkMONHOC_KHOA] FOREIGN KEY
(
[Khoa]
) REFERENCES [dbo].[KHOA] (
[MaKhoa]
)
GO

ALTER TABLE [dbo].[SINHVIEN] ADD
CONSTRAINT [fkSinhVien_Lop] FOREIGN KEY
(
[MaLop]
) REFERENCES [dbo].[LOP] (
[MaLop]
)
GO

ALTER TABLE [dbo].[XEPLOAI] ADD
CONSTRAINT [fkXEPLOAI_SINHVIEN] FOREIGN KEY
(
[MaSV]
) REFERENCES [dbo].[SINHVIEN] (
[MaSV]
)
GO

insert into chuongtrinh values ('CQ',N'Chính qui')

insert into khoa values ('CNTT', N'Công nghệ thông tin',1995)
insert into khoa values ('VL', N'Vật lý',1970)

insert into khoahoc values ('K2002',2002,2006)
insert into khoahoc values ('K2003',2003,2007)
insert into khoahoc values ('K2004',2004,2008)

insert into monhoc values ('THT01',N'Toán cao cấp A1','CNTT')
insert into monhoc values ('VLT01',N'Toán cao cấp A1','VL')
insert into monhoc values ('THT02',N'Toán rời rạc','CNTT')
insert into monhoc values ('THCS01',N'Cấu trúc dữ liệu 1','CNTT')
insert into monhoc values ('THCS02',N'Hệ điều hành','CNTT')

insert into giangkhoa values ('CQ','CNTT','THT01',2003,1,60,0,5)
insert into giangkhoa values ('CQ','CNTT','THT02',2003,2,45,0,4)
insert into giangkhoa values ('CQ','CNTT','THCS01',2004,1,45,30,4)

insert into lop values ('TH2002/01' , 'K2002' ,'CNTT' ,'CQ','1')
insert into lop values ('TH2002/02' , 'K2002' ,'CNTT' ,'CQ','2')
insert into lop values ('VL2003/01' , 'K2003' ,'VL' ,'CQ','1')

insert into SinhVien values ('0212001',N'Nguyễn Vĩnh An','1984', N'Kinh','TH2002/01')
insert into SinhVien values ('0212002',N'Nguyễn Thanh Bình', '1985', N'Kinh','TH2002/01')
insert into SinhVien values ('0212003',N'Nguyễn Thanh Cường', '1984', N'Kinh','TH2002/02')
insert into SinhVien values ('0212004',N'Nguyễn Quốc Duy', '1983', N'Kinh','TH2002/02')
insert into SinhVien values ('0311001',N'Phan Tuấn Anh', '1985', N'Kinh','VL2003/01')
insert into SinhVien values ('0311002',N'Huỳnh Thanh Sang', '1984', N'Kinh','VL2003/01')

insert into KetQua values ('0212001','THT01',1,4)
insert into KetQua values ('0212001','THT01',2,7)
insert into KetQua values ('0212002','THT01',1,8)
insert into KetQua values ('0212003','THT01',1,6)
insert into KetQua values ('0212004','THT01',1,9)
insert into KetQua values ('0212001','THT02',1,8)
insert into KetQua values ('0212002','THT02',1,5.5)
insert into KetQua values ('0212003','THT02',1,4)
insert into KetQua values ('0212003','THT02',2,6)
insert into KetQua values ('0212001','THCS01',1,6.5)
insert into KetQua values ('0212002','THCS01',1,4)
insert into KetQua values ('0212003','THCS01',1,7)

Scrip trên là của Thầy cho!
Tên của các bảng nằm giữa 2 dấu "[ ]" là cơ chế tự động khi thao tác tạo CSDL bằng giao diện, MS làm vậy để hạn chế lỗi phát sinh do người dùng đặt tên các bảng có khoảng trằng.
Chúc các bạn học tốt!

cai cua thay nhin ko hieu gi het!

Cái của ku Quang nhìn hiểu liền,ku Phat post len ko hiểu gì hết á,loan lun rùi nè ku,bửa nào rãnh trả em về vi tri cũ cho e nha a Phát,hehe ^^!!!

ban An nha, khong duoc goi la "ku" nha.

hình như là chúng ta thi thì cái của thầy cho thì phải

dau co, minh lam cach khac cung duoc ma.