This concept is related to Whitebox testing in SQL.
Test plan is a document that contains the scope, approach, test design and test strategies. It includes the following:- 1. Test case identifier 2. Scope 3.Features to be tested 4. Features not to be tested. 5. Test strategy. 6. Test Approach 7. Test Deliverables 8. Responsibilities. 9 Staffing and Training 10.Risk and Contingencies 11. Approval
While A test case is a noted/documented set of steps/activities that are carried out or executed on the software in order to confirm its functionality/behavior to certain set of inputs.