Hey Guys,

I was hoping someone could help me with designing a database?

Basically, I want to design a database that will hold a bunch of test cases. For those of you that don't know, a test case simply documents a test that is to be executed on an application.

A test case lists a number of screens within the application, and each screen lists a number of fields, and each field has a corresponding value that is to be entered during that test, so it looks something like:

Test Case 1
----Details Screen
--------Name|Mary J
--------Age|40
--------Location|Home
----Contact Screen
--------Email|123@abc.com
--------Phone|12345678
--------Address|123 Fake Street

Test Case 2
----Details Screen
--------Name|Joe Bloggs
--------Age|50
--------Location|Away
----Contact Screen
--------Email|456@def.com
--------Phone|87654321
--------Address|321 Fake Street

So I need to design a database to hold the above. Can anyone tell me what tables I would need, and what would be the best way to go about storing the data? So far I think I need the following four tables:

TestCase
Screen
Fields
Values

With the cardinality constraints as follows:

TestCasecreen->Many to many
Screen:Fields->One to many
Fields:Values->One to many

Although I'm really not sure. Can anyone please give me some help with this?

Thanks very much for any help!

There are many testing packages on the market, and getting the testing process right is a lot more complex than it appears. I'd strongly suggest using one of the commercially supported or open source test products instead of spending thousands of hours writing, debugging, and documenting your own, especially if there is any chance that your tests might ever be audited..

-PatP