Re: Database Design Help
Posted by: Rick James
Date: November 02, 2010 09:47AM

Table: Customers
Table: Tests
Table: Results

The Customers table has an customer id, email, etc.
The Tests table has a test id, customer id, date, etc
The results table has compound primary key with test id and test result id (1..5000?); then columns as you suggest.

Try to write CREATE TABLEs to achieve that, then let's discuss further, but limit your law suits to how much you are paying for this advice.

Options: ReplyQuote


Subject
Written By
Posted
November 01, 2010 02:29AM
Re: Database Design Help
November 02, 2010 09:47AM
November 30, 2010 02:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.