Reference no: EM132158120

Question :

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 connectivities and cardinalities on the ERD.

a). Each course generates one or many sections. The number of sections can not exceed five sections.

b). A section must be associated with one course.

c). Each instructor may teach many classes (sections) but not more than four sections.

d). Each section is taught by one and only one instructor.

e). Each class may have many students registered but not more than 45 students per class.

f). Each student may register for many classes but the number of classes (sections) must be at most six per semester.