Question
There are two tables, Part and PartSupply. Part has columns partkey, name, and price. PartSupply has columns partkey, supplykey, quantity, and supplycost. I need to
There are two tables, Part and PartSupply. Part has columns partkey, name, and price. PartSupply has columns partkey, supplykey, quantity, and supplycost. I need to implement a constraint or trigger that if a part's price changes then the supplycost for any row in partsupply should change by the same amount. So if a part's price increased by 10 percent then all rows in supplycost that correspond to that part should have a 10 percent increase in the supplycost. This needs to be in postgresql. I was wondering if someone could explain to me how to go about doing this.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started