Create the Address table as per specification below:

$\backslash$table$[[$Column Name,DataType,Constraints,DESCRIPTION$],[$HouselNo$,$NUMBER,,Unique address identifier$],[$Street$,$VARCHAR$2(30),$PRIMARY KEY,$],[$city$,$VARCHAR$2(20),$Foreign Key,Existing City present in City table$],[$zip$,$NUMBER$(6),$Should be $0,$Zip code of the city$],[$state$,$VARCHAR$2(5),,]]$