//
// To make the Group-ID field on the employees table NOT NULL
// We need to 
// 1. Delete the Group-ID Foriegn Key constraint
// 2. Update the Group-ID field to be NOT NULL
// 3. Add back our Group-ID Foriegn Key constraint
//



ALTER TABLE "tbl_Employees" DROP CONSTRAINT "FK_GROUP-ID"
;


ALTER TABLE "tbl_Employees" ALTER COLUMN "Group-ID" Integer Default 0 NOT NULL
;


ALTER TABLE "tbl_Employees" 
             ADD CONSTRAINT "FK_GROUP-ID" 
                 FOREIGN KEY               ("Group-ID")
                 REFERENCES  "tbl_Group"   ("Group-ID")