I would like to get feedback about how you approach database part 11 testing.
How do you test the database and to what extent.
Do you test the database for the following
- Audit Trail testing
- How many times do you test that this functionality is working (3,5,7,10 times)
- Date and time
- Who altered what (Signature, Date and Time stamp)
- Do you test that the audit trail is turned on or should it be automatically turned on when the application starts?
- Database locking: Can 2 people alter a record at the same time, how do you test for this
- Access levels
- Password Verification, do you need username and password each time, or just password after the first log on
- Database Schema
- Database performance
- Database backup