1 Database testing
The following represents a series of test plans that were developed and then carried out during the first iteration of the websites’ development phase. The purposes of this testing are to test the designed database suitability to the system’s functional requirements analysed in section () and to identify any defects and errors made during the analysis and design phases. The testing considered the following points:
• The testing only covered structured database testing and functional testing. Database security was not taken into consideration as security is applied to the developed web applications.
• A web browser, SQL Server 2014 Management Studio and a dynamic data website that was created in Visual Studio 2015 were used for the testing.
• The website used to conduct the testing was ran locally without the need of an Internet connection.
• Testing was performed on a copy database to prevent any risks from occurring, such as damaging the database.
• Test data was inserted to the database prior to the testing.
Steps in the test scripts that passed the testing have been carried out in the final database without modification or alteration as they meet the requirements and were considered functional. Steps failed to function or did not meet the system requirements were modified …show more content…
The database was attached to this website and a data context was created that includes the database tables. This data context links the database to the website as it holds all the entities mapped over a database connection (Microsoft, 2017). The “Global.aspx” file was then modified to include the data context name and scaffolding tables was set to true. The website was then ready for the database testing as create, read, update and delete functionalities were generated for all the database tables automatically by following the previous