Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What should be the Database Design in this case?

Re: What should be the Database Design in this case?

From: Raymond DeCampo <rdecampo_at_twcny.rr.com>
Date: Thu, 12 Dec 2002 11:20:52 GMT
Message-ID: <3DF87182.9000908@twcny.rr.com> 





--CELKO-- wrote:

>>>Now I want to store Subject wise Maximum Marks for each course. <<
>>




> 

> NO!!  You want to query the data and find them.  We do not store

> calculated values in a relational database.  Put it in a VIEW, if you

> re-use the results a lot.

> 




If you read the OP carefully and thought about the problem, you would 
have realized that he is not storing a calculated value at all.  He is 
storing the maximum possible score for the exam.



Ray
Received on Thu Dec 12 2002 - 05:20:52 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US