how to solve many -many relations ship in frame work
manager?and how to avoid cartigen product in frame work
manager?

Answer Posted / tanveer ahmed

To resolve the many - many relations, one has to broke
cardinalities of either tables... for example Student and
Teacher tables, you can clearly oberserves that One student
will have many Teachers and vice varsa one teacher can have
multiple students too....
so one must have broke the either cardinality of student or
teacher.... like example broke the table of Teacher into
two sub-tables and join the accordingly....

Please refer some good books for understanding how to
define bridge table first for this....

Thanks...............

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi my name is siraj i want to know cognos queriy language

1809


How do we convert from Numeric to be Words?

2502


What is the use of powerplay web viewer in cognos?

553


Can you define bitmap index?

587


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2146






What is the function of model design accelerator?

533


What is called cognos reporting tool?

596


1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

1688


I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

1680


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

578


how you migrate reports to cognos 8 from previous versions?

625


Write types of folders present in cognos?

564


3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2123


What is cognos connection?

587


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

1635