Test script Coursework - 550 Words

Test script (Coursework Sample) Content: Name InstitutionInstructorDate Test scriptTest Specification First PartDesigned by(Insert your Full Name)Screen or Module(User Input Screen)Test Data Source:User entryObjectives:Test basic functionalityThe test scripts below are meant to test the functionalities of an aircraft booking system. The system conforms to the SRS document with which the login details and the customer details are stored in a database. In a normal situation, the data is entered directly either by the user, admin or the customer and directly recorded in the database of the aircraft system. This will also be used to provide with the sign up information for the customer. Actual test Script for basic functionality.Test Case Number/ IDDescriptionTest StepsPriority Expected ResultsActualResultsPerformed by / Date1-1This is a test done for rudimentary functionality of an aircraft system data entry of a customerEnter a trouble ticket with the following fields:FIRST NAME: TestLAST NA ME: TicketUSER NAME: T-ticket numberPHONE NUMBER: XXXX-XXX-XXXFlight Number: T-ticket number-dateTimeYear(Number of Travel times)Personal Computer: LaptopNUMBER OF DAYS: 1Software application used: MS MailGeneral problem: Cant access mail. Forgot my password.The last action is: (Press the SUBMIT key.)High All the data that is provided, is instantly added to the database T-ticket number-dateTimeYear(Number of Travel times)1 DATE \@ "dddd, MMMM dd, yyyy" Friday, August 08, 2014 A test script for basic performance of the systemTest Case Number/ IDDescriptionTest StepsPriority Expected ResultsActualResultsPerformed by / Date1-2This is a rest done for rudimentary performance of the database. This is specific on measuring the buffer cache hit ratioGet initial Buffer Hit Ratio reading. SELECT ROUND((1-(phy.value / (cur.value + con.value)))*100,2) "Cache Hit Ratio" FROM v$sysstat cur, v$sysstat con, v$sysstat phy WHERE cur.name = 'db block gets' AND con.name = 'consisten t gets' AND phy.name = 'physical reads'/Second attempt(Increasing the buffer hit ratio)DECLARE v_dummy dual.dummy%TYPE;BEGIN FOR I IN 1..1000 LOOP SELECT dummy INTO v_dummy FROM dual; END LOOP;END;/(Repeating the measurement)SELECT ROUND((1-(phy.value / (cur.value + con.value)))*100,2) "Cache Hit Ratio" FROM v$sysstat cur, v$sysstat con, v$sysstat phy WHERE cur.name = 'db block gets' AND con.name = 'consistent gets' AND phy.name = 'physical reads'High An initial buffer hit ratio is tested and repeate...