Matti24
Last Activity: Mar 29 '07, 09:41 PM
Joined: Mar 29 '07
Location:
-
I will give this a try and ill get back to you -
If i was to move the columns as you have suggested, how could i go about creating a trigger for this business rule ?Leave a comment:
-
Ill build on that a little :) what has to happen is that if five is entered within the date of December then the entry is rejected, but I am not too sure how this can be done as the data is in seperate tables....Leave a comment:
-
Sorry my bad, voyage and cruise are linked via the booking table...Leave a comment:
-
There are my tables:
Cruise(CruiseNO , Name, Duration, Cost, Ports)
Booking(CruiseN O *, CustomerID*, VoyageID*, CabinNo, Class, Evaluation)
Customer (CustomerID, CustomerName, Gender, Telephonenumber , address)
Ship(ShipID, ShipName, Port, tonnage)
Voyage(Voyage_I D, Startdate, Starting_Locati on, ShipID*
Here is some sample data from voyage
...Leave a comment:
-
SQL Trigger
I am fairly new to sql and as part of an assignment I have to create triggers to satisfy business rules.
The first business rule is:
ensure that cruises of five days duration cannot be run in December.
the two columns that are relevant to this trigger are in two separate tables and I am not sure if this will cause any problems.
If anyone can help or point me in the right direction then this... -
SQL Trigger
I am fairly new to sql and as part of an assignment I have to create triggers to satisfy business rules.
The first business rule is:
ensure that cruises of five days duration cannot be run in December.
the two columns that are relevant to this trigger are in two separate tables and I am not sure if this will cause any problems.
If anyone can help or point me in the right direction then this...
No activity results to display
Leave a comment: