Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M Kroenke, David J Auer

6th Edition

0132742926, 978-0132742924

More Books

Students also viewed these Databases questions