Wait, so if I delete an order, the customer and receipt just vanish into thin air? That's like deleting your entire Amazon order history - poof, gone! Talk about a magic trick.
Hmm, I'm going with C. Deleting a customer should delete the order, but deleting an order shouldn't delete the customer. Gotta be careful with those referential integrity rules, you know?
D? Really? That can't be right. If you delete a customer, it should delete the order as well, not just the customer. These questions can be so tricky sometimes, ugh.
Okay, let's see... Option B seems to be the correct answer here. You can't delete an order because it's referenced in the OrderProduct table, but you can delete an OrderReceipt and it'll take the order with it. Simple enough!
I see your point, Skye. But I think the correct answer is C. Deleting information in Customer should delete information in both Customer and Order. It just seems more logical to me.
I disagree, I believe the correct answer is B. It makes sense that you cannot delete information in OrderProduct table from Entity Order, but deleting information in OrderReceipt will delete information in both OrderReceipt and Order.
I think the correct answer is A because when deleting information in Assubmit Order, all relevant information in Customer and CustomerReceipt will also be deleted.
upvoted 0 times
...
Log in to Pass4Success
Sign in:
Report Comment
Is the comment made by USERNAME spam or abusive?
Commenting
In order to participate in the comments you need to be logged-in.
You can sign-up or
login
Elizabeth
17 days agoMarti
27 days agoRoxanne
28 days agoAliza
18 days agoCristal
1 months agoAlbina
8 days agoLynelle
20 days agoIsreal
21 days agoPhil
1 months agoMelinda
9 days agoVincent
15 days agoFloyd
2 months agoSkye
2 months agoAmie
2 months ago