1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivitys and cardinalities on the ERD.

a). A large company employs many agents. An agent works with one or more actors. The number of actors cannot exceed 10 per agent.

b). Each actor may or may not work with one agent.

c). An actor may receive many awards.

d). An award is given to many actors. e). Awards are grouped into five categories. Each category must include at least one award.