Member Avatar for DevC++4.9.9.2

Hello, Im working on some homework for school a data base class...

Ive done all the queries except the last,
Tables
Specify the following queries using relational algebra and show the result of each query.

Find the names and addresses of all employees who work on at least one project located in Houston but whose department has no location in Houston.

I can get almost everything but the table DEPT_LOCATIONS is throwing me off with it having multiple Dept 5 locations.

Every time I almost have it, I can join this table or work with it since it is not unique values for Dlocation and Dnumber.

Any help would be very much appreciated. Thanks
-Scottiey

Please don't just give me the answer... just an explanation will do

  • 2 Contributors
  • 1 Reply
  • 56 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi

1) You join all table that are required for query.
2)apply appropriate where condition on all columns
3) write query select distinct name, address from your tables joins condition.......

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.