Review following cases and create ERD for each case:

Company, Department, Employee

State, City, Zip, Street

Case #$1$:

Q$.$ How many Departments can be in each Company?

A$.$ Many

Q$.$ Can each$(1)$ Department belong to multiple Companies?

A$.$ No$!$

Each$(1)$ Company has Many Departments;

Each $(1)$ Department belongs to $1$ Company.

Conclusion:

Company to Departments: Relation $1$ : M

Departments to Company: Relation M : $1$

Case #$2$:

Q$.$ How many Courses Each Student can take?

A$.$ Many

Q$.$ How many Students can take Each Course?

A$.$ Many

Conclusion:

Student to Course Relation: M : M

S