fork download
copy 
  1. CREATE DATABASE QLDiemSV
  2. USE QLDiemSV
  3. Go
  4.  
  5. Create table DMKHOA (
  6. MaKhoa char(2) constraint PK_Khoa primary key, 
  7. TenKhoa nVarChar(20) unique
  8. )
  9. Go
  10. Create table DMMH (
  11. MaMH char(2) constraint PK_DMMH primary key, 
  12. TenMH nVarchar(30),
  13. SoTiet Tinyint check (SoTiet IN (0,15,30,45,60,75))
  14. )
  15. Go
  16. create table DMSV (
  17. MaSV char(3) constraint PK_DMSV primary key, 
  18. HoSV nvarchar(30),
  19. TenSV Nvarchar(10), 
  20. Phai bit,
  21. NgaySinh Datetime check (Year(getdate())-Year(NgaySinh) >=17), 
  22. NoiSinh nvarchar(25), 
  23. MaKH char(2),
  24. HocBong float check (HocBong >=0),
  25. constraint  FK_DMSV_DMKHOA  foreign  key(MaKH) references  DMKHOA(MaKhoa)
  26. )
  27. Go
  28. Create table KETQUA (
  29. MaSV char (3),
  30. MaMH char (2), 
  31. LanThi Tinyint, 
  32. Diem  Decimal(4,2),
  33. constraint PK_KetQua  primary  key  (MaSV,MaMH,LanThi),
  34. constraint FK_KetQua_SinhVien foreign key(masv) references  DMSV(MaSV), 
  35. constraint FK_KetQua_DMMH foreign key (MaMH)  references DMMH(MaMH)
  36. )
  37. Go
  38.  
  39. --
  40. Thêm dữ liệu
  41. INSERT INTO DMKHOA 
  42. VALUES ('AV', N'Anh Văn'),('TH',N'Tin Học'),('TR',N'Triết'),('VL',N'Vật lý')
  43. Go
  44. INSERT INTO DMMH VALUES
  45. ('01',N'Cơ sở dữ liệu',45),('02',N'Trí tuệ nhân tạo',45),
  46. ('03',N'Lý thuyết truyền tin',45),('04',N'Đồ họa',60),
  47. ('05',N'Văn phạm',60),('06',N'Kỹ thuật lập trình',45)
  48. INSERT INTO DMSV VALUES
  49. ('A01',	N'Nguyễn Thị', N'Hải',0,'02/23/1993',N'Hà Nội','TH',130000),	
  50. ('A02',	N'Trần Văn', N'Chính',1,'12/24/1992',N'Bình Định','VL',150000),
  51. ('A03',	N'Lê Thu Bạch', N'Yến',0,'02/21/1993',N'TPHCM','TH',170000),
  52. ('A04',	N'Trần Anh', N'Tuấn',1,'12/20/1994',N'Hà Nội','AV',80000),
  53. ('B01',	N'Trần Thanh', N'Mai',0,'08/12/1993',N'Hải Phòng','TR',0),
  54. ('B02',	N'Trần Thị Thu', N'Thủy',0,'01/02/1994',N'TPHCM','AV',0)
  55. INSERT INTO KETQUA VALUES
  56. ('A01',	'01',1,3),
  57. ('A01',	'01',2,6),
  58. ('A01',	'02',2,6),
  59. ('A01',	'03',1,5),
  60. ('A02',	'01',1,4.5),
  61. ('A02',	'01',2,7),
  62. ('A02',	'03',1,10),
  63. ('A02',	'05',1,9),
  64. ('A03',	'01',1,2),
  65. ('A03',	'01',2,5),
  66. ('A03',	'03',1,2.5),
  67. ('A03',	'03',2,4),
  68. ('A04',	'05',2,10),
  69. ('B01',	'01',1,7),
  70. ('B01',	'03',1,2.5),
  71. ('B01',	'03',2,5),
  72. ('B02',	'02',1,6),
  73. ('B02',	'04',1,10)
  74. Go
  75. sp_tables
  76. sp_columns KETQUA
  77. sp_helpconstraint KETQUA
  78.  
  79.  
Success #stdin #stdout #stderr 0.01s 5324KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: near "CREATE": syntax error
Error: near line 16: no such function: Year
Error: near line 40: near "Thêm": syntax error
Error: near line 44: near "'Cơ sở dữ liệu'": syntax error
Error: near line 75: near "sp_tables": syntax error
https://ideone.com/KMpB4X
language:
SQLite (sqlite 3.27.2)
created:
8 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!