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

From: oblomov <spam_at_oblomov.org>
Date: Thu, 5 Dec 2002 23:48:36 +0100
Message-Id: <20021205234836.67fdb167.spam@oblomov.org>

On Thu, 5 Dec 2002 23:50:02 +0530
"Puneet Agarwal" <puneet_at_daffodilwoods.com> wrote:

> I am not sure which one is better. Each of the above has its own
> pluses and minuses.
>
> A)
> +More Normalized
> -Consumes More Database Space
>
> B)
> -Less Normalized (Can reach to Course via both CourseSubjectId and
> CourseExamId)
> -Consumes Less Database Space
> - Easier to ensure data integrity because on those courseExamIds and
> CourseSubjectId's can be mapped which have the same courseId.

You answer your own question. There better way depends on your application. Do you have alot of diskspace? Do you need speed? Will you need a human eye friendly table? Etc.

karl Received on Thu Dec 05 2002 - 16:48:36 CST