Explain the need for each of the actions in Figure 6-29(a). Parent Required Action on Parent Action
Question:
Explain the need for each of the actions in Figure 6-29(a).
Transcribed Image Text:
Parent Required Action on Parent Action on Child Insert None. Get a parent. Prohibit. Change children's foreign Modify key or foreign key OK, if new foreign key value matches key values to match new value (cascade update). existing parent. Prohibit. Prohibit. Delete Delete children None. (cascade delete). Prohibit. Figure 6-29(a) – Actions When Parent Is Required
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 58% (12 reviews)
When a Parent table is required every row in the Child table must have a valid nonnull value of th...View the full answer
Answered By
Ali Khawaja
my expertise are as follows: financial accounting : - journal entries - financial statements including balance sheet, profit & loss account, cash flow statement & statement of changes in equity -consolidated statement of financial position. -ratio analysis -depreciation methods -accounting concepts -understanding and application of all international financial reporting standards (ifrs) -international accounting standards (ias) -etc business analysis : -business strategy -strategic choices -business processes -e-business -e-marketing -project management -finance -hrm financial management : -project appraisal -capital budgeting -net present value (npv) -internal rate of return (irr) -net present value(npv) -payback period -strategic position -strategic choices -information technology -project management -finance -human resource management auditing: -internal audit -external audit -substantive procedures -analytic procedures -designing and assessment of internal controls -developing the flow charts & data flow diagrams -audit reports -engagement letter -materiality economics: -micro -macro -game theory -econometric -mathematical application in economics -empirical macroeconomics -international trade -international political economy -monetary theory and policy -public economics ,business law, and all regarding commerce
4.00+
1+ Reviews
10+ Question Solved
Related Book For
Database Processing Fundamentals, Design, and Implementation
ISBN: 978-0133876703
14th edition
Authors: David M. Kroenke, David J. Auer
Question Posted:
Students also viewed these Computer science questions
-
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. Update the foreign key of (at least one) child....
-
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...
-
Using the trial balance prepared for Binbutti Engineering in Part 4 of Problem 2-9A, prepare an income statement and statement of changes in equity for the three months ended July 31, 2014, and a...
-
What are the strongest, most persuasive arguments in favor of a board's consideration of its social responsibility when reaching decisions?
-
Describe a time when you had to stop a client's violent or destructive behaviour. What did you do? What would you have done differently?
-
Water flows in a 5 -ft-wide rectangular channel with a flowrate of \(Q=30 \mathrm{ft}^{3} / \mathrm{s}\) and an upstream depth of \(y_{1}=2.5 \mathrm{ft}\) as is shown in Fig. P10.15. Determine the...
-
Two items are omitted from each of the following summaries of balance sheet and income statement data for two proprietorships for the year 2010, Craig Cantrel and Mills Enterprises....
-
Simplify: T- 6 r 36
-
Louis files as a single taxpayer. In April of this year he received a $900 refund of state income taxes that he paid last year. How much of the refund, if any, must Louis include in gross income...
-
Write an SQL statement to create a view named Customer04DataView based on the CUSTOMER_04 table. In the view, include the values of Customer ID, LastName as CustomerLastName, FirstName as...
-
Describe a MUST constraint. Give an example other than one in this chapter. AGENT (AgentID, {other attributes} CLIENT (ClientID, AgentID{other attributes} PROPERTY (PropertyID, {other attributes}...
-
a. By copying the diagram below twice, use it to show that 20% of 40 is the same as 40% of 20. b. Copy the diagram below and explain how it can be used to calculate 87.5% of 56. 4 10
-
If a specimen dug up in a secret location originally contained 200 g of cobalt 57 and now contains 80 g, approximately how old is the specimen? Answer (accurate to 2 significant digits): 360 days....
-
Problems: Complete each problem as directed. Each problem is worth the amount of points shown. Show all work Problem 1 15 points Frozen Catfish Fillet Project Inputs Cost of Land Cost of Buildings &...
-
Suppose on January 1 the value of the euro is at $1.17/euro, and later in March 1 the value of is at $1.03/Euro. By how much did the dollar appreciate or depreciate? Enter your response in percentage...
-
Amir has plans to gather several colleagues to establish a business institution. However, not all of his colleagues have capital in the form of money. Meanwhile, Anto is an activist in a village who...
-
respond to your classmates' posts on specialized trusts. Make sure you address a different type of trust then the one you discussed in your second post. If your second and third posts address the...
-
The following data are from U Guessed It Company's financial statements. U Guessed It manufactures board games for young adults, and it competes with Marker Brothers and Bilton Radley. Sales (all...
-
Why should you not model a decision variable as a random variable with a probability distribution?
-
The cost of a fast microprocessor has dropped to the point where it is now possible to put one in each modem. How does that affect the handling of telephone line errors? Does it negate the need for...
-
A modem constellation diagram similar to Fig. 2-23 has data points at the following coordinates: (1, 1), (1, 1), (1, 1), and (1, 1). How many bps can a modem with these parameters achieve at 1200...
-
What is the maximum bit rate achievable in a V.32 standard modem if the baud rate is 1200 and no error correction is used?
-
Imagine yourself at a fair playing one of the midway games. Pick a game and calculate the expected value and post your results along with how you calculated them.
-
1. What is the ratio of 2 lengths which are 25 cm and 7.5 m respectively?
-
If f(x, t) does not depend on x, then we have x' = f(t), so that x(t) = (0 to t) f(u)du. Show that, in this case, the RK4 algorithm reduces to Simpson's rule.
Study smarter with the SolutionInn App