MIS $3365$

DB Design Homework $1$

Due $18$ January

In the following exercises, create an ERD with proper maximum cardinality. You must include all PKs and FKs$.$ Label each relationship as $1$:$1,1$:M$,$ or M:N; name each relationship. Include also one other attribute for every table $($just include one for brevity; obviously a real table would have several other attributes$).$

Every tree belongs to one species. A species has one or more trees.

Bronson Brothers Furniture owns vehicles that are assigned to departments every summer $($though last summer with covid none were assigned$).$ Departments are only assigned a single vehicle.

An airline has many flights taken by many customers.

Campers can reserve zero or more campsites at the state park.