Explain the need for each of the design decisions in Figure 6-34. Design Decisions to Be Made
Question:
Transcribed Image Text:
Design Decisions to Be Made Design Documentation Relationship Minimum Cardinality • Update cascade or prohibit? • Delete cascade or prohibit? • Policy for obtaining paront on insort of child M-O Referential integrity (RI) actions plus documentation for policy on obtaining parent for child insert. • Policy for obtaining child on insert of parent • Primary key update cascade or prohibit? • Policy for update of child foreign key • Policy for deletion of child All decisions for M-O and O-M above, plus how For mandatory parent, RI actions plus documentation for to process trigger conflict on insertion of first instance of parent/child and deletion of last instanco of paront/child. Use Figure 6-28(b) as a boilerplate. O-M М-м policy on obtaining parent for child insert. For mandatory child, use Figure 6-28(b) as a boilerplate. Add documontation on how to procoss triggor conflict.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 77% (9 reviews)
1 MO design decisions The MO design decisions are based on a mandatory parent If the primary key is ...View the full answer
Answered By
Amar Kumar Behera
I am an expert in science and technology. I provide dedicated guidance and help in understanding key concepts in various fields such as mechanical engineering, industrial engineering, electronics, computer science, physics and maths. I will help you clarify your doubts and explain ideas and concepts that are otherwise difficult to follow. I also provide proof reading services. I hold a number of degrees in engineering from top 10 universities of the US and Europe.
My experience spans 20 years in academia and industry. I have worked for top blue chip companies.
5.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
-
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...
-
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 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...
-
Benny sells an apartment building. His adjusted basis for regular income tax purposes is $450,000, and it is $475,000 for AMT purposes. He receives $700,000 from the sale. a. Calculate Bennys gain...
-
Richardson Services Ltd. was formed on May 1, 2017. The following transactions took place during the first month. Transactions on May 1: 1. Shareholders invested 50,000 cash in exchange for ordinary...
-
Distinguish between primary and secondary air pollutants. Give examples of each.
-
What is a NDI?
-
Assume that the average firm in your companys industry is expected to grow at a constant rate of 6 percent and its dividend yield is 7 percent. Your company is about as risky as the average firm in...
-
4. Superman is very strong. In trying to impress Lois Lane, he stands on top of a 12-storey building (-50 meters tall), lowers a very tall and wide straw into a pool of Kool-Aid and tries to drink....
-
2020 2021 2020 2021 Cash 1800 N/P 2700 Marketable securities 2600 A/P 1800 A/R 2200 Accrued Expenses 1600 Inventory 4000 Unearned Revenue 1200 Prepaid Expenses Total Short Term Llabilities 1900 7300...
-
Explain the implications of each of the minimum cardinality specifications in Figure 6-40. Cardinality MAX MIN Relationship Parent Child Type Nonidentifying 1:N Nonidentifying 1:N Nonidentifying 1:N...
-
Explain why the enforcement of M-M relationships is particularly difficult.
-
a. The tax law refers to gross income, yet the term gross income is not found on Form 1040. Explain. b. Why is it important to understand the concept of gross income even though the term is not found...
-
sounds coming from the north side of her three-story house. Toward the end of the second day, she examined the exterior of her house and noticed two large holes located near the roof. To inspect the...
-
Krista was a passenger in a rented van. She sustained injuries when the driver of the van slammed into a tree after the vans brakes failed. The driver of the van was not an authorized driver pursuant...
-
Between February 2020 and April 2020, the labor force participation rate for people ages 20 to 24 declined by 8.7 percentage points. The labor force participation rate for people ages 25 to 54...
-
Veronicas expense report was reviewed by her company, and she was accused of taking her best friend on a business conference to Paris and charging all expenses for both of them on a company credit...
-
The National Bureau of Economic Research (NBER) determines the dates when recessions begin and end. Most economists and policymakers accept these dates when analyzing recessions. On its website, the...
-
A hot-and-cold forming machine was purchased at a cost of $65,000. It has an estimated useful life of six years with salvage value of $8,000. It was placed in service on March 1 of the current fiscal...
-
The following selected information was taken from Sun Valley Citys general fund statement of revenues, expenditures, and changes in fund balance for the year ended December 31, 2019: Revenues:...
-
Compare and contrast byte-stuffing and bit-stuffing.
-
Assume we change the Stop-and-Wait Protocol to include a NAK (negative feedback), which is used only when a corrupted frame arrives and is discarded. Redraw Figure 11.9 to show this change. Figure...
-
In a byte-oriented protocol, should we first unstuff the extra bytes and then remove the flags or reverse the process?
-
Suppose two factors are identified for the U.S. economy: the growth rate of industrial production, IP, and the inflation rate, IR. IP is expected to be 3% and IR 6%. A stock with a beta of 1 on IP...
-
Powell Company began the Year 2 accounting period with $18,000 cash, $60,200 inventory, $49,400 common stock, and $28,800 retained earnings. During Year 2, Powell experienced the following events:...
-
Consider the following matrix A: 1 A = -22 -22 3 Use MATLAB to find the eigenvalues of matrix A. The command in MATLAB is [V,D]=eig(A). Where V is the matrix of eigenvalues and D is the matrix of...
Study smarter with the SolutionInn App