imposing check constraint on table

[jyothsna1612]

Tables

Classes(class, type, country, numguns, bore, displacement)
Battles(name, date)
Outcomes(ship, battle, result)
Ships(name, class, launched)


If a class of ships has more than 9 guns, then their bore must be no larger than 14 inches.

How to impose the above condition on table using check constraints

Thanks in advace

[PAVB]

I do not think you can do it with check constraint.
I would go with an after insert/update trigger -sorry, you have to actually code the logic.

[LKBrwn_DBA]

Maybe try a before insert/update trigger:

-- etc --
  If INSERTING Or UPDATING('BORE') 
  Then
    If :new.bore > 14 and :new.numguns => 9 Then RAISE; End If;
  End If;
-- etc --

[LKBrwn_DBA]

Try it this way:

Create Table Classes 
(
  Class          Varchar2(10)
, Ship_Type      Char(1)
, Numguns        Number(3)
, Bore           Number(3)
, Displacement   Number(5,1)
, Constraint     Check_Bore
                 Check ((Bore < 14 And Numguns > 8 )
                    Or  (Bore > 0 And Numguns < 9 ))
                 Enable
)
/