Qn)There are many workers working under a project.Each worker is identified by name,worker id 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.With these information create an er diagram correspondingly.
ANSWERS:
  STEP 1:IDENTIFY THE ENTITIES
      -Worker
       -Department
       -Project
       -Buyorder
       -Product
       -Supplier
 STEP 2:IDENTIFY THE RELATIONS

       -Many workers may belongs to single department.
 -Many workers may participate in many projects.
 
       -A single worker can make many buyorders.
 

       -A single buyorder may contain many products.
       -Many buyorders can be delivered by many   
        Suppliers.
 
   ImageImageImage

STEP 3:IDENTIFY KEY ATTRIBUTES
       -Worker:-workerid
       -Department:-departmentid
       -Project:-projectid
       -Buyorder:-orderid
       -Product:-part#
       -Supplier:-supplierid

STEP 4:IDENTIFY OTHER ATTRIBUTES
     
        -Worker:-name,address
 
        -Department:-name,address
 
        -Project:-name
 
        -Buyorder:-deliverydate,orderdate
 
        -Product:-colour
        -Supplier:-name
 

 
ImageImageImage

     STEP 5:COMPLETE THE ER DIAGRAM
Image

Advertisements