Please include in your diagram all the notations needed. The number of tables needed in each case should be clearly stated. Four statements describing the ER is needed in all cases except the supertype/subtype relationships.

1) In a midwestern univesity, atheletic teams have coaches. A coach can coach multiple teams (of different sports) and teams can have multiple coaches. A coach will be coaching at least one team and all teams have coaches. Coaches have name, date joined, designation, and teams have names, captain, semester (some are fall sports and others of spring/winter sports), win-loss percentage.

2) A borrower in a city library can borrow multiple books but books at a given time are borrowed by only one person. Visualize this in a general library lending scenario and draw an ER diagram. You can assume the constraints as you but state them clearly through your four statements.

3) Employees have managers. While an employee need not manage any other employee(s) all employees have exactly one manager. Employee name, date joined, department, salary, educational level and certifications.

4) In a manufacturing organization, parts can be either purchased or manufactured parts. Purchased parts have vendors, price and manufactured parts have setup time. All parts have number and name. The organization manufacutres some parts but can opt to buy the same parts in case there is an urgent need.