Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / Exercise 7.5.2: Write the following as triggers. In each case,disallow or undo the modification if i

Exercise 7.5.2: Write the following as triggers. In each case,disallow or undo the modification if i

Exercise 7.5.2: Write the following as triggers. In each case,disallow or
undo the modification if it does not satisfy the stated constraint.The database
schema is from the “PC” example of Exercise 2.4.1:
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price) ! c) When making any modification to the Laptop relation, checkthat the
average price of laptops for each manufacturer is at least$1500.
! d) When updating the RAM or hard disk of any PC, check that theupdated
PC has at least 100 times as much hard disk as RAM.
! e) When inserting a new PC, laptop, or printer, make sure thatthe model
number did not previously appear in any of PC, Laptop, orPrinter. . . .

Apr 06 2020 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions