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 connectivity and

cardinalities on the ERD.

a). A recording company works with many singers. A singer

may have many CDs.

b). A CD belongs to one and only one singer.

c). A CD is

associated with at least one but not more than two recording studios.

d). Each recording

studio may have many CDs recorded.

e). All studios are grouped into three categories.

Each category must include at least one studio.

PLEASE INCLUDE BRIDGE ENTITY