Recursive relationships in a database design
How can we handled are recursive relationships in a database design? Describe briefly?
Expert
A recursive relationship is a relationship between entities of the same class, and is represented in the similar way as other relationships are. The rows of the tables can take two various roles, but. Some are parent rows, and the others are child rows. Furthermore, the table will contain both its own primary key and the foreign key which links back to the table itself. When a row has no parent, then the value of the foreign key column in which row will be null. If the row has a parent, then there should be a foreign key value in that row which corresponds to the primary key value of any other row in the table.
Name the Applications of tree data-structure?
Describe briefly the term data warehouse?
Give a brief introduction of the term active data warehousing?
What do you understand by the term RFM analysis?
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
Does System development life cycle changes when you use Teradata in place of Oracle?
partial specialization and total specialization rules in enhanced erd.......
Give a brief differentiation between metadata and data dictionary?
Explain the term iConv and oConv?
Briefly explain SQL Server 2005 Business Intelligence components?
18,76,764
1934083 Asked
3,689
Active Tutors
1428483
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!