Mainstream test cases... Excel.. :D?

Candi Motors requires a simple desion to use for a finacial spreadsheet model. customers must pay a minimum of 10% deposit for a vehicle but can pay more. if they do not part exchange their old car in the deal the shwroom price is discounted by 6.5%.





I managed to do the desing but i need to do atleast 10 test cases of which a few have to be of mainstream, boundary, special case and invalid...





what is... mainstream, boundary, and special case.??





please help..Mainstream test cases... Excel.. :D?
mainstream is often called ';happy path'; or ';positive'; testing. These tests make sure the system work as designed assuming everything is done as intended





boundary (aka edge or corner) cases test tend to test limits or unusual conditions that are still valid. A corner case might be if the customer paid exactly 10% deposit and exchanged their old car. Does the system include the 6.5% discount in the 10% deposit requirement? That's an edge case.





special cases are usually ';one-off'; cases. If there was a rule that everyone gets a 6.5% discount except for the owner of the dealership, who gets a 15% discount, the ';owner'; test would be a special case. I don't see any here.





Invalid (usually called ';negative'; testing) is testing that the system FAILS properly. If a person pays only 3% deposit, does the system reject it? If a person pays 140% deposit, does the system reject it?Mainstream test cases... Excel.. :D?
boundary is looking at the outsides - for example 10 % deposit, discount of 6.5. Typically you deal with ranges so you want to check top and bottom of the range.





Mainstream would be standard tests proving the functionality works. E.g., 15 deposit with no discount


20% deposit with a 6.5 % discount.


You are looking to test the normal cases.





Invalid test case would be deposit %26lt; 10%





Can't think of special case for this. Perhaps paying 20% and getting the 6.5% discount.