Testing Deliverables and Designing Test Cases

Southern Pharmacy

Southern Pharmacy(SP)hired a database developer to develop a database system for automating the dispensing of pharmaceutical productsin the SP business. The developer completed these deliverable documents and handed in to SPwhere they approach you as the expert in the field of testing to test the outputs from the database developer. These are the following outputs (received from the developer)are handled over to you.1.Business Requirement2.Data Model& Data Dictionary3.SQL DDL ScriptThe database specification documents as stated above are provided in the Appendix D.Requirements:1)Demonstrate the usage of static and dynamic testing activities on the given deliverables.(7 marks)2)Describethe usage of equivalence partitioning (EP)andboundary value analysis(BVA), black-box and white-box testingapproaches in designing test casesfor the given deliverables. (8marks)3)Write a one-page report summarizing your test plan and other related activitiesfor testing the given deliverables. Your report should address the purpose, methodology, principles,and ethical & psychological effects of testing.At the end of your report, make a clear recommendation ofyour test assignment with respect to Agile developmentapproach.(20 marks) 3PART B (Design, Execute and Report Test Cases)(45Marks)One of the requirements at Mt Roskill Grammar School is for a student to develop a computer program known as StringCounter, described below:The StringCounteraims to process stringsand it must be written inPython that will accept a sentence or a paragraph or paragraphs from the user (as a given input) and perform various tasks on it. A sentence is a string consisting of words separated by spaces. A word is one or more non-space characters. Write separate functions to perform each of the following tasks.•Find how many words are in the given input. So for the sentence “this is a sentence” it should return number 4.•Find how many spaces are used in the given input. So for the sentence “this is a sentence” it should return 3.•Find how many times vowels are used in the given input. So for the sentence “this is a sentence” it should return 6.The StringCountermust be writtenfrom scratch, do not use the built-in Python libraries. Call these functions from a program that prompts the user for input, then writes out the results of calling each function. Use the raw input Python function to get the sentence from the user. Another useful function is ‘len’, which returns the length of a string.The StringCounterdeveloped in pythonby a student isprovided in the Appendix E.Requirements:Write a short report summarizing your test plan, purposes, and related activities with appropriate recommendations. Your report must show the following requirements to earn marks:4)Test plan, purposes,and content with professional format (4marks)5)Draw a diagram to show the computer programflow of activities. (4marks)6)Identify 2 functional featuresand 2 non-functional features would expect for the StringCounterto have. In your answer, provide rationale and fit criteria for each of the four requirements. (4 marks)7)Choose one functional feature from the four features you already identified in question 6) and construct its corresponding decision table and (state transition diagramor code-coveragediagram). (1