-- Table declarations for the Supplier / Parts enterprise.
CREATE TABLE EMPL 
      (Emp_ID	  NUMERIC(9) NOT NULL UNIQUE,
       Dept_ID    CHAR(6) NOT NULL,
       Emp_Name   CHAR(20),
       Hours_Reg  NUMERIC(3),
       Hours_OT   NUMERIC(3),
       Hourly_Pay DECIMAL(5,2),
       OT_Rate    DECIMAL(5,2),
       YTD	  DECIMAL(8,2)
);
CREATE TABLE DEPT
      (Dept_ID    CHAR(6) NOT NULL UNIQUE,
       Dept_Name  CHAR(20),
       Budget     DECIMAL(8,2)
);
CREATE TABLE VEHIC
      (V_ID       NUMERIC(5) NOT NULL UNIQUE,
       Emp_ID     NUMERIC(9) NOT NULL UNIQUE,
       License    CHAR(6),
       Num_Violat NUMERIC(2)
);
CREATE TABLE PROJ
      (Proj_ID	  NUMERIC(3) NOT NULL,
       Emp_ID 	  NUMERIC(9) NOT NULL UNIQUE,
       Hrs_Worked NUMERIC(3),
       Job_Desc   Char(15),
       Start_Date NUMERIC(6),
       Due_date   NUMERIC(6)
);