Hi TonyC, 1. I do not know if there is an equivalent relationship between Datbase design and Class design. However database designwise, I see 3 tables - see point 2 - Classwise, I see we have a 'Composite' pattern for your classes. I see 3 classes - see point 3 - 2. Database design

--Person table
id (personid)
firstname
middle name
lastname
stateid   (Referential Integrity with State table)




--State table
stateid
statename
stateshortname
countryid (Referential Integrity with Country table)


--Country table
countryid
country
countryShortname

3. Class design

--Person class
id (personid)   	int
firstname		string
middle name	string
lastname		string
State 		object of State class


--State class
stateid		int
statename		string
stateshortname	string
Country 		object of Country class

--Country class
countryid		int
country		string
countryShortname	string