A HAS-A relationship connects an object to something it contains or groups as a constituent part. Aggregation is one form of association; composition is stronger because the part’s lifecycle depends entirely on the whole. section 6.2
User and Address
A User can have an Address made up of street, city, state, country, and ZIP code. The address may be stored in separate columns in the USERS table, avoiding a join to retrieve it with the user. A custom SQL data type is another option, but support is poorly standardized and not portable across database products. section 1.2.1
The diagram shows the composition relationship between User and Address. section 6.2
Object models represent both HAS-A and IS-A relationships, while SQL models represent HAS-A relationships. Mapping inheritance therefore requires strategies such as representing subclasses with foreign-key relationships and joins. section 7.0

