Tow tables is there employee, projects . (many to many) one employee has differ

Tow tables is there employee, projects .
(many to many) one employee has different projects and one
project has different employees . how we can achive the data
from both

Question Posted / vinodkrishnamsetty

2 Answers
6416 Views
Hexaware, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Tow tables is there employee, projects . (many to many) one employee has different projects and one..

Answer / raja mahesh

Here a row in Employee table can have many matching rows in Projects table, and vice versa. You create such a relationship and can retrieve data by defining a third table, called a junction table, whose primary key consists of the foreign keys from both table employee table and projects table.

Is This Answer Correct ?

9 Yes

0 No

Tow tables is there employee, projects . (many to many) one employee has different projects and one..

Answer / praveen

What kind of data(column) they need that not mentioned in
the question.

But, If they want data from both table we can use Join
comments by using primary key and forien key

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More Business Objects Interview Questions

if the project is assigned for you and the client said yo wait for a month,What will you do in that time?

1 Answers

Have you worked with multiple data sources? If yes. How do you link them?

1 Answers

HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?

2 Answers

where are objects are stored ?