You are working for country club with thousands of members. You have been tasked with designing a database to keep track of the members

You are working for country club with thousands of members. You have been tasked with designing a database to keep  and their guests.

The club keeps track of mail and telephone contact information, name and membership number. When a member joins the club they can become a social member with pool, racket ball and weight room privileges or golf member which includes all of the  privileges plus access to the golf course.

Develop, document and design an EER for this situation