Create_Database.sql

CREATE TABLE USERS (
  ID INT IDENTITY (1,1) PRIMARY KEY NOT NULL ,
  USERNAME VARCHAR(50) NOT NULL ,
  PASSWORD VARCHAR(50) NOT NULL
);

INSERT INTO USERS(USERNAME, PASSWORD)
    VALUES
      ('haipb', 'haipb'),
      ('kietpp', 'kietpp')

CREATE TABLE EMPLOYEES (
  ID INT IDENTITY (1,1) PRIMARY KEY NOT NULL ,
  FULLNAME NVARCHAR(50) NOT NULL ,
  ADDRESS NVARCHAR(50) NOT NULL ,
  EMAIL VARCHAR(50) NOT NULL ,
  PHONE VARCHAR(11) NOT NULL,
  SALARY MONEY NOT NULL
);

INSERT INTO EMPLOYEES(FULLNAME, ADDRESS, EMAIL, PHONE, SALARY)
    VALUES
      (N'Phan Bá Hải', 'TP.HCM', 'haipb@gmail.com', '0983748372', '7000000'),
      (N'Phan Phú Kiệt', 'TP.HCM', 'kietpp@gmail.com', '0986758493', '7000000'),
      (N'Trần Anh Kiệt', 'Bình Dương', 'kietta@gmail.com', '0968746352', '6500000'),
      (N'Trương Huy', 'Long An', 'huyt@gmail.com', '0973748574', '6500000'),
      (N'Phùng Văn Na Rích', 'Tây Ninh', 'richpvn@gmail.com', '0933847584', '6500000')