SNOWMOBILE CLUB - Database Development
Draw an Entity-Relationship Diagram which must include allentities and their attributes. Primary Keys underlined, ForeignKeys labeled, Weak entities double boxed.
You have been asked to develop a database to help the WisconsinSnowmobile Association track their club members.
The following are the predefined business rules:
1) Snowmobile Clubs are tracked by Wisconsin county.
2) A club can be assigned to multiple counties.
3) Members can belong to one or more clubs.
4) Some clubs could have the same name.
5) New clubs can be started at any time.
6) The Wisconsin Snowmobile Association has an elected ExecutiveBoard consisting of a President, Vice President, Secretary,Treasurer and Executive Director, all of whom must be currentmembers.
7) Each county must have a Director and a Representative.
8) Each club has a President, Vice-President, Secretary andTreasurer.
