How can we write test cases from Requirements? Do the Requirements represent exact Functionality of AUT?
Yes, Requirements should represent exact functionality of AUT. First of all you have to analyze the requirement very thoroughly in terms of functionality. Then you have to think about suitable test case design techniques (Black Box design techniques like Equivalence Partitioning, Boundary Value Analysis, Error Guessing and Cause Effect Graphing) for writing the test case. By these concepts you should write a test case which should have the capability of finding the absence of defects. 10. How do you select all records from the table? Select * from table_name; 11. What is a join? Join is a process of retrieve pieces of data from different sets (tables) and returns them to the user or program as one joined collection of data. 12. What is a primary key? The column (columns) that has completely unique data throughout the table is known as the primary key field. 13. Which functions can be used only with numeric values? Average (AVG) and SUM 14. What are referential integrity constraints? Re
