QLNV.sql

--------------------------------------------------------
-- Group 08
-- 20127063 - Phan Minh Phuc
-- 20127548 - Dong My Linh
-- 20127570 - Vo Thi Kim Ngan
-- 20127671 - Pham Quoc Vuong
-- Class: 20HTTT1
--------------------------------------------------------
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
--*****************Chay voi quyen sys*****************--
--ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
--drop User GROUP08 CASCADE;
--ALTER SESSION SET "_ORACLE_SCRIPT"=False;

ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
CREATE USER GROUP08 IDENTIFIED BY GROUP08 
    DEFAULT TABLESPACE USERS
    QUOTA 10M ON USERS;

GRANT CONNECT TO GROUP08;
GRANT CREATE TABLE TO GROUP08;
GRANT CREATE SESSION TO GROUP08;
GRANT UNLIMITED TABLESPACE TO GROUP08;
GRANT CREATE PROCEDURE TO GROUP08;
--GRANT CREATE FUNCTION TO GROUP08;

ALTER SESSION SET "_ORACLE_SCRIPT"=FALSE;

--**************T?o connect moi roi chay**************--
--------------------------------------------------------
-- Create Procedure 'Drop Table If Exists'
--------------------------------------------------------
create or replace procedure drop_table_if_exists(p_table_name varchar2)
authid current_user
as
  e_does_not_exist exception;
  pragma exception_init(e_does_not_exist, -942);
begin
  execute immediate 'drop table ' || p_table_name;
exception
  when e_does_not_exist then
    null; -- could report if you want
end drop_table_if_exists;
/

exec drop_table_if_exists('QLNV_PHANCONG');
exec drop_table_if_exists('QLNV_DEAN');
ALTER TABLE QLNV_NHANVIEN
DROP CONSTRAINT QLNV_NHANVIEN_FK1;
ALTER TABLE QLNV_PHONGBAN
DROP CONSTRAINT QLNV_PHONGBAN_FK1;
exec drop_table_if_exists('QLNV_NHANVIEN');
exec drop_table_if_exists('QLNV_PHONGBAN');
--------------------------------------------------------
--  DDL for Table QLNV_NHANVIEN
--------------------------------------------------------

  CREATE TABLE "GROUP08"."QLNV_NHANVIEN" 
   (	"MANV" VARCHAR2(20 BYTE) Primary Key, 
	"TENNV" VARCHAR2(30 BYTE), 
	"PHAI" VARCHAR2(10 BYTE), 
	"NGAYSINH" DATE, 
	"DIACHI" VARCHAR2(50 BYTE), 
	"SODT" VARCHAR2(20 BYTE), 
	"LUONG" FLOAT(126), 
	"PHUCAP" FLOAT(126), 
	"VAITRO" VARCHAR2(20 BYTE), 
	"MANQL" VARCHAR2(20 BYTE), 
	"PHG" VARCHAR2(20 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Table QLNV_DEAN
--------------------------------------------------------

  CREATE TABLE "GROUP08"."QLNV_DEAN" 
   (	"MADA" VARCHAR2(20 BYTE) Primary Key, 
	"TENDA" VARCHAR2(30 BYTE), 
	"NGAYBD" DATE, 
	"PHONG" VARCHAR2(20 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Table QLNV_PHANCONG
--------------------------------------------------------

  CREATE TABLE "GROUP08"."QLNV_PHANCONG" 
   (	"MANV" VARCHAR2(20 BYTE), 
	"MADA" VARCHAR2(20 BYTE), 
	"THOIGIAN" DATE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Table QLNV_PHONGBAN
--------------------------------------------------------

  CREATE TABLE "GROUP08"."QLNV_PHONGBAN" 
   (	"MAPB" VARCHAR2(20 BYTE)Primary Key, 
	"TENPB" VARCHAR2(30 BYTE), 
	"TRPHG" VARCHAR2(20 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
/
select *from GROUP08.QLNV_PHONGBAN join GROUP08.QLNV_NHANVIEN on PHG = 'PGD' and GROUP08.QLNV_PHONGBAN.MAPB = GROUP08.QLNV_NHANVIEN.PHG

REM INSERTING into GROUP08.QLNV_NHANVIEN
SET DEFINE OFF;
-- Giam doc
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0001', 'Nguyen Van A', 'Nam',  to_date('04/03/1981','mm/dd/yyyy'), '120 Tran Hung Dao', '+84 03866 97098', 20000, 1000, 'GD', NULL, 'PGD');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0002', 'Nguyen Van B', 'Nu',  to_date('02/10/1988','mm/dd/yyyy'), '71 Nguyen Trai', '+84 03866 97095', 20000, 1500, 'GD', NULL, 'PGD');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0003', 'Nguyen Van C', 'Nam',  to_date('12/02/2000','mm/dd/yyyy'), '250 Nguyen Hue', '+84 03866 97012', 20000, 1000, 'GD', NULL, 'PGD');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0004', 'Nguyen Van D', 'Nu',  to_date('05/03/2002','mm/dd/yyyy'), '751 Tran Phu', '+84 03866 970445', 20000, 1500, 'GD', NULL, 'PGD');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0005', 'Nguyen Van E', 'Nam',  to_date('10/01/2003','mm/dd/yyyy'), '200 Luy Ban Bich', '+84 03866 97014', 20000, 1500, 'GD', NULL, 'PGD');
-- Truong Phong
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV1001', 'Le Hoai H', 'Nam',  to_date('04/03/1981','mm/dd/yyyy'), '227 Tran Hung Dao', '+84 3866 970985', 10000, 500, 'TP', NULL, 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV1002', 'Le Hoai G', 'Nu',  to_date('10/03/1980','mm/dd/yyyy'), '120 Tran Xuan Soan', '+84 3866 970986', 10000, 500, 'TP', NULL, 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV1003', 'Le Hoai F', 'Nam',  to_date('5/03/1990','mm/dd/yyyy'), '570 Huynh Tan Phat', '+84 3866 970988', 10000, 500, 'TP', NULL, 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV1004', 'Le Hoai E', 'Nu',  to_date('07/20/1988','mm/dd/yyyy'), '251 An Duong Vuong', '+84 3866 970987', 10000, 500, 'TP', NULL, 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV1005', 'Le Hoai D', 'Nam',  to_date('10/26/1990','mm/dd/yyyy'), '15 Le Duan', '+84 3866 970989', 10000, 500, 'TP', NULL, 'PB05');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV1006', 'Le Hoai C', 'Nu',  to_date('12/15/1991','mm/dd/yyyy'), '115 Nguyen Van Cu', '+84 3866 970990', 10000, 500, 'TP', NULL, 'PB06');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV1007', 'Le Hoai B', 'Nam',  to_date('06/03/1981','mm/dd/yyyy'), '120 Tran Hung Dao', '+84 3866 970991', 10000, 500, 'TP', NULL, 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV1008', 'Le Hoai A', 'Nu',  to_date('08/03/1995','mm/dd/yyyy'), '521 Ben Van Don', '+84 3866 970992', 10000, 500, 'TP', NULL, 'PB08');
-- Tai Chinh
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV2001', 'Pham A', 'Nu',  to_date('08/03/1995','mm/dd/yyyy'), '123 Ben Van Don', '+84 3866 50235', 9000, 500, 'TC', NULL, 'PTC');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV2002', 'Pham B', 'Nu',  to_date('08/13/1994','mm/dd/yyyy'), '33 Nguyen Hue', '+84 3866 50236', 9000, 500, 'TC', NULL, 'PTC');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV2003', 'Pham C', 'Nam',  to_date('06/23/1990','mm/dd/yyyy'), '21 Le Van Luong', '+84 3866 50237', 9000, 500, 'TC', NULL, 'PTC');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV2004', 'Pham D', 'Nam',  to_date('10/03/1990','mm/dd/yyyy'), '123 Tran Phu', '+84 3866 50238', 9000, 500, 'TC', NULL, 'PTC');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV2005', 'Pham E', 'Nu',  to_date('11/11/1991','mm/dd/yyyy'), '40 Le Dai Hanh', '+84 3866 50239', 9000, 500, 'TC', NULL, 'PTC');
-- Nhan Su
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV3001', 'Huynh Ly A', 'Nu',  to_date('04/03/1995','mm/dd/yyyy'), '123 Ben Van Don', '+84 3866 60235', 8000, 500, 'NS', NULL, 'PNS');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV3002', 'Huynh Ly B', 'Nu',  to_date('05/13/1994','mm/dd/yyyy'), '33 Nguyen Hue', '+84 3866 60236', 8000, 500, 'NS', NULL, 'PNS');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV3003', 'Huynh Ly C', 'Nam',  to_date('07/23/1990','mm/dd/yyyy'), '21 Le Van Luong', '+84 3866 60237', 8000, 500, 'NS', NULL, 'PNS');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV3004', 'Huynh Ly D', 'Nam',  to_date('08/03/1990','mm/dd/yyyy'), '123 Tran Phu', '+84 3866 60238', 8000, 500, 'NS', NULL, 'PNS');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV3005', 'Huynh Ly E', 'Nu',  to_date('12/11/1991','mm/dd/yyyy'), '40 Le Dai Hanh', '+84 3866 60239', 8000, 500, 'NS', NULL, 'PNS');
-- Truong De An
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV4001', 'Ho Tan A', 'Nam',  to_date('12/11/1991','mm/dd/yyyy'), '40 Le Duan', '+84 3866 70239', 5000, 500, 'TDA', NULL, 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV4002', 'Ho Tan B', 'Nu',  to_date('05/10/1991','mm/dd/yyyy'), '50 Le Loi', '+84 3866 70239', 5000, 500, 'TDA', NULL, 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV4003', 'Ho Tan C', 'Nu',  to_date('08/20/1993','mm/dd/yyyy'), '60 Le Thanh Ton', '+84 3866 70239', 5000, 500, 'TDA', NULL, 'PB03');
-- NV Quan Ly
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5001', 'Vanita Edmonds', 'Nu',  to_date('04/04/1982','mm/dd/yyyy'), '3170 Chapel Hill Ave', '+55 71 3313-6577', 9608, 566, 'NVQL', NULL, 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5002', 'Kennith Carswell', 'Nam',  to_date('02/17/1990','mm/dd/yyyy'), '28 W Sharp Hill Parkway', '+44 8451 438114', 3317, 695, 'NVQL', NULL, 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5003', 'Cary Benitez', 'Nam',  to_date('07/07/1976','mm/dd/yyyy'), '3853 W Monument Ln', '+55 15 3898-3062', 9468, 921, 'NVQL', NULL, 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5004', 'Erasmo Joe', 'Nam',  to_date('09/23/1974','mm/dd/yyyy'), '2270 NW Mountain Circle', '+44 668 279 5487', 9086, 242, 'NVQL', NULL, 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5005', 'Rodrick Paulsen', 'Nam',  to_date('01/14/1985','mm/dd/yyyy'), '32 Church Parkway', '+49 (8872) 792213', 5474, 445, 'NVQL', NULL, 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5006', 'Marco Horn', 'Nam',  to_date('07/08/1970','mm/dd/yyyy'), '3097 N Fox Hill Lane', '+32 4 266 55 40', 7442, 810, 'NVQL', NULL, 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5016', 'Tanner Butler', 'Nam',  to_date('06/08/1985','mm/dd/yyyy'), '346 Prospect Hill Rd', '+44 7180 63 6792', 6968, 832, 'NVQL', NULL, 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5007', 'Carline Mccall', 'Nu',  to_date('01/01/1970','mm/dd/yyyy'), '38 New Fox Hill Drive', '+49-3937-498253', 7209, 300, 'NVQL', NULL, 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5008', 'Alfonzo Bohn', 'Nu',  to_date('08/26/1984','mm/dd/yyyy'), '3066 SW Riverside Lane', '+971 3 763 1184', 1093, 466, 'NVQL', NULL, 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5009', 'Addie Tyner', 'Nam',  to_date('01/01/1970','mm/dd/yyyy'), '3188 NW Ski Hill Street', '+44 9351 07 0212', 9405, 736, 'NVQL', NULL, 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5010', 'Christian Abernathy', 'Nu',  to_date('04/05/1974','mm/dd/yyyy'), '87 NW Chapel Hill Pkwy', '+44 3802 29 2668', 3117, 830, 'NVQL', NULL, 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5011', 'Tory Olson', 'Nam',  to_date('11/19/2001','mm/dd/yyyy'), '969 W Ski Hill Highway', '+380 79 461-207-1', 8361, 259, 'NVQL', NULL, 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5012', 'Glynis Battle', 'Nam',  to_date('01/01/1970','mm/dd/yyyy'), '12 South Hope Parkway', '+33 7 68 91 92 53', 8509, 905, 'NVQL', NULL, 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5013', 'Jeffry Pease', 'Nam',  to_date('11/19/1986','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1769', 5992, 823, 'NVQL', NULL, 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5014', 'Jeffry Ausu', 'Nam',  to_date('11/19/1986','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1770', 5992, 823, 'NVQL', NULL, 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5015', 'John Ausu', 'Nam',  to_date('11/19/1990','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1771', 5992, 823, 'NVQL', NULL, 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5016', 'Jeeny Ausu', 'Nu',  to_date('11/19/1986','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1772', 5992, 823, 'NVQL', NULL, 'PB05');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5017', 'Jeffry Jaed', 'Nam',  to_date('11/19/1986','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1773', 5992, 823, 'NVQL', NULL, 'PB06');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5018', 'Pub Ausu', 'Nam',  to_date('11/19/1986','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1774', 5992, 823, 'NVQL', NULL, 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5019', 'Antony Suan', 'Nam',  to_date('11/19/1986','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1775', 5992, 823, 'NVQL', NULL, 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV5020', 'Robby Nus', 'Nam',  to_date('11/19/1986','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1776', 5992, 823, 'NVQL', NULL, 'PB02');

-- Nhan Vien
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV02275', 'Vanita Edmonds', 'Nam',  to_date('04/03/1981','mm/dd/yyyy'), '23-47 Highgate Road', '+49 3866 970904', 8727, 536, 'NV', 'NV5012', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0091', 'Kennith Carswell', 'Nam',  to_date('02/02/1981','mm/dd/yyyy'), '4-9 Berne Road', '+52 31 0053 1676', 6519, 590, 'NV', 'NV5012', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV03343', 'Cary Benitez', 'Nu',  to_date('01/01/1980','mm/dd/yyyy'), '9 Lexington Street', '+49 (5488) 638393', 9971, 467, 'NV', 'NV5012', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV08033', 'Kathyrn Beatty', 'Nam',  to_date('03/15/1985','mm/dd/yyyy'), '5-8 Roupell Street', '+32 1 454 03 26', 5684, 835, 'NV', 'NV5012', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV02726', 'Erasmo Joe', 'Nam',  to_date('06/10/1988','mm/dd/yyyy'), '4 A-C Churchill Avenue', '+44 4279 565045', 8906, 948, 'NV', 'NV5012', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV04344', 'Rodrick Paulsen', 'Nam',  to_date('01/14/1989','mm/dd/yyyy'), '27 A-E Magdalen Street', '+44 861 518 1638', 8496, 626, 'NV', 'NV5013', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV05761', 'Marco Horn', 'Nam',  to_date('11/22/1989','mm/dd/yyyy'), '32-38 Lewisham Way', '+44 7598 824995', 6761, 281, 'NV', 'NV5013', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV04938', 'Tanner Butler', 'Nu',  to_date('03/03/1991','mm/dd/yyyy'), '1 Chatham Street', '+1 914-126-4259', 7233, 867, 'NV', 'NV5013', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV03193', 'Carline Mccall', 'Nam',  to_date('01/02/1990','mm/dd/yyyy'), '1-8 Abbey Mews', '+44 493 124 9359', 6783, 532, 'NV', 'NV5013', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV03292', 'Cora Pacheco', 'Nam',  to_date('05/09/1990','mm/dd/yyyy'), '2-9 Fulham Road', '+32 4 447 01 37', 9367, 293, 'NV', 'NV5001', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV06745', 'Cleotilde Gorman', 'Nam',  to_date('01/01/1980','mm/dd/yyyy'), '5-8 Abbey Road', '+49 5155 994114', 8571, 830, 'NV', 'NV5001', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV06866', 'Gus Sawyer', 'Nam',  to_date('04/25/1995','mm/dd/yyyy'), '1 Vorley Road', '+380 24 121-652-3', 6430, 670, 'NV', 'NV5001', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV05512', 'Alfonzo Bohn', 'Nam',  to_date('11/23/1980','mm/dd/yyyy'), '47 Beauty Avenue', '+52 62 9245 0528', 7005, 679, 'NV', 'NV5001', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV04618', 'Addie Tyner', 'Nu',  to_date('12/22/1984','mm/dd/yyyy'), '26B Doughty Mews', '+420 400 098 642', 7125, 831, 'NV', 'NV5001', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV02628', 'Christian Abernathy', 'Nu',  to_date('06/24/1985','mm/dd/yyyy'), '2-6 Postmill Close', '+49 (2715) 131285', 9118, 343, 'NV', 'NV5001', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV09211', 'Tory Olson', 'Nam',  to_date('12/23/1998','mm/dd/yyyy'), '3 Tollgate Road', '+52 49 2460 0590', 5258, 626, 'NV', 'NV5001', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV04060', 'Amiee Pond', 'Nu',  to_date('09/06/1987','mm/dd/yyyy'), '8 Devereux Court', '+52 36 8355 4295', 9620, 839, 'NV', 'NV5001', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV05929', 'Glynis Battle', 'Nu',  to_date('01/01/1980','mm/dd/yyyy'), '11-39 Lancashire Court', '+44 503 878 0427', 5889, 339, 'NV', 'NV5001', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV02926', 'Joeann Garcia', 'Nam',  to_date('01/08/1996','mm/dd/yyyy'), '1-9 Leverton Street', '+52 42 7003 0250', 8478, 775, 'NV', 'NV5001', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV04846', 'Jeffry Pease', 'Nu',  to_date('05/10/1991','mm/dd/yyyy'), '33-59 Coombe Road', '+32 2 777 24 90', 9030, 208, 'NV', 'NV5001', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV03609', 'Nerissa Word', 'Nam',  to_date('11/26/1995','mm/dd/yyyy'), '3 A-D George Street', '+49 6222 194627', 9413, 725, 'NV', 'NV5001', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV07361', 'Freeda Brinkley', 'Nu',  to_date('11/16/1992','mm/dd/yyyy'), '9A White Church Lane', '+1 340-978-2089', 5473, 717, 'NV', 'NV5001', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV04655', 'Stevie Durham', 'Nam',  to_date('11/08/1997','mm/dd/yyyy'), '768 Battersea Bridge Road', '+44 243 789 8279', 5937, 778, 'NV', 'NV5001', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV02176', 'Joshua Villasenor', 'Nam',  to_date('01/01/1980','mm/dd/yyyy'), '8 Ritherdon Road', '+49-4125-203605', 6445, 767, 'NV', 'NV5001', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV02933', 'Federico Lujan', 'Nu',  to_date('01/01/1980','mm/dd/yyyy'), '1-7 Albemarle Street', '+971 2 282 4177', 7905, 363, 'NV', 'NV5013', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV07109', 'Emmett Musgrove', 'Nu',  to_date('11/11/1985','mm/dd/yyyy'), '3 Britten Street', '+49 (7058) 548928', 8276, 551, 'NV', 'NV5013', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV07657', 'Akiko Lester', 'Nu',  to_date('01/28/1987','mm/dd/yyyy'), '44-17 Morton Court', '+55 92 0555-4278', 9456, 536, 'NV', 'NV5013', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV02263', 'Cassi Atkinson', 'Nam',  to_date('02/05/1989','mm/dd/yyyy'), '4-6 Faulkner Mews', '+32 4 452 09 86', 7918, 886, 'NV', 'NV5014', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV04353', 'Kevin Kim', 'Nu',  to_date('02/06/1992','mm/dd/yyyy'), '5-7 Hartfield Road', '+44 9536 04 0259', 9162, 945, 'NV', 'NV5014', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV01648', 'Bennie Broussard', 'Nam',  to_date('01/01/1980','mm/dd/yyyy'), '93 A-C Englefield Close', '+971 7 007 1997', 9044, 280, 'NV', 'NV5014', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV05174', 'Tess Townsend', 'Nam',  to_date('09/30/1989','mm/dd/yyyy'), '44-18 Arlington Road', '+44 861 640 3665', 5269, 215, 'NV', 'NV5014', 'PB05');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV06661', 'Carl Switzer', 'Nam',  to_date('10/23/1980','mm/dd/yyyy'), '969 Lauriston Road', '+380 07 467-852-8', 8566, 548, 'NV', 'NV5014', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV08464', 'Alysa Harrell', 'Nu',  to_date('03/21/1980','mm/dd/yyyy'), '32-37 Addington Street', '+971 0 256 8011', 6638, 934, 'NV', 'NV5014', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV01408', 'Olga Haag', 'Nam',  to_date('09/15/1999','mm/dd/yyyy'), '3 Amyand Park Road', '+33 7 94 64 89 84', 5704, 332, 'NV', 'NV5002', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV09883', 'Dia Casteel', 'Nu',  to_date('07/12/1982','mm/dd/yyyy'), '10 Peterborough Road', '+49 (5254) 715433', 5614, 451, 'NV', 'NV5002', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV06700', 'Adam Thames', 'Nam',  to_date('01/01/1980','mm/dd/yyyy'), '3C Abercorn Crescent', '+55 90 4322-0336', 9325, 314, 'NV', 'NV5002', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV06193', 'Bridgette Conley', 'Nu',  to_date('01/24/1988','mm/dd/yyyy'), '43-38 Abbey Street', '+44 234 296 2167', 7987, 490, 'NV', 'NV5002', 'PB05');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV04061', 'Rodger Crawford', 'Nu',  to_date('09/11/1980','mm/dd/yyyy'), '11-49 Abbeville Road', '+420 175 352 517', 6858, 713, 'NV', 'NV5002', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV05540', 'Adaline Ashley', 'Nam',  to_date('07/27/1991','mm/dd/yyyy'), '3-7 Abbey Street', '+49-5354-206060', 6437, 460, 'NV', 'NV5002', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV06934', 'Cody Feliciano', 'Nam',  to_date('03/22/1984','mm/dd/yyyy'), '6 A-C Dudley Road', '+44 229 953 7572', 9387, 449, 'NV', 'NV5002', 'PB05');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV06047', 'Everette Anders', 'Nu',  to_date('10/31/1986','mm/dd/yyyy'), '143 Sutherland Square', '+49-2384-840540', 6749, 544, 'NV', 'NV5002', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV02970', 'Abby Marcum', 'Nam',  to_date('01/01/1980','mm/dd/yyyy'), '51-48 Charterhouse Square', '+44 398 016 5298', 6570, 337, 'NV', 'NV5015', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV03084', 'Marylyn Medina', 'Nu',  to_date('05/20/1996','mm/dd/yyyy'), '2-7 Glendale Close', '+971 8 588 9690', 8663, 636, 'NV', 'NV5015', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV07681', 'Tim Howe', 'Nam',  to_date('02/28/1988','mm/dd/yyyy'), '170D Newell Street', '+55 20 5475-4650', 9190, 338, 'NV', 'NV5015', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV06131', 'Toney Paradis', 'Nu',  to_date('06/05/1999','mm/dd/yyyy'), '5-8 East End Road', '+49 3918 068131', 5991, 537, 'NV', 'NV5015', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV01700', 'Hilma Bower', 'Nam',  to_date('06/13/1989','mm/dd/yyyy'), '5 Philips Close', '+33 6 33 50 26 40', 5903, 711, 'NV', 'NV5015', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV08261', 'Sanford Abbott', 'Nu',  to_date('10/10/1986','mm/dd/yyyy'), '25-17 Eastfields Avenue', '+55 82 9636-7881', 9076, 465, 'NV', 'NV5015', 'PB00');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0880', 'Minh Withers', 'Nu', to_date('01/11/1984 ','mm/dd/yyyy'), '8 A-E Broad Street', '+32 1 718 52 69', 8951, 617, 'NV', 'NV5015', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV05382', 'Eldridge Cornett', 'Nu', to_date('12/02/1986','mm/dd/yyyy'), '8 Eileen Road', '+49-0110-456163', 9675, 975, 'NV', 'NV5016', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV09696', 'Louie Freedman', 'Nam', to_date('12/02/1986','mm/dd/yyyy'), '1-7 Finsbury Square', '+49 (9506) 592184', 6280, 740, 'NV', 'NV5016', 'PB02');

INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0157', 'Vanita Edmonds', 'Nu',  to_date('04/04/1982' ,'mm/dd/yyyy'), '3170 Chapel Hill Ave', '+55 71 3313-6577', 9608, 566, 'NV', 'NV5016', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0152', 'Kennith Carswell', 'Nam',  to_date('02/17/1990','mm/dd/yyyy'), '28 W Sharp Hill Parkway', '+44 8451 438114', 3317, 695, 'NV', 'NV5003', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0142', 'Cary Benitez', 'Nam',  to_date('07/07/1976' ,'mm/dd/yyyy'), '3853 W Monument Ln', '+55 15 3898-3062', 9468, 921, 'NV', 'NV5003', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0192', 'Kathyrn Beatty', 'Nu',  to_date('05/09/1979' ,'mm/dd/yyyy'), '1514 Rose Hill Drive', '+44 2075 63 6656', 8447, 224, 'NV', 'NV5003', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0187', 'Erasmo Joe', 'Nam',  to_date('09/23/1974' ,'mm/dd/yyyy'), '2270 NW Mountain Circle', '+44 668 279 5487', 9086, 242, 'NV', 'NV5003', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0138', 'Rodrick Paulsen', 'Nam',  to_date('01/14/1985' ,'mm/dd/yyyy'), '32 Church Parkway', '+49 (8872) 792213', 5474, 445, 'NV', 'NV5003', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0134', 'Marco Horn', 'Nam',  to_date('07/08/1970' ,'mm/dd/yyyy'), '3097 N Fox Hill Lane', '+32 4 266 55 40', 7442, 810, 'NV', 'NV5003', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0156', 'Tanner Butler', 'Nam',  to_date('06/08/1985 ','mm/dd/yyyy'), '346 Prospect Hill Rd', '+44 7180 63 6792', 6968, 832, 'NV', 'NV5003', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0180', 'Carline Mccall', 'Nu',  to_date('01/01/1970','mm/dd/yyyy'), '38 New Fox Hill Drive', '+49-3937-498253', 7209, 300, 'NV', 'NV5003', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0107', 'Cleotilde Gorman', 'Nu',  to_date('05/19/1986 ','mm/dd/yyyy'), '644 NE Ski Hill Pkwy', '+1 934-187-2984', 7221, 886, 'NV', 'NV5003', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0172', 'Gus Sawyer', 'Nu',  to_date('10/05/1982 ','mm/dd/yyyy'), '3723 Monument Lane', '+971 9 643 2506', 6721, 937, 'NV', 'NV5016', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0106', 'Alfonzo Bohn', 'Nu',  to_date('08/26/1984 ','mm/dd/yyyy'), '3066 SW Riverside Lane', '+971 3 763 1184', 1093, 466, 'NV', 'NV5016', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0193', 'Addie Tyner', 'Nam',  to_date('01/01/1970 ','mm/dd/yyyy'), '3188 NW Ski Hill Street', '+44 9351 07 0212', 9405, 736, 'NV', 'NV5016', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0165', 'Christian Abernathy',  'Nu', to_date('04/05/1974 ','mm/dd/yyyy'), '87 NW Chapel Hill Pkwy', '+44 3802 29 2668', 3117, 830, 'NV', 'NV5017', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0124', 'Tory Olson', 'Nam',  to_date('11/19/2001 ','mm/dd/yyyy'), '969 W Ski Hill Highway', '+380 79 461-207-1', 8361, 259, 'NV', 'NV5017', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0147', 'Amiee Pond', 'Nu',  to_date('01/01/1970 ','mm/dd/yyyy'), '3721 Ashwood Lane', '+55 56 7531-5256', 5189, 910, 'NV', 'NV5017', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0119', 'Glynis Battle', 'Nam',  to_date('01/01/1970 ','mm/dd/yyyy'), '12 South Hope Parkway', '+33 7 68 91 92 53', 8509, 905, 'NV', 'NV5017', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0103', 'Jeffry Pease', 'Nam',  to_date('11/19/1986 ','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1769', 5992, 823, 'NV', 'NV5017', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0163', 'Nerissa Word', 'Nam',  to_date('01/13/1994 ','mm/dd/yyyy'), '908 New Ashwood Highway', '+380 91 946-754-3', 6581, 213, 'NV', 'NV5018', 'PB06');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0108', 'Freeda Brinkley', 'Nam',  to_date('11/20/1998 ','mm/dd/yyyy'), '900 NW Riddle Hill Drive', '+44 354 014 5180', 2369, 411, 'NV', 'NV5018', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0126', 'Joshua Villasenor', 'Nam',  to_date('12/12/1970 ','mm/dd/yyyy'), '1701 3rd Avenue', '+49-8255-718380', 2929, 442, 'NV', 'NV5018', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0167', 'Federico Lujan', 'Nu',  to_date('04/03/1981 ','mm/dd/yyyy'), '38 Riverview Lane', '+49-5889-286495', 8791, 887, 'NV', 'NV5018', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0121', 'Emmett Musgrove', 'Nu',  to_date('01/01/1970 ','mm/dd/yyyy'), '2641 West Brentwood Parkway', '+380 69 780-915-8', 3209, 343, 'NV', 'NV5018', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0175', 'Akiko Lester', 'Nam',  to_date('04/24/1972 ','mm/dd/yyyy'), '34 White Glenwood Blvd', '+32 6 488 29 09', 7967, 308, 'NV', 'NV5018', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0100', 'Cassi Atkinson', 'Nu',  to_date('02/02/1970 ','mm/dd/yyyy'), '3116 NE Social Ln', '+44 1380 025696', 7185, 763, 'NV', 'NV5004', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0189', 'Kevin Kim', 'Nu',  to_date('01/01/1970','mm/dd/yyyy'), '3962 Red Mount Blvd', '+420 291 477 515', 8539, 579, 'NV', 'NV5004', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0170', 'Bennie Broussard', 'Nu',  to_date('02/06/1993','mm/dd/yyyy'), '604 White Hope Blvd', '+55 99 2967-1315', 3702, 421, 'NV', 'NV5004', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0161', 'Tess Townsend', 'Nu',  to_date('05/29/1973','mm/dd/yyyy'), '212 Farmview Way', '+971 9 095 7955', 9389, 275, 'NV', 'NV5004', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0115', 'Carl Switzer', 'Nam',  to_date('10/16/1982','mm/dd/yyyy'), '2582 Ashwood Pkwy', '+49-3916-061924', 7688, 221, 'NV', 'NV5004', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0137', 'Alysa Harrell', 'Nam',  to_date('10/04/1991','mm/dd/yyyy'), '1252 West Rockwood Pkwy', '+33 9 74 02 26 19', 5197, 402, 'NV', 'NV5004', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0154', 'Dia Casteel', 'Nu',  to_date('01/01/1970','mm/dd/yyyy'), '2681 Flintwood Loop', '+49 6646 972211', 5042, 769, 'NV', 'NV5004', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0158', 'Adam Thames', 'Nam',  to_date('01/01/1970','mm/dd/yyyy'), '2448 Riverside Parkway', '+33 7 15 04 35 17', 1506, 247, 'NV', 'NV5004', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0144', 'Bridgette Conley', 'Nam',  to_date('11/18/1974','mm/dd/yyyy'), '1195 Prospect Hill Highway', '+49 2687 153843', 9143, 710, 'NV', 'NV5004', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0199', 'Rodger Crawford', 'Nam',  to_date('11/21/1994','mm/dd/yyyy'), '415 Riverside Ln', '+420 057 687 096', 7465, 414, 'NV', 'NV5004', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0130', 'Adaline Ashley', 'Nu',  to_date('05/17/1988','mm/dd/yyyy'), '730 Market Parkway', '+49 0580 300768', 5647, 647, 'NV', 'NV5005', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0125', 'Cody Feliciano', 'Nu',  to_date('04/28/1978 ','mm/dd/yyyy'), '796 Red Hunting Hill Road', '+52 01 8841 6338', 5315, 756, 'NV', 'NV5005', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0153', 'Everette Anders', 'Nam',  to_date('01/01/1970','mm/dd/yyyy'), '63 NW Edgewood Hwy', '+380 50 556-120-7', 6030, 938, 'NV', 'NV5005', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0122', 'Tim Howe', 'Nam',  to_date('04/07/1985','mm/dd/yyyy'), '513 Prospect Hill Ave', '+55 60 9753-6040', 1439, 494, 'NV', 'NV5005', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0181', 'Hilma Bower', 'Nam',  to_date('06/05/1985','mm/dd/yyyy'), '1518 3rd Parkway', '+55 93 3341-8420', 2045, 538, 'NV', 'NV5005', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0148', 'Sanford Abbott', 'Nu',  to_date('08/27/1985','mm/dd/yyyy'), '2541 Mountain Cir', '+32 2 398 65 12', 1457, 869, 'NV', 'NV5019', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0196', 'Louie Freedman', 'Nu',  to_date('12/18/1999','mm/dd/yyyy'), '1193 Glenwood Rd', '+44 5189 295975', 6787, 542, 'NV', 'NV5005', 'PB02');

INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0584', 'Vanita Edmonds', 'Nu', to_date('04/04/1982','mm/dd/yyyy'), '3170 Chapel Hill Ave', '+55 71 3313-6577', 9608, 566, 'NV', 'NV5006', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0299', 'Kennith Carswell', 'Nam', to_date('02/17/1990' ,'mm/dd/yyyy'), '28 W Sharp Hill Parkway', '+44 8451 438114', 3317, 695, 'NV', 'NV5006', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0216', 'Cary Benitez', 'Nam', to_date('07/07/1976','mm/dd/yyyy'), '3853 W Monument Ln', '+55 15 3898-3062', 9468, 921, 'NV', 'NV5006', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0456', 'Kathyrn Beatty', 'Nu', to_date('05/09/1979','mm/dd/yyyy'), '1514 Rose Hill Drive', '+44 2075 63 6656', 8447, 224, 'NV', 'NV5006', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0483', 'Erasmo Joe', 'Nam', to_date('09/23/1974','mm/dd/yyyy'), '2270 NW Mountain Circle', '+44 668 279 5487', 9086, 242, 'NV', 'NV5006', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0434', 'Rodrick Paulsen', 'Nam', to_date('01/14/1985','mm/dd/yyyy'), '32 Church Parkway', '+49 (8872) 792213', 5474, 445, 'NV', 'NV5006', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0526', 'Marco Horn', 'Nam', to_date('07/08/1970' ,'mm/dd/yyyy'), '3097 N Fox Hill Lane', '+32 4 266 55 40', 7442, 810, 'NV', 'NV5006', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0567', 'Tanner Butler', 'Nam', to_date('06/08/1985','mm/dd/yyyy'), '346 Prospect Hill Rd', '+44 7180 63 6792', 6968, 832, 'NV', 'NV5006', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0235', 'Carline Mccall', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '38 New Fox Hill Drive', '+49-3937-498253', 7209, 300, 'NV', 'NV5019', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0372', 'Cora Pacheco', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '1770 Fox Hill Ct', '+1 712-037-2568', 8573, 359, 'NV', 'NV5006', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0253', 'Cleotilde Gorman', 'Nu', to_date('05/19/1986','mm/dd/yyyy'), '644 NE Ski Hill Pkwy', '+1 934-187-2984', 7221, 886, 'NV', 'NV5006', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0274', 'Gus Sawyer', 'Nu', to_date('10/05/1982','mm/dd/yyyy'), '3723 Monument Lane', '+971 9 643 2506', 6721, 937, 'NV', 'NV5006', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0338', 'Alfonzo Bohn', 'Nu', to_date('08/26/1984 ','mm/dd/yyyy'), '3066 SW Riverside Lane', '+971 3 763 1184', 1093, 466, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0530', 'Addie Tyner', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '3188 NW Ski Hill Street', '+44 9351 07 0212', 9405, 736, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0232', 'Christian Abernathy', 'Nu', to_date('04/05/1974','mm/dd/yyyy'), '87 NW Chapel Hill Pkwy', '+44 3802 29 2668', 3117, 830, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0257', 'Tory Olson', 'Nam', to_date('11/19/2001','mm/dd/yyyy'), '969 W Ski Hill Highway', '+380 79 461-207-1', 8361, 259, 'NV', 'NV5006', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0220', 'Amiee Pond', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '3721 Ashwood Lane', '+55 56 7531-5256', 5189, 910, 'NV', 'NV5006', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0278', 'Glynis Battle', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '12 South Hope Parkway', '+33 7 68 91 92 53', 8509, 905, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0414', 'Joeann Garcia', 'Nu', to_date('05/20/1979','mm/dd/yyyy'), '714 White Fox Hill Court', '+55 21 0407-2936', 3020, 446, 'NV', 'NV5019', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0251', 'Jeffry Pease', 'Nam', to_date('11/19/1986','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1769', 5992, 823, 'NV', 'NV5006', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0259', 'Nerissa Word', 'Nam', to_date('01/13/1994' ,'mm/dd/yyyy'), '908 New Ashwood Highway', '+380 91 946-754-3', 6581, 213, 'NV', 'NV5006', 'PB06');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0589', 'Freeda Brinkley', 'Nam', to_date('11/20/1998','mm/dd/yyyy'), '900 NW Riddle Hill Drive', '+44 354 014 5180', 2369, 411, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0375', 'Stevie Durham', 'Nu', to_date('03/26/1982','mm/dd/yyyy'), '244 Cedar Tree Dr', '+49 (0678) 866746', 7715, 202, 'NV', 'NV5006', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0507', 'Joshua Villasenor', 'Nam', to_date('12/12/1970','mm/dd/yyyy'), '1701 3rd Avenue', '+49-8255-718380', 2929, 442, 'NV', 'NV5006', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0318', 'Federico Lujan', 'Nu', to_date('04/03/1981','mm/dd/yyyy'), '38 Riverview Lane', '+49-5889-286495', 8791, 887, 'NV', 'NV5006', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0579', 'Emmett Musgrove', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '2641 West Brentwood Parkway', '+380 69 780-915-8', 3209, 343, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0573', 'Cassi Atkinson', 'Nu', to_date('02/02/1970','mm/dd/yyyy'), '3116 NE Social Ln', '+44 1380 025696', 7185, 763, 'NV', 'NV5006', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0421', 'Kevin Kim', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '3962 Red Mount Blvd', '+420 291 477 515', 8539, 579, 'NV', 'NV5020', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0354', 'Tess Townsend', 'Nu', to_date('05/29/1973','mm/dd/yyyy'), '212 Farmview Way', '+971 9 095 7955', 9389, 275, 'NV', 'NV5020', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0239', 'Carl Switzer', 'Nam', to_date('10/16/1982','mm/dd/yyyy'), '2582 Ashwood Pkwy', '+49-3916-061924', 7688, 221, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0218', 'Alysa Harrell', 'Nam', to_date('10/04/1991','mm/dd/yyyy'), '1252 West Rockwood Pkwy', '+33 9 74 02 26 19', 5197, 402, 'NV', 'NV50189', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0437', 'Olga Haag', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '26 2nd Avenue', '+44 5296 000224', 9297, 462, 'NV', 'NV5006', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0313', 'Dia Casteel', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '2681 Flintwood Loop', '+49 6646 972211', 5042, 769, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0596', 'Adam Thames', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '2448 Riverside Parkway', '+33 7 15 04 35 17', 1506, 247, 'NV', 'NV5006', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0207', 'Bridgette Conley', 'Nam', to_date('11/18/1974','mm/dd/yyyy'), '1195 Prospect Hill Highway', '+49 2687 153843', 9143, 710, 'NV', 'NV5006', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0307', 'Rodger Crawford', 'Nam', to_date('11/21/1994','mm/dd/yyyy'), '415 Riverside Ln', '+420 057 687 096', 7465, 414, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0505', 'Adaline Ashley', 'Nu', to_date('05/17/1988','mm/dd/yyyy'), '730 Market Parkway', '+49 0580 300768', 5647, 647, 'NV', 'NV5006', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0458', 'Cody Feliciano', 'Nu', to_date('04/28/1978','mm/dd/yyyy'), '796 Red Hunting Hill Road', '+52 01 8841 6338', 5315, 756, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0357', 'Everette Anders', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '63 NW Edgewood Hwy', '+380 50 556-120-7', 6030, 938, 'NV', 'NV5006', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0406', 'Abby Marcum', 'Nam', to_date('02/13/1999','mm/dd/yyyy'), '3979 Hidden Market Rd', '+49 2820 252433', 2706, 366, 'NV', 'NV5006', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0268', 'Marylyn Medina', 'Nu', to_date('09/11/1973','mm/dd/yyyy'), '2183 S Bayview Court', '+55 69 0296-1908', 1432, 492, 'NV', 'NV5006', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0322', 'Hilma Bower', 'Nam', to_date('06/05/1985','mm/dd/yyyy'), '1518 3rd Parkway', '+55 93 3341-8420', 2045, 538, 'NV', 'NV5006', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0267', 'Sanford Abbott', 'Nu', to_date('08/27/1985','mm/dd/yyyy'), '2541 Mountain Cir', '+32 2 398 65 12', 1457, 869, 'NV', 'NV5006', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0561', 'Minh Withers', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '252 Deepwood Blvd', '+49-1614-679735', 9079, 667, 'NV', 'NV5006', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0236', 'Eldridge Cornett', 'Nu', to_date('01/05/1985','mm/dd/yyyy'), '2788 Riverview Avenue', '+420 991 766 088', 3538, 792, 'NV', 'NV5006', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0554', 'Louie Freedman', 'Nu', to_date('12/18/1999','mm/dd/yyyy'), '1193 Glenwood Rd', '+44 5189 295975', 6787, 542, 'NV', 'NV5007', 'PB02');

INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0784', 'Vanita Edmonds', 'Nu', to_date('04/04/1982','mm/dd/yyyy'), '3170 Chapel Hill Ave', '+55 71 3313-6577', 9608, 566, 'NV', 'NV5007', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0899', 'Kennith Carswell', 'Nam', to_date('02/17/1990','mm/dd/yyyy'), '28 W Sharp Hill Parkway', '+44 8451 438114', 3317, 695, 'NV', 'NV5007', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0616', 'Cary Benitez', 'Nam', to_date('07/07/1976','mm/dd/yyyy'), '3853 W Monument Ln', '+55 15 3898-3062', 9468, 921, 'NV', 'NV5007', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0856', 'Kathyrn Beatty', 'Nu', to_date('05/09/1979','mm/dd/yyyy'), '1514 Rose Hill Drive', '+44 2075 63 6656', 8447, 224, 'NV', 'NV5020', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0883', 'Erasmo Joe', 'Nam', to_date('09/23/1974','mm/dd/yyyy'), '2270 NW Mountain Circle', '+44 668 279 5487', 9086, 242, 'NV', 'NV5020', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0734', 'Rodrick Paulsen', 'Nam', to_date('01/14/1985','mm/dd/yyyy'), '32 Church Parkway', '+49 (8872) 792213', 5474, 445, 'NV', 'NV5020', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0826', 'Marco Horn', 'Nam', to_date('07/08/1970','mm/dd/yyyy'), '3097 N Fox Hill Lane', '+32 4 266 55 40', 7442, 810, 'NV', 'NV5007', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0867', 'Tanner Butler', 'Nam', to_date('06/08/1985','mm/dd/yyyy'), '346 Prospect Hill Rd', '+44 7180 63 6792', 6968, 832, 'NV', 'NV5007', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0835', 'Carline Mccall', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '38 New Fox Hill Drive', '+49-3937-498253', 7209, 300, 'NV', 'NV5020', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0872', 'Cora Pacheco', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '1770 Fox Hill Ct', '+1 712-037-2568', 8573, 359, 'NV', 'NV5007', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0753', 'Cleotilde Gorman', 'Nu', to_date('05/19/1986','mm/dd/yyyy'), '644 NE Ski Hill Pkwy', '+1 934-187-2984', 7221, 886, 'NV', 'NV5007', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0774', 'Gus Sawyer', 'Nu', to_date('10/05/1982','mm/dd/yyyy'), '3723 Monument Lane', '+971 9 643 2506', 6721, 937, 'NV', 'NV5007', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0638', 'Alfonzo Bohn', 'Nu', to_date('08/26/1984','mm/dd/yyyy'), '3066 SW Riverside Lane', '+971 3 763 1184', 1093, 466, 'NV', 'NV5008', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0730', 'Addie Tyner', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '3188 NW Ski Hill Street', '+44 9351 07 0212', 9405, 736, 'NV', 'NV5008', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0732', 'Christian Abernathy', 'Nu', to_date('04/05/1974','mm/dd/yyyy'), '87 NW Chapel Hill Pkwy', '+44 3802 29 2668', 3117, 830, 'NV', 'NV5008', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0757', 'Tory Olson', 'Nam', to_date('11/19/2001','mm/dd/yyyy'), '969 W Ski Hill Highway', '+380 79 461-207-1', 8361, 259, 'NV', 'NV5008', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0620', 'Amiee Pond', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '3721 Ashwood Lane', '+55 56 7531-5256', 5189, 910, 'NV', 'NV5008', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0878', 'Glynis Battle', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '12 South Hope Parkway', '+33 7 68 91 92 53', 8509, 905, 'NV', 'NV5008', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0614', 'Joeann Garcia', 'Nu', to_date('05/20/1979','mm/dd/yyyy'), '714 White Fox Hill Court', '+55 21 0407-2936', 3020, 446, 'NV', 'NV5008', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0651', 'Jeffry Pease', 'Nam', to_date('11/19/1986','mm/dd/yyyy'), '254 W Fox Hill Loop', '+44 838 092 1769', 5992, 823, 'NV', 'NV5008', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0659', 'Nerissa Word', 'Nam', to_date('01/13/1994','mm/dd/yyyy'), '908 New Ashwood Highway', '+380 91 946-754-3', 6581, 213, 'NV', 'NV5008', 'PB06');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0789', 'Freeda Brinkley', 'Nam', to_date('11/20/1998','mm/dd/yyyy'), '900 NW Riddle Hill Drive', '+44 354 014 5180', 2369, 411, 'NV', 'NV5008', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0775', 'Stevie Durham', 'Nu', to_date('03/26/1982','mm/dd/yyyy'), '244 Cedar Tree Dr', '+49 (0678) 866746', 7715, 202, 'NV', 'NV5009', 'PB02');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0707', 'Joshua Villasenor', 'Nam', to_date('12/12/1970','mm/dd/yyyy'), '1701 3rd Avenue', '+49-8255-718380', 2929, 442, 'NV', 'NV5009', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0818', 'Federico Lujan', 'Nu', to_date('04/03/1981','mm/dd/yyyy'), '38 Riverview Lane', '+49-5889-286495', 8791, 887, 'NV', 'NV5009', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0679', 'Emmett Musgrove', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '2641 West Brentwood Parkway', '+380 69 780-915-8', 3209, 343, 'NV', 'NV5009', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0873', 'Cassi Atkinson', 'Nu', to_date('02/02/1970','mm/dd/yyyy'), '3116 NE Social Ln', '+44 1380 025696', 7185, 763, 'NV', 'NV5009', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0621', 'Kevin Kim', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '3962 Red Mount Blvd', '+420 291 477 515', 8539, 579, 'NV', 'NV5009', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0772', 'Bennie Broussard', 'Nu', to_date('02/06/1993','mm/dd/yyyy'), '604 White Hope Blvd', '+55 99 2967-1315', 3702, 421, 'NV', 'NV5009', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0754', 'Tess Townsend', 'Nu', to_date('05/29/1973','mm/dd/yyyy'), '212 Farmview Way', '+971 9 095 7955', 9389, 275, 'NV', 'NV5009', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0739', 'Carl Switzer', 'Nam', to_date('10/16/1982','mm/dd/yyyy'), '2582 Ashwood Pkwy', '+49-3916-061924', 7688, 221, 'NV', 'NV5010', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0837', 'Olga Haag', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '26 2nd Avenue', '+44 5296 000224', 9297, 462, 'NV', 'NV5010', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0713', 'Dia Casteel', 'Nu', to_date('01/01/1970','mm/dd/yyyy'), '2681 Flintwood Loop', '+49 6646 972211', 5042, 769, 'NV', 'NV5010', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0896', 'Adam Thames', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '2448 Riverside Parkway', '+33 7 15 04 35 17', 1506, 247, 'NV', 'NV5010', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0807', 'Rodger Crawford', 'Nam', to_date('11/21/1994','mm/dd/yyyy'), '415 Riverside Ln', '+420 057 687 096', 7465, 414, 'NV', 'NV5010', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0805', 'Adaline Ashley', 'Nu', to_date('05/17/1988','mm/dd/yyyy'), '730 Market Parkway', '+49 0580 300768', 5647, 647, 'NV', 'NV5010', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0658', 'Cody Feliciano', 'Nu', to_date('04/28/1978','mm/dd/yyyy'), '796 Red Hunting Hill Road', '+52 01 8841 6338', 5315, 756, 'NV', 'NV5010', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0857', 'Everette Anders', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '63 NW Edgewood Hwy', '+380 50 556-120-7', 6030, 938, 'NV', 'NV5010', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0706', 'Abby Marcum', 'Nam', to_date('02/13/1999','mm/dd/yyyy'), '3979 Hidden Market Rd', '+49 2820 252433', 2706, 366, 'NV', 'NV5010', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0768', 'Marylyn Medina', 'Nu', to_date('09/11/1973','mm/dd/yyyy'), '2183 S Bayview Court', '+55 69 0296-1908', 1432, 492, 'NV', 'NV5010', 'PB03');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0632', 'Tim Howe', 'Nam', to_date('04/07/1985','mm/dd/yyyy'), '513 Prospect Hill Ave', '+55 60 9753-6040', 1439, 494, 'NV', 'NV5010', 'PB04');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0813', 'Toney Paradis', 'Nam', to_date('07/09/1972','mm/dd/yyyy'), '60 NW Rushwood Highway', '+49 2802 003426', 2478, 585, 'NV', 'NV5011', 'PB07');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0622', 'Hilma Bower', 'Nam', to_date('06/05/1985','mm/dd/yyyy'), '1518 3rd Parkway', '+55 93 3341-8420', 2045, 538, 'NV', 'NV5011', 'PB09');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0767', 'Sanford Abbott', 'Nu', to_date('08/27/1985','mm/dd/yyyy'), '2541 Mountain Cir', '+32 2 398 65 12', 1457, 869, 'NV', 'NV5011', 'PB08');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0661', 'Minh Withers', 'Nam', to_date('01/01/1970','mm/dd/yyyy'), '252 Deepwood Blvd', '+49-1614-679735', 9079, 667, 'NV', 'NV5011', 'PB01');
INSERT INTO GROUP08.QLNV_NHANVIEN(MANV, TENNV, PHAI, NGAYSINH, DIACHI, SODT, LUONG, PHUCAP, VAITRO, MANQL, PHG) VALUES
('NV0736', 'Eldridge Cornett', 'Nu', to_date('01/05/1985','mm/dd/yyyy'), '2788 Riverview Avenue', '+420 991 766 088', 3538, 792, 'NV', 'NV5011', 'PB01');


