Given the follwing business rules, create an ERD. The ERD must include all primary keys, foreign keys, attributes, cardinalities. Also consider relational strengths (dashed lines or solid lines) : A...

Given the follwing business rules, create an ERD.  The ERD must include all primary keys, foreign keys, attributes, cardinalities.  Also consider relational strengths (dashed lines or solid lines) :

A university is divided into many schools. Each school has many departments, where each department belongs to one and only one school.  Each department should have one or more professors assigned to it, where each professor cannot teach more than two courses.  The university wants to record the following data for all professors: professor number and full name.  All courses are classified into two categories: Fashion and Technology.