Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!newsfeed1.cidera.com!Cidera!cyclone.nyroc.rr.com!cyclone-out.nyroc.rr.com!twister.nyroc.rr.com.POSTED!not-for-mail Message-ID: <3DF87182.9000908@twcny.rr.com> From: Raymond DeCampo User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases,comp.databases.oracle.server,comp.databases.rdb,comp.databases.theory,comp.lang.java.beans,comp.lang.java.databases Subject: Re: What should be the Database Design in this case? References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 15 Date: Thu, 12 Dec 2002 11:20:52 GMT NNTP-Posting-Host: 24.58.20.15 X-Complaints-To: abuse@rr.com X-Trace: twister.nyroc.rr.com 1039692052 24.58.20.15 (Thu, 12 Dec 2002 06:20:52 EST) NNTP-Posting-Date: Thu, 12 Dec 2002 06:20:52 EST Organization: Road Runner Xref: newsfeed1.easynews.com comp.databases:96533 comp.databases.oracle.server:169500 comp.databases.rdb:1999 comp.databases.theory:24060 comp.lang.java.beans:14501 comp.lang.java.databases:41829 X-Received-Date: Thu, 12 Dec 2002 04:20:37 MST (news.easynews.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