REM INSERTING into GROUP08.QLNV_DEAN
SET DEFINE OFF;
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA01', 'De An A', to_date( '01/01/2022','mm/dd/yyyy'), 'PB09');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA02', 'De An N',  to_date('03/05/2022','mm/dd/yyyy'), 'PB02');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA03', 'De An K',  to_date('12/22/2022','mm/dd/yyyy'), 'PB06');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA04', 'De An D',  to_date('11/29/2022','mm/dd/yyyy'), 'PB04');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA05', 'De An M',  to_date('02/16/2023','mm/dd/yyyy'), 'PB03');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA06', 'De An O',  to_date('03/14/2023','mm/dd/yyyy'), 'PB08');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA07', 'De An X',  to_date('04/03/2023','mm/dd/yyyy'), 'PB03');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA08', 'De An F',  to_date('01/11/2023','mm/dd/yyyy'), 'PB01');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA09', 'De An R',  to_date('01/01/2022','mm/dd/yyyy'), 'PB09');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA10', 'De An G',  to_date('08/08/2022','mm/dd/yyyy'), 'PB03');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA11', 'De An Y',  to_date('02/12/2023','mm/dd/yyyy'), 'PB02');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA12', 'De An J',  to_date('01/01/2022','mm/dd/yyyy'), 'PB03');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA13', 'De An L',  to_date('09/17/2022','mm/dd/yyyy'), 'PB02');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA14', 'De An P',  to_date('01/01/2022','mm/dd/yyyy'), 'PB04');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA15', 'De An E',  to_date('02/19/2022','mm/dd/yyyy'), 'PB06');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA16', 'De An Q',  to_date('11/24/2022','mm/dd/yyyy'), 'PB09');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA17', 'De An T',  to_date('04/25/2022','mm/dd/yyyy'), 'PB01');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA18', 'De An B',  to_date('01/01/2022','mm/dd/yyyy'), 'PB01');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA19', 'De An V',  to_date('04/20/2022','mm/dd/yyyy'), 'PB08');
INSERT INTO GROUP08.QLNV_DEAN(MADA, TENDA, NGAYBD, PHONG) VALUES
('DA20', 'De An S',  to_date('01/01/2022','mm/dd/yyyy'), 'PB08');

