Posted by Mike on 12/07/05 19:23

Do you have any book that you recomend?


On 7 Dec 2005 09:19:16 -0800, David Portas wrote:

> Mike wrote:
>> Can anyone tell me what is best practices to define relationships between
>> tables and to define their primary key?
>>
>
> I think you mean Foreign Keys, not "relationships". Foreign Keys
> maintain referential integrity by ensuring that data is complete and
> consistent in your tables.
>
>> For example...
>> One table is Orders and other is OrderDetails.
>> For ease of accessing datas from table OrderDetails I have fields copied
>> from Orders like year_of_order, order_number, client_id.
>>
>
> What does "ease of accessing data" mean? I think you are making a
> fundamental error. Do you understand what Normalization is? There is a
> set of well-founded principles for designing a database schema and you
> don't seem to be familiar with them. I recommend you take a course or
> study a book on design because there is far more material for you to
> cover than we can sensibly try to convey in a newsgroup.

[Back to original message]