GNUMBER	LASTNAME	FIRSTNAME	HOUSENO	STREET	CITY	STATE	ZIPCODE
G-1234	Doe	John	12	Main Street	Fairfax	VA	22030
G-4567	Smith	Kelly	560	Lee Hwy	Vienna	VA	22027
G-7890	Will	Shawn	45	Chain Bridge Rd	Fairfax	VA	22029
	data type	null policy	Keys	checks needed (if any)
GNUMBER	gNumDT	not null	PK	always 6 characters and last 4 are digits [0-9]
LASTNAME	nameDT	not null
FIRSTNAME	nameDT	not null
HOUSENO	varchar(5)	not null
STREET	streetDT	not null
CITY	cityDT	not null
STATE	stateDT	not null		always 2 characters [A-Z]
ZIPCODE	zipDT	not null		always 5 digits [0-9]

Answer questions:

1) Check constraint for always 6 characters and last 4 are digits [0-9]

2) Check constraint for always 2 characters [A-Z]

3) Check constraint for always 5 digits [0-9]