The association role defines:
(a) How tables are related in the database
(b) The relationship between the class diagram and the tables in the database
(c) The tables that each attribute is contained
(d) Which attribute is the table’s primary key
I have been asked this question in a national level competition.
The question is from Ordered Indexing and Hashing in chapter Indexing and Hashing of Database Management