# Given the follwing business rules, create an Crows Foot 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.

Question
30 views

Given the follwing business rules, create an Crows Foot 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.

check_circle

Step 1

The crow’s foot diagram shows the entities as the boxes and relationship as the lines between the entities. Distinct sha...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in