Why recursive relationships are not good
Why recursive relationships are not good? How do you solve them?
Expert
Recursive relationships are an interesting and further complex concept than the relationships you have considered in the previous chapters, like a one-to-one, one-to-many, and many more. A recursive relationship happens when there is a relationship among an entity and itself. For illustration, a one-to-many recursive relationship happens when an employee is the manager of other workers. The employee entity is associated to itself, and there is a one-to-many relationship between one employee (the manager) and many other employees (those people who report to the manager). Due to the more complex nature of these relationships, we will require slightly more complex methods of mapping to them to a schema and displaying them within a stylesheet.
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
In OLE DB, what is the difference between an implementation and an interface?
What are the improved features in Teradata V2R5/6?
Illustrates the term data structure node class?
Describe how we can add a NOT NULL column to a table?
Name the methods that are available in storing sequential files?
Briefly describe the differentiation between data warehousing and data mining ?
Write down the latest error handling technique in SQL Server 2005?
Write about the term metadata in brief.
Name the Applications of tree data-structure?
18,76,764
1938930 Asked
3,689
Active Tutors
1413264
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!