code downloaded from the website does not reflect what is shown in the book.

14.1 - "state varchar(2)", should be added to sql file. And the second constraint should be renamed in sql file to, "pk_roads"

Sorry for delay wasn't getting email notifications. I just updated the code on website with latest file for ch14 so should be set.