Interested to Buy Any Domain ? << Click Here >> for more details...
Can u please describe the different types of traps with eg.
Thanks
- 2 Answers
- 9179 Views
- I also Faced
- E-Mail Answers
Answer Posted / the_xxx
There are two main types of connection traps:
1. fan traps
2. chasm traps
Fan traps
A fan trap occurs when a model represents a relationship
between entity types, but the pathway between certain entity
occurrences is ambiguous. It occurs when 1:m relationships
fan out from a single entity.
Missing ALT text
Figure : Fan Trap
A single site contains many departments and employs many
staff. However, which staff work in a particular department?
The fan trap is resolved by restructuring the original ER
model to represent the correct association.
Missing ALT text
Figure : Resolved Fan Trap
Chasm traps
A chasm trap occurs when a model suggests the existence of a
relationship between entity types, but the pathway does not
exist between certain entity occurrences.
It occurs where there is a relationship with partial
participation, which forms part of the pathway between
entities that are related.
Missing ALT text
Figure : Chasm Trap
* A single branch is allocated many staff who oversee
the management of properties for rent. Not all staff oversee
property and not all property is managed by a member of staff.
* What properties are available at a branch?
* The partial participation of Staff and Property in the
oversees relation means that some properties cannot be
associated with a branch office through a member of staff.
* We need to add the missing relationship which is
called `has' between the Branch and the Property entities.
* You need to therefore be careful when you remove
relationships which you consider to be redundant.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
what are the errors faced while bursting the reports and how to solve those errors?
Can you define a catalog and types of catalogs in cognos?
Can you define report item?
What is called materialized view?
Which studio is used to create reports?
Can you define drill down and drill up?
Can you define cube?
Explain difference between powerplay transformer and power play reports?
whats the difference between previous version of cognos and cognos 8 BI?
Define datastores in cognos?
What are the services provided in cognos 8?
What is the difference between set functions and filter function in dimensional data?
What is the enterprise class platform architecture of cognos 8?
What are the ways to import data into catalog?
