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.
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.