Question: Explain the need for each of the actions in Figure 6-29(b). Actions When Child Is Required Child Required Action on Parent Get a child. Prohibit.

Explain the need for each of the actions in Figure 6-29(b).

Child Required Action on Parent Get a child. Prohibit. Update the foreign key of (at least one) child. Prohibit. None. A

Actions When Child Is Required

Child Required Action on Parent Get a child. Prohibit. Update the foreign key of (at least one) child. Prohibit. None. Action on Child None. Insert Modify key or foreign key If not last child, OK. If last child, prohibit or find a replacement. If not last child, OK. Delete If last child, prohibit or find a replacement.

Step by Step Solution

★★★★★

3.45 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

When a Child table is required the Parent table must have at least one associated Child table row at ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database Processing Fundamentals Questions!

Explain the need for each of the actions in Figure 6-29(a). Parent Required Action on Parent Action on Child Insert None. Get a parent. Prohibit. Change children's foreign Modify key or foreign key...

Explain the need for each of the design decisions in Figure 6-34. Design Decisions to Be Made Design Documentation Relationship Minimum Cardinality Update cascade or prohibit? Delete cascade or...

Briefly answer the following questions: 1. Explain the intuition behind the two rules in the Bell-LaPadula model for mandatory access control. 2. Give an example of how covert channels can be used to...

Case Summary Read the Discussion Assignment 2-1 on p.34 of the text Technology Adoption by Small Manufacturers. Consider yourself as a health care leader in a small not-for-profit hospital. You have...

Janice Morgan, age 32, is single and has no dependents. She is a freelance writer. In January 2011, Janice opened her own office located at 2751 Waldham road, Pleasat Hill, NM 88135. She called her...

Hey i need help with a final semester project that i am doing where i was trying to do it by my self but could not do and this final assignmentis due by the first week of december. When doing the...

Chapter 10 from Business Law and the Legal Environment was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 license without attribution as requested...

1. City X passes a law that states that "[t]he driver of a motor vehicle when reasonably necessary to ensure safe operation shall give audible warning with his horn," but that "[t]he horn shall not...

1. City X passes a law that states that [t]he driver of a motor vehicle when reasonably necessary to ensure safe operation shall give audible warning with his horn, but that [t]he horn shall not...

Jared Diamond's geography hypothesis for the advantages of people who inhabited the Eurasian continent could be understood through the lens of an endogenous growth model where the initial stock of...

Mr. Smart owns 100% shares of Thomas Holdings Limited which owns 100% of Amber operating limited. Both Thomas inc and Amber Operating Limited have a December 31 year end. The following information...

What is the type of account that is credited when the adjusting entry for depreciation is made? Question 1 7 options: Asset Contra - Asset Liability Contra - Liability

1.15 What is an audit? Describe the uses, advantages and disadvantages of audits.

A simple telephone system consists of two end offices and a single toll office to which each end office is connected by a 1-MHz full-duplex trunk. The average telephone is used to make four calls per...

A regional telephone company has 10 million subscribers. Each of their telephones is connected to a central office by a copper twisted pair. The average length of these twisted pairs is 10 km. How...

Is an oil pipeline a simplex system, a half-duplex system, a full-duplex system, or none of the above? What about a river or a walkie-talkie-style communication?

2. How much life insurance do you need? Calculating needs - Part1 Nick and Megan Doherty are 52 years old and have one daughter, age 14. Nick is the primary earner, making $80,000 per year. Megan...

For questions 5 - 9 , refer to the following problem: In choosing between four new jobs, a business graduate considers the potential payoffs over the next three years. The following table contains...

FIGURE 6.14 One-fund theorem. When both borrowing and lending at the risk-free rate are allowed, there is a unique fund F of risky assets that is efficient. All points on the efficient frontier are...