Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 6540 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between business requirement document and use case document.
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
How would you format some text using css to be verdana and bold?
What three things do you consider to be the most important factors for a manager?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Difference between b.o 5.1 and 6.1b?
Explain about a tricky situation for which you found a very simple solution?
Explain what task is 98% of the required work of a business analyst?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
what are the tables used in health care domain project and columns used in report?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain how to execute the plsql procedure from the report by clicking with mouse?
What is the dense rank?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What is the difference between absolute and relative div positioning?
