createtabledepartment(dept_idsmallintunsignednotnullauto_increment,namevarchar(20)notnull,constraintpk_departmentprimarykey(dept_id));createtablebranch(branch_idsmallintunsignednotnullauto_increment,namevarchar(20)notnull,addressvarchar(30),cityvarchar(20),statevarchar(2),zipv