Sunday, March 7, 2010

Response to Travis's Question

For some reason blogger won't let me reply to the post at the moment. Regardless, yes, this is correct. The total of all items in an order.

Exam question 1

I was just kinda curious on this. With the total cost attribute did you mean the total cost of the entire thing or each individual meal. With my current setup that is how I had to do it. I just want to be sure that that is what you meant.

exam

Hi Nicole,
do we have to use create constraints check (...........) or we can use another technique?

Friday, March 5, 2010

examquestion

do we need to use alter table PAYMENT
add constraint CHK_PAYMENT_3 to
check the condition of credit use only when the total is over $5. ???

this means that we do not check cash or debit. and the cash and debit
will not be working after this constranins is inforcing.