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_at_twcny.rr.com>
>
> 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.
>
Date: Thu, 12 Dec 2002 11:20:52 GMT
Message-ID: <3DF87182.9000908_at_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 - 12:20:52 CET