Database

CREATE DATABASE dbPayrollComputation

USE dbPayrollComputation

CREATE TABLE tblComputation
(
    EmployeeName    VARCHAR(50),
    EmployeeID  VARCHAR(50),
    HourlySalary    VARCHAR(50),
    StartDate datetime  NOT NULL,
    EndDate datetime    NOT NULL,
    RegularHours    VARCHAR(50),
    TotalHours  VARCHAR(50),
    OverTime    VARCHAR(50),
    SpecialHoliday  VARCHAR(50),
    LegalHoliday    VARCHAR(50),
    SSS     VARCHAR(50),
    PhilHealth  VARCHAR(50),
    PagIbig     VARCHAR(50),
    Tardiness   VARCHAR(50)
)

GO

INSERT INTO tblComputation(EmployeeName, EmployeeID, HourlySalary,
    StartDate, EndDate, RegularHours, TotalHours, OverTime, SpecialHoliday,
    LegalHoliday,SSS,PhilHealth, PagIbig, Tardiness)
VALUES('Lianessa Saragena', '2013', '43', '2015/02/02','2015/02/17',
    '8', '96', '0', '0', '0', '40', '50', '30', '0');
GO

INSERT INTO tblComputation(EmployeeName, EmployeeID, HourlySalary,
    StartDate, EndDate, RegularHours, TotalHours, OverTime, SpecialHoliday,
    LegalHoliday,SSS,PhilHealth, PagIbig, Tardiness)
VALUES('Dominic Velez', '1011', '43', '2015/02/02','2015/02/17',
    '8', '88', '0', '0', '0', '40', '50', '30', '344');
GO

INSERT INTO tblComputation(EmployeeName, EmployeeID, HourlySalary,
    StartDate, EndDate, RegularHours, TotalHours, OverTime, SpecialHoliday,
    LegalHoliday,SSS,PhilHealth, PagIbig, Tardiness)
VALUES('Meliodas Saints', '1532', '43', '2015/02/04','2015/02/19',
    '8', '96', '0', '0', '0', '40', '50', '30', '');