ORDERS AND PRODUCTS

THE ER DIAGRAM FOR ORDERS AND PRODUCTS IS GIVEN BELOW

  • There are many workers working under a project.
  • Each worker is identified by name,workerid and by address.
  • The project may include several departments under which many products are being produced.
  • Several workers may belong to single department and may participate in many projects.
  • Each department is been identified by name,department id and by address.
  • Similarly the projects have got it’s own project id and name.
  • The products too got their own name and product id.
  • The project may include several buyorders that may contain the product details and suppliers who delivers the buy orders.
  • The buyorders are specified by their ordered,orderdate and deliverydate.Same way,suppliers are specified by their name and supplier id.

ER DIAGRAM

RELATIONAL MODEL

 

 

Advertisements