REM INSERTING into GROUP08.QLNV_PHANCONG
SET DEFINE OFF;
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0661', 'DA15', to_date('02/06/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0736', 'DA15', to_date('01/04/2023','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0622', 'DA13', to_date('05/28/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0706', 'DA09', to_date('01/03/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0713', 'DA15', to_date('10/12/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0739', 'DA06', to_date('04/18/2023','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0873', 'DA15', to_date('01/16/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0784', 'DA18', to_date('09/05/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0899', 'DA07', to_date('05/04/2023','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0856', 'DA09', to_date('07/15/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0196', 'DA11', to_date('04/12/2023 ','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0216', 'DA19', to_date('07/22/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV06131', 'DA09', to_date('03/25/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0872', 'DA08', to_date('04/09/2023','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0313', 'DA08', to_date('06/08/2022 ','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0163', 'DA12', to_date('01/17/2023','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0115', 'DA15', to_date('05/16/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0818', 'DA13', to_date('09/21/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0883', 'DA01', to_date('01/09/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0239', 'DA06', to_date('06/17/2022','mm/dd/yyyy'));
INSERT INTO GROUP08.QLNV_PHANCONG(MANV, MADA, THOIGIAN) VALUES
('NV0835', 'DA18', to_date('11/10/2022','mm/dd/yyyy'));

