Create an ER Schema for the following scenario. The schema must include: The ER diagram itself, complete with attributes and cardinality constraints. An entity attribute list briefly describing, when necessary, the attributes for each entity. Try to have at least 5 attributes per entity, although this will not be reasonable for some entities. A list of relationship attributes and their description. (NOTE: NOT all relationships will have attributes.) A list of assumptions you have made in order to do this assignment. The North American Rodeo Cowboys Association needs a database to keep track of cowboys and rodeos. Draw an ER model that most accurately and concisely represents the following scenario

1. Cowboys have names, birthdates, genders, and addresses. It is important that the city and state in the address be accessed separately.

2. Rodeos have titles, locations (including city and state), a starting date and an ending date. Rodeos are sponsored by sponsoring organizations which have names, addresses, and phone numbers.

3. Rodeos are comprised of several events. There are many standard events, but not all rodeos will have all events.

4. You need to separately model all the different types of events. There are probably 6-12 different event types that should be modeled.

5. Cowboys participate in rodeo events. A particular cowboy may participate in many different events in many rodeos.

6. Cowboys earn points for participating in some events. Other events have a time associated with them.

7. Some events are individual events, others are team events.

8. The performance of a participant in an event is often ranked, i.e. first, second, or third place, etc. Not all participants will be ranked in an event.

9. Judges are assigned to each event to make and deliver the scores. Judges have names and contact information (addresses, etc.)

10. Cowboys ride animals (usually horses, but occasionally bulls for the bull riding event). These animals sometimes have names and are famous in their own right. Animals have ages which may or may not be known. Sometimes the parentage of the animal is of interest. This needs to be modeled as well.

11. Animals are provided by stock companies or individual owners. Stock companies have names and owners. Owners have names and addresses.

12. Rodeo clowns also work at some rodeo events to provide protection for the cowboy. The names and contact information for the rodeo clowns should be tracked as well.

13. During any given year, cowboys can be ranked in various events. These rankings are independent of any particular rodeo. These rankings will change frequently during the year.