ER diagram based web application testing

Many Organizations depend on Web Applications for performing various activities and stores the collected details in the database. Testing of the database is done to ensure the correctness for the design and working of the database. This paper performs testing of database design for the application using the Entity Relationship diagram for various components used in the database, the model is generated from the relational database that represents various data, entities and the relationship among them. It generates the test data in the form of semantics of the prolog facts and the rules. The Guard queries are generated as test cases for the database. These are executed to validate that the design of the database is appropriate for the Web Application with the objects.