REM INSERTING into GROUP08.QLNV_PHONGBAN
SET DEFINE OFF;
Insert into GROUP08.QLNV_PHONGBAN (MAPB,TENPB,TRPHG) VALUES 
('PGD','Ban giam doc','NV0001');
Insert into GROUP08.QLNV_PHONGBAN (MAPB,TENPB,TRPHG) VALUES 
('PTC','Tai Chinh','NV2001');
Insert into GROUP08.QLNV_PHONGBAN (MAPB,TENPB,TRPHG) VALUES 
('PNS','Nhan Su','NV3001');
INSERT INTO GROUP08.QLNV_PHONGBAN(MAPB, TENPB, TRPHG) VALUES
('PB01', 'Phong 1', 'NV1001');
INSERT INTO GROUP08.QLNV_PHONGBAN(MAPB, TENPB, TRPHG) VALUES
('PB02', 'Phong 2', 'NV1002');
INSERT INTO GROUP08.QLNV_PHONGBAN(MAPB, TENPB, TRPHG) VALUES
('PB03', 'Phong 3', 'NV1003');
INSERT INTO GROUP08.QLNV_PHONGBAN(MAPB, TENPB, TRPHG) VALUES
('PB04', 'Phong 4', 'NV1004');
INSERT INTO GROUP08.QLNV_PHONGBAN(MAPB, TENPB, TRPHG) VALUES
('PB05', 'Phong 5', 'NV1005');
INSERT INTO GROUP08.QLNV_PHONGBAN(MAPB, TENPB, TRPHG) VALUES
('PB06', 'Phong 6', 'NV1006');
INSERT INTO GROUP08.QLNV_PHONGBAN(MAPB, TENPB, TRPHG) VALUES
('PB07', 'Phong 7', 'NV1007');
INSERT INTO GROUP08.QLNV_PHONGBAN(MAPB, TENPB, TRPHG) VALUES
('PB08', 'Phong 8', 'NV1008');

--------------------------------------------------------
--  Ref Constraints for Table QLNV_PHANCONG
--------------------------------------------------------

  ALTER TABLE "GROUP08"."QLNV_PHANCONG" ADD CONSTRAINT "QLNV_PHANCONG_FK1" FOREIGN KEY ("MADA")
	  REFERENCES "GROUP08"."QLNV_DEAN" ("MADA") ENABLE;
  ALTER TABLE "GROUP08"."QLNV_PHANCONG" ADD CONSTRAINT "QLNV_PHANCONG_FK2" FOREIGN KEY ("MANV")
	  REFERENCES "GROUP08"."QLNV_NHANVIEN" ("MANV") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table QLNV_PHONGBAN
--------------------------------------------------------

  ALTER TABLE "GROUP08"."QLNV_PHONGBAN" ADD CONSTRAINT "QLNV_PHONGBAN_FK1" FOREIGN KEY ("TRPHG")
	  REFERENCES "GROUP08"."QLNV_NHANVIEN" ("MANV") ENABLE;