Is there a relationship between door locks being called dead bolts and door nails as in dead as a door nail?

No. A dead-bolt is a particular kind of door-locking mechanism that may be opened only from one side of the door. "Dead as a doornail" is an alliterative phrase presumedly coined by Shakespeare.