Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1512081 QUAN LY DE TAI
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
CREATE TABLE GIAOVIEN( MAGV NCHAR(10), HOTEN NVARCHAR(30), LUONG INT, PHAI NCHAR(3), NGSINH DATETIME, DIACHI NVARCHAR(50), GVQLCM NCHAR(10), MABM NCHAR(10), PRIMARY KEY(MAGV) ); CREATE TABLE KHOA( MAKHOA NCHAR(10), TENKHOA NVARCHAR(30), NAMTL INT, PHONG NCHAR(10), DIENTHOAI INT, TRUONGKHOA NCHAR(10), NGAYNHAMCHUC DATETIME, PRIMARY KEY (MAKHOA) ); CREATE TABLE BOMON( MABM NCHAR(10), TENBM NVARCHAR(30), PHONG NCHAR(10), DIENTHOAI INT, TRUONGBM NCHAR(10), MAKHOA NCHAR(10), NGAYNHAMCHUC DATETIME, PRIMARY KEY (MABM) ); CREATE TABLE GV_DT( MAGV NCHAR(10), DIENTHOAI INT, PRIMARY KEY(MAGV, DIENTHOAI) ); CREATE TABLE NGUOITHAN( MAGV NCHAR(10), TEN NVARCHAR(30), NGSINH DATETIME, PHAI NCHAR(3), PRIMARY KEY (MAGV, TEN) ); CREATE TABLE CHUDE( MACD NCHAR(10), TENCD NVARCHAR(30), PRIMARY KEY(MACD) ); CREATE TABLE DETAI( MADT NCHAR(10), TENDT NVARCHAR(50), CAPQL NVARCHAR(20), KINHPHI INT, NGAYBD DATETIME, NGAYKT DATETIME, MACD NCHAR(10), GVCNDT NCHAR(10), PRIMARY KEY(MADT) ); CREATE TABLE CONGVIEC( MADT NCHAR(10), SOTT INT, TENCV NVARCHAR(40), NGAYBD DATETIME, NGAYKT DATETIME, PRIMARY KEY(MADT, SOTT) ); CREATE TABLE THAMGIADT( MAGV NCHAR(10), MADT NCHAR(10), SOTT INT, PHUCAP INT, KETQUA NVARCHAR(20), PRIMARY KEY(MAGV, MADT, SOTT) ); ALTER TABLE BOMON ADD CONSTRAINT FK_BOMON_KHOA FOREIGN KEY (MAKHOA) REFERENCES KHOA(MAKHOA) ALTER TABLE BOMON ADD CONSTRAINT FK_BOMON_GIAOVIEN FOREIGN KEY (TRUONGBM) REFERENCES GIAOVIEN(MAGV) ALTER TABLE GV_DT ADD CONSTRAINT FK_GV_DT_GIAOVIEN FOREIGN KEY (MAGV) REFERENCES GIAOVIEN(MAGV) ALTER TABLE NGUOITHAN ADD CONSTRAINT FK_NGUOITHAN_GIAOVIEN FOREIGN KEY (MAGV) REFERENCES GIAOVIEN(MAGV) ALTER TABLE KHOA ADD CONSTRAINT FK_KHOA_GIAOVIEN FOREIGN KEY (TRUONGKHOA) REFERENCES GIAOVIEN(MAGV) ALTER TABLE THAMGIADT ADD CONSTRAINT FK_THAMGIADT_GIAOVIEN FOREIGN KEY (MAGV) REFERENCES GIAOVIEN(MAGV) ALTER TABLE THAMGIADT ADD CONSTRAINT FK_THAMGIADT_CONGVIEC FOREIGN KEY (MADT, SOTT) REFERENCES CONGVIEC(MADT, SOTT) ALTER TABLE CONGVIEC ADD CONSTRAINT FK_CONGIVEC_DETAI FOREIGN KEY (MADT) REFERENCES DETAI(MADT) ALTER TABLE DETAI ADD CONSTRAINT FK_DETAI_CHUDE FOREIGN KEY (MACD) REFERENCES CHUDE(MACD) ALTER TABLE DETAI ADD CONSTRAINT FK_DETAI_GIAOVIEN FOREIGN KEY (GVCNDT) REFERENCES GIAOVIEN(MAGV) ALTER TABLE GIAOVIEN ADD CONSTRAINT FK_GIAOVIEN_GIAOVIEN FOREIGN KEY (GVQLCM) REFERENCES GIAOVIEN(MAGV) ALTER TABLE GIAOVIEN ADD CONSTRAINT FK_GIAOVIEN_BOMON FOREIGN KEY (MABM) REFERENCES BOMON(MABM) INSERT INTO GIAOVIEN VALUES ('001', 'NGUYEN HOAI AN', '2000', 'NAM', '2/15/1973', 'TP HCM', NULL, NULL), ('002', 'TRAN TRA HUONG', '2500', 'NU', '6/20/1960', 'TP HCM', NULL, NULL), ('003', 'NGUYEN NGOC ANH','2200','NU','5/11/1975','TP HCM', '002', NULL), ('004', 'TRUONG NAM SON', '2300', 'NAM', '6/20/1959', 'BIEN HOA', NULL, NULL), ('005', 'LY HOANG HA', '2500', 'NAM', '10/23/1954', 'TP HCM', NULL, NULL) INSERT INTO KHOA VALUES ('CNTT', 'CONG NGHE THONG TIN', '1995', 'B11', '0838123456', '002', '2/20/2005'), ('HH', 'HOA HOC', '1980', 'B41', '0838456456', '001', '10/15/2001'), ('SH', 'SINH HOC', '1980', 'B31', '083845454', '004', '10/11/2000'), ('VL', 'VAT LY', '1976', 'B21', '0838223223', '005', '9/18/2003') INSERT INTO BOMON VALUES ('CNTT', 'CONG NGHE TRI THUC', 'B15', '0838126126', NULL, 'CNTT', NULL), ('HHC', 'HOA HUC CO', 'B44', '0838222222', NULL, 'HH', NULL), ('HL', 'HOA LY', 'B42', '0838878787', NULL, 'HH', NULL), ('HPT', 'HOA PHAN TICH', 'B43', '0838777777', '001', 'HH', '10/15/2007'), ('HTTT', 'HE THONG THONG TIN', 'B13', '0838125125', '002', 'CNTT', '9/20/2004') INSERT INTO NGUOITHAN VALUES ('001', 'HUNG', '1/14/1990', 'NAM'), ('001', 'THUY', '12/8/1994', 'NU'), ('003', 'HA', '9/3/1998', 'NU'), ('003', 'THU', '9/3/1998', 'NU') INSERT INTO GV_DT VALUES ('001', '0838912112'), ('001', '0903123123'), ('002', '0913454545'), ('003', '0838121212'), ('003', '0903656565') INSERT INTO CHUDE VALUES ('NCPT', 'NGHIEN CUU PHAT TRIEN'), ('QLGD', 'QUAN LY GIAO DUC'), ('UDCN', 'UNG DUNG CONG NGHE') INSERT INTO DETAI VALUES ('001', 'HTTT QUAN LY CAC TRUONG DAI HOC', 'DHQG', '20', '10/20/2007', '10/20/2008', 'QLGD', '002'), ('002', 'HTTT QUAN LY GIAO VU CHO 1 KHOA', 'TRUONG', '20', '10/12/2000', '10/12/2001', 'QLGD', '002'), ('003', 'NGHIEN CUU CHE TAO SOI NANO PLATIN', 'DHQG', '300', '5/15/2008', '5/15/2010', 'NCPT', '005'), ('004', 'TAO VAT LIEU SINH HOC BANG MANG OI NGUOI', 'NHA NUOC', '100','1/1/2007', '12/31/2009', 'NCPT', '004'), ('005', 'UNG DUNG HOA HOC XANH', 'TRUONG', '200', '10/10/2003', '12/10/2004', 'UDCN', '001') INSERT INTO CONGVIEC VALUES ('001', '1', 'KHOI TAO VA LAP KE HOACH', '10/20/2007', '12/20/2008'), ('001', '2', 'XAC DINH YEU CAU', '12/21/2008', '3/21/2008'), ('001', '3', 'PHAN TICH HE THONG', '3/22/2008', '5/22/2008'), ('001', '4', 'THIET KE HE THONG', '5/23/2008', '6/23/2008'), ('001', '5', 'CAI DAT THU NGHIEM', '6/24/2008', '10/20/2008'), ('002', '1', 'KHOI TAO VA LAP KE HOACH', '5/10/2009', '7/10/2009'), ('002', '2', 'XAC DINH YEU CAU', '7/11/2009', '10/11/2009'), ('002', '3', 'PHAN TICH HE THONG', '10/12/2009', '12/20/2009'), ('002', '4', 'THIET KE HE THONG', '12/21/2009', '3/22/2010'), ('002', '5', 'CAI DAT THU NGHIEM', '3/23/2010', '5/10/2010') INSERT INTO THAMGIADT VALUES ('001', '002', '1', '0', NULL), ('001', '002', '2', '2', NULL), ('002', '001', '4', '2', 'DAT'), ('003', '001', '1', '1', 'DAT'), ('003', '001', '2', '0', 'DAT') UPDATE GIAOVIEN SET MABM='CNTT' WHERE MAGV='001'; UPDATE GIAOVIEN SET MABM='HTTT' WHERE MAGV='002'; UPDATE GIAOVIEN SET MABM='HTTT' WHERE MAGV='003'; UPDATE GIAOVIEN SET MABM='CNTT' WHERE MAGV='004'; UPDATE GIAOVIEN SET MABM='HL' WHERE MAGV='005'; SELECT * FROM GIAOVIEN SELECT * FROM KHOA SELECT * FROM BOMON SELECT * FROM GV_DT SELECT * FROM NGUOITHAN SELECT * FROM CHUDE SELECT * FROM DETAI SELECT * FROM CONGVIEC SELECT * FROM THAMGIADT
View schema
Execution time: 0,09 sec, rows selected: 46, rows affected: 51, absolute service time: 0,25 sec
edit mode
|
history
|
discussion
MAGV
HOTEN
LUONG
PHAI
NGSINH
DIACHI
GVQLCM
MABM
1
001
NGUYEN HOAI AN
2000
NAM
15.02.1973 00:00:00
TP HCM
NULL
CNTT
2
002
TRAN TRA HUONG
2500
NU
20.06.1960 00:00:00
TP HCM
NULL
HTTT
3
003
NGUYEN NGOC ANH
2200
NU
11.05.1975 00:00:00
TP HCM
002
HTTT
4
004
TRUONG NAM SON
2300
NAM
20.06.1959 00:00:00
BIEN HOA
NULL
CNTT
5
005
LY HOANG HA
2500
NAM
23.10.1954 00:00:00
TP HCM
NULL
HL
MAKHOA
TENKHOA
NAMTL
PHONG
DIENTHOAI
TRUONGKHOA
NGAYNHAMCHUC
1
CNTT
CONG NGHE THONG TIN
1995
B11
838123456
002
20.02.2005 00:00:00
2
HH
HOA HOC
1980
B41
838456456
001
15.10.2001 00:00:00
3
SH
SINH HOC
1980
B31
83845454
004
11.10.2000 00:00:00
4
VL
VAT LY
1976
B21
838223223
005
18.09.2003 00:00:00
MABM
TENBM
PHONG
DIENTHOAI
TRUONGBM
MAKHOA
NGAYNHAMCHUC
1
CNTT
CONG NGHE TRI THUC
B15
838126126
NULL
CNTT
NULL
2
HHC
HOA HUC CO
B44
838222222
NULL
HH
NULL
3
HL
HOA LY
B42
838878787
NULL
HH
NULL
4
HPT
HOA PHAN TICH
B43
838777777
001
HH
15.10.2007 00:00:00
5
HTTT
HE THONG THONG TIN
B13
838125125
002
CNTT
20.09.2004 00:00:00
MAGV
DIENTHOAI
1
001
838912112
2
001
903123123
3
002
913454545
4
003
838121212
5
003
903656565
MAGV
TEN
NGSINH
PHAI
1
001
HUNG
14.01.1990 00:00:00
NAM
2
001
THUY
08.12.1994 00:00:00
NU
3
003
HA
03.09.1998 00:00:00
NU
4
003
THU
03.09.1998 00:00:00
NU
MACD
TENCD
1
NCPT
NGHIEN CUU PHAT TRIEN
2
QLGD
QUAN LY GIAO DUC
3
UDCN
UNG DUNG CONG NGHE
MADT
TENDT
CAPQL
KINHPHI
NGAYBD
NGAYKT
MACD
GVCNDT
1
001
HTTT QUAN LY CAC TRUONG DAI HOC
DHQG
20
20.10.2007 00:00:00
20.10.2008 00:00:00
QLGD
002
2
002
HTTT QUAN LY GIAO VU CHO 1 KHOA
TRUONG
20
12.10.2000 00:00:00
12.10.2001 00:00:00
QLGD
002
3
003
NGHIEN CUU CHE TAO SOI NANO PLATIN
DHQG
300
15.05.2008 00:00:00
15.05.2010 00:00:00
NCPT
005
4
004
TAO VAT LIEU SINH HOC BANG MANG OI NGUOI
NHA NUOC
100
01.01.2007 00:00:00
31.12.2009 00:00:00
NCPT
004
5
005
UNG DUNG HOA HOC XANH
TRUONG
200
10.10.2003 00:00:00
10.12.2004 00:00:00
UDCN
001
MADT
SOTT
TENCV
NGAYBD
NGAYKT
1
001
1
KHOI TAO VA LAP KE HOACH
20.10.2007 00:00:00
20.12.2008 00:00:00
2
001
2
XAC DINH YEU CAU
21.12.2008 00:00:00
21.03.2008 00:00:00
3
001
3
PHAN TICH HE THONG
22.03.2008 00:00:00
22.05.2008 00:00:00
4
001
4
THIET KE HE THONG
23.05.2008 00:00:00
23.06.2008 00:00:00
5
001
5
CAI DAT THU NGHIEM
24.06.2008 00:00:00
20.10.2008 00:00:00
6
002
1
KHOI TAO VA LAP KE HOACH
10.05.2009 00:00:00
10.07.2009 00:00:00
7
002
2
XAC DINH YEU CAU
11.07.2009 00:00:00
11.10.2009 00:00:00
8
002
3
PHAN TICH HE THONG
12.10.2009 00:00:00
20.12.2009 00:00:00
9
002
4
THIET KE HE THONG
21.12.2009 00:00:00
22.03.2010 00:00:00
10
002
5
CAI DAT THU NGHIEM
23.03.2010 00:00:00
10.05.2010 00:00:00
MAGV
MADT
SOTT
PHUCAP
KETQUA
1
001
002
1
0
NULL
2
001
002
2
2
NULL
3
002
001
4
2
DAT
4
003
001
1
1
DAT
5
003
001
2
0
DAT