DROP TABLE "tbl_Department" IF EXISTS;

CREATE TABLE "tbl_Department" 
     (
	 "Department-ID"       
	  	INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) 
	  	NOT NULL 
	  	PRIMARY KEY

	,"Department Name"     
	  	VARCHAR(100)
	  	NOT NULL

        ,"Dept-Contact-Person" 
	  	Integer

	,CONSTRAINT FKC_DCP FOREIGN KEY ("Dept-Contact-Person") 
	  	REFERENCES 
	 	"tbl_Employees" ("employee-ID")
     );