Your ok to play with SELECT commands as they only select data from the database, they do not modify it in any way.

EDIT: Just realised you were probably talking about your CREATE TABLE operations, not the SELECT. They seem fine, although you may want to create a relationship between the members and vocation table