Create Action Charts Action charts quickly describe the behaviour between a parent and child on how...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create Action Charts Action charts quickly describe the behaviour between a parent and child on how that behaviour enforces the relationships when instances of the entity are manipulated. You always do your best to make parents MANDATORY and children OPTIONAL. That eliminates significant coding you will need to do with triggers when you create your database diagram. To fill out an action chart, you specify the min cardinality of the parent (MANDATORY or OPTIONAL) in the first column. Then you specify the behaviour for each INSERT, UPDATE, and DELETE in the relationship. It's a good practice to provide the actual names of the parent and the child entities in the chart. It makes it easier to code and to write test scripts. In the parent column (second column) you specify what happens if the parent is inserted/updated/deleted and how that affects the child. In the child column (third column) you specify what happens if the child is inserted/updated/deleted and how that affects the parent. Review the example below for a MANDATORY parent OPTION child relationship. Mandatory STUDENT STUDENT (parent) GRADE (child) INSERT UPDATE DELETE Allow. Allow when associated with a STUDENT. Prohibit. Using surrogate Prohibit. Using surrogate key. key. Prohibit when a GRADE is associated with a STUDENT, Allow. Conceptual Data Model DEPARTMENT DepartmentName H Description SECTION SectionName is STUDENT H StudentNo FirstName LastName Address Province City PROGRAM ProgramName Description section runs for semester for course supports lists assigned delivers is instructed by GRADE StudentNo SectionName assigned by PercentGrade LetterGrade COURSE CourseName Description -O PROFESSOR FirstName LastName H Address Province City Fill out the following action chart for SECTION and PROFESSOR based on the conceptual data model. Submit Action Chart Optional Professor INSERT UPDATE DELETE Fill out the following action chart for PROGRAM and COURSE based on the conceptual data model. You will need to specify when to create the parent/child during the INSERT, UPDATE, and DELETE to enforce the entity-to-entity relationship. Submit Action Chart Mandatory Program INSERT Professor UPDATE DELETE Section Program Course Create Action Charts Action charts quickly describe the behaviour between a parent and child on how that behaviour enforces the relationships when instances of the entity are manipulated. You always do your best to make parents MANDATORY and children OPTIONAL. That eliminates significant coding you will need to do with triggers when you create your database diagram. To fill out an action chart, you specify the min cardinality of the parent (MANDATORY or OPTIONAL) in the first column. Then you specify the behaviour for each INSERT, UPDATE, and DELETE in the relationship. It's a good practice to provide the actual names of the parent and the child entities in the chart. It makes it easier to code and to write test scripts. In the parent column (second column) you specify what happens if the parent is inserted/updated/deleted and how that affects the child. In the child column (third column) you specify what happens if the child is inserted/updated/deleted and how that affects the parent. Review the example below for a MANDATORY parent OPTION child relationship. Mandatory STUDENT STUDENT (parent) GRADE (child) INSERT UPDATE DELETE Allow. Allow when associated with a STUDENT. Prohibit. Using surrogate Prohibit. Using surrogate key. key. Prohibit when a GRADE is associated with a STUDENT, Allow. Conceptual Data Model DEPARTMENT DepartmentName H Description SECTION SectionName is STUDENT H StudentNo FirstName LastName Address Province City PROGRAM ProgramName Description section runs for semester for course supports lists assigned delivers is instructed by GRADE StudentNo SectionName assigned by PercentGrade LetterGrade COURSE CourseName Description -O PROFESSOR FirstName LastName H Address Province City Fill out the following action chart for SECTION and PROFESSOR based on the conceptual data model. Submit Action Chart Optional Professor INSERT UPDATE DELETE Fill out the following action chart for PROGRAM and COURSE based on the conceptual data model. You will need to specify when to create the parent/child during the INSERT, UPDATE, and DELETE to enforce the entity-to-entity relationship. Submit Action Chart Mandatory Program INSERT Professor UPDATE DELETE Section Program Course
Expert Answer:
Answer rating: 100% (QA)
The images provided show guidelines for creating action charts for database relationships as well as a conceptual data model The action charts are to ... View the full answer
Related Book For
Organizational Behaviour Concepts Controversies Applications
ISBN: 978-0132310314
6th Canadian Edition
Authors: Nancy Langton, Stephen P. Robbins, Timothy A. Judge, Katherine Breward
Posted Date:
Students also viewed these databases questions
-
To use this drawing tool, click on the graph at two different points to position the line. Graph the equation of the line y = -2. 51 4 -5-4-3-2-1 3 2 1 2 3 4 -1 -2 -3 -4 -5
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
At times we can generate a regression equation to explain outcomes. For example, an employees salary can often be explained by their pay grade, appraisal rating, education level, etc. What variables...
-
Suppose that the pump of Fig. P11.9 is run at 1100 r/min against a pressure rise of 210 bar. (a) Using the measured displacement, estimate the theoretical delivery in gal/min. From the chart,...
-
Showcase Co., a furniture wholesaler, sells merchandise to Balboa Co. on account, $254,500, terms n/30. The cost of the merchandise sold is $152,700. Showcase Co. issues a credit memo for $30,000 for...
-
In Example 11.13, HENs are designed for a process involving two hot and two cold streams. Note that three designs are proposed: (1) involving only HP steam and cooling water that meets the \(N_{H X,...
-
Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year's capital budget. The projects are independent. The cash outlay for the truck...
-
1. Identify and describe 3 benefits of working in groups 2. Identify and describe 3 potential problems of working in groups. 3. Describe how you would manage the group so all voices are heard,...
-
The 50-lb plate ABCD is attached at A and D to collars that can slide on the vertical rod. Knowing that the coefficient of static friction is 0.40 between both collars and the rod, determine whether...
-
Marthastarts saving for her retirement by making monthly deposits into a retirement account whose annual rate is 3.9%.She plans to retire in29 years with an amount of money that has the same buying...
-
Provide an objective setting paragraph on HP Inc.'s decision to increase the R&D investment to use towards their partnership with Poly Solutions to enhance Microsoft Teams flexibility
-
Developing new and innovative products requires an understanding of organizational production systems, you have therefore been requested by a team of operations managers of a leading consumer goods...
-
choose the closest answer find the annual total cost of inventory. if the company using their present lot size do not use the EOQ be sure to use the present lot size . unit cost$5, ordering cost...
-
Review the U.S. Airways Flight 1549 case. Reflect on the events and how the actions of Captain Sullenberger relate to our course discussions on crisis leadership. Consider the following: What lessons...
-
9. A 10-year loan with an annual effective interest rate of 5% per year for X is taken out by Joe. Joe fully repays the loan using the following schedule of payments. (i) (ii) (iii) 100 at the end of...
-
Discuss how is nutrition different in rich and poor areas?
-
One hundred pounds of water at atmospheric pressure are heated from 60F to 200F. What is the enthalpy change? The internal energy change? Why is the difference between the internal energy change and...
-
TerraCyclea company co-founded by Canadian entrepreneurs Tom Szaky and Jon Beyermakes a wide range of eco-friendly products from garbage. Szaky observes that the primary purpose of business has...
-
What are the effects of team size on performance?
-
Why do subcultures develop in an organization?
-
The number on the jersey of each New York Giants football player is recorded, then the mean of those numbers is computed. Decide whether the statement makes sense (or is clearly true) or does not...
-
A professor calculates final grades using a weighted mean in which the final exam counts twice as much as the midterm. Decide whether the statement makes sense (or is clearly true) or does not make...
-
The following ages (years) of survey respondents: 22, 19, 21, 27, over 65, over 80. State whether the mean or median would give a better description of the average. Explain your reasoning.
Study smarter with the SolutionInn App