Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » RADICORE » How To » Regarding optional attributes and denormalisation
Re: Regarding optional attributes and denormalisation [message #2812 is a reply to message #2809] Sun, 09 October 2011 05:39 Go to previous messageGo to previous message
AJM is currently offline  AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK
Senior Member
It is breaking normalisation for the simple reason that all relations which share the same primary key are supposed to be combined into the same table. That is the starting point, and from there you begin applying the other normalisation rules.

Thus if an entity called CUSTOMER has 100 attributes you start by putting them all into a single CUSTOMER table. It is only when you step through the rules of normalisation that you identify reasons to split attributes off into other tables.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Previous Topic: Using UPD4 to process emails
Next Topic: Tutorial Part 4 - Figure 6
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Sat Nov 23 19:27:55 EST 2024

Total time taken to generate the page: 0.00898 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software