Given the data requirements, design an Entity$-$Relationship diagram for the following statements. Show all entities along with minimum and maximum cardinalities. State any necessary assumption regarding attributes and relationships, if not provided in the question.

Statements

In a library system, books can be written by multiple authors but published by a single publisher. Members can borrow maximum five books at a time.

An actor works in exactly one movie. A movie can have many actors.

A fight belongs to a single airplane while an airplane can have many flights.

make erd for it