Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q3 [1 pt]: Write the following as triggers for the following schema. In each case disallow or undo the modification if it does not satisfy

image text in transcribed

Q3 [1 pt]: Write the following as triggers for the following schema. In each case disallow or undo the modification if it does not satisfy the stated constraint. Product(maker, model, type) PC(model, speed, ram, hd, price) * hd: hard disk Laptop(model, speed, ram, hd, screen, price) Printer(model, color, type, price) a) When updating the price of a PC, check that there is no lower priced PC b) When inserting a new printer, check that the model number exists in product? c) When making any modification to the laptop relation, check that the average price of laptop for each manufacturer is at least S1,500? with the same speed? d) When updating the RAM or Hard Disk of any PC check that the updated PC has at least 100 times as much hard disk as RAM

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

Beginning Apache Cassandra Development

Authors: Vivek Mishra

1st Edition

1484201426, 9781484201428

More Books

Students also viewed these Databases questions

Question

3. SCC Soft Computer

Answered: 1 week ago