Member Avatar for AvinashW

dept (dept_no, dname, loc, mgrcode)
emp (emp_no, ename, designation)
project (proj_no, proj_name, status)
dept. and emp. are related as 1 to many.
Project and emp are related as 1 to many.
i) Give the names of employees who are working on ‘Blood Bank’ project.Inline Code Example Here

  • 1 Contributor
  • 1 Reply
  • 148 Views
  • 1 Minute Discussion Span
  • Latest Post Latest Post by AvinashW
Member Avatar for AvinashW

dept (dept_no, dname, loc, mgrcode)
emp (emp_no, ename, designation)
project (proj_no, proj_name, status)
dept. and emp. are related as 1 to many.
Project and emp are related as 1 to many.
i) Give the names of employees who are working on ‘Blood Bank’ project.tell me the query.

Edited by AvinashW
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.