The type of ER diagram that you draw (Chens or Crows Foot) is not important. Please include in your diagram all the notations needed. c) The number of tables needed in each case should be clearly stated. d) Four statements describing the ER is needed in all cases except the supertype/subtype relationships. e) Drawing templates are provided in the assignment section. My suggestion would be to use the Microsoft Word templates.

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.