Re: Check for no more than two entries of each value in a column?

From: ddf <oratune_at_msn.com>
Date: Fri, 17 Apr 2009 12:20:26 -0700 (PDT)
Message-ID: <27b125db-4ead-4949-98a2-f1a611de0900_at_l16g2000vba.googlegroups.com>

On Apr 17, 12:40�pm, livefreeordie <jpittm..._at_gmail.com> wrote:
> Hi,
>
> I need to create an app where any given employee may nominate up to
> TWO other employees per year for an award. �This number could change.
>
> Now I could create a table like this:
>
> PK, U1 �nominator � � � � (varchar2(12))
> PK, U1 �year � � � � � � � � (int)
> U1 � � � �nomination1_id �(int)
> U1 � � � �nomination2_id �(int)
>
> Then another table:
> PK � nomination_id � �(int)
> � � � � nominee � � � � � (varchar2(12))
> � � � � nomination_data � ....
>
> However, this would force me to update any Views or Code every time
> the number of allowed nominations changes.
>
> I'd much rather do this:
>
> PK �nomination_id � (int)
> � � � �year � � � � � � � � (int)
> � � � �nominator � � � � (varchar2(12))
> � � � �nominee � � � � � (varchar2(12))
> � � � �nomination_data ...
>
> And have some kind of Check Constraint to only allow two nominees per
> nominator per year. �But I don't know how to do that.
>
> Thoughts?
>
> ~ Jamie

Answered in comp.databases.oracle.server. Posting to more than one newsgroup doesn't always get faster response.

David Fitzjarrell Received on Fri Apr 17 2009 - 14:20:26 CDT