Database Design
Not what you're looking for?
1. How are recursive relationships handled?
2. Discuss surrogate keys.
3. Describe the six default referential integrity actions.
4. How are N:M relationships implemented?
5. Why are null values ambiguous?
Purchase this Solution
Solution Summary
How are recursive relationships handled in database design?
Solution Preview
1. How are recursive relationships handled?
A recursive relationship is a relationship among entities of the same class, and is represented in the same way as other relationships are. The rows of the tables can take two different roles, however. Some are parent rows, and others are child rows. If a key is supposed to be a parent key and if the row has no parent, its value will be null. If a key is supposed to be a child key and the row has no child, its value will be null.
2. Discuss surrogate keys.
A surrogate key is a unique, system-supplied identifier used as the primary key of a relation. ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Basic Networking Questions
This quiz consists of some basic networking questions.
C++ Operators
This quiz tests a student's knowledge about C++ operators.