Oracle pl/sql

How to write an index and provide example using the following tables

club member tag_member_w interest PK PK username member username password PPK interest id proifle info interest member_username first name last name mi street city state zipcode dob PK interest icd interest tag CI