| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> Re: normalization review
landonkelsey wrote:
> What normal form is violated here?
> What could fix the problem?
>
> A telephone call is uniquely identified by telephone number and time of call.
> These candidate keys compose the composite primary key. There is another
> attribute/column “telephone location”.
>
> telephone number | time of call | telephone location(precise)
Good luck with the homework assignment! Received on Sun Aug 26 2007 - 21:34:15 CDT
 |
 |