Radicore Forum: How To » Regarding optional attributes and denormalisation

Home » RADICORE » How To » Regarding optional attributes and denormalisation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Regarding optional attributes and denormalisation [message #2812 is a reply to message #2809]

Sun, 09 October 2011 05:39

AJM
Messages: 2386
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]

		Regarding optional attributes and denormalisation By: rksk16it on Thu, 06 October 2011 06:01
		Re: Regarding optional attributes and denormalisation By: AJM on Sun, 09 October 2011 05:39
		Re: Regarding optional attributes and denormalisation By: rksk16it on Sun, 09 October 2011 13:18

Previous Topic:	Using UPD4 to process emails
Next Topic:	Tutorial Part 4 - Figure 6

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Oct 30 13:27:09 EDT 2025

Total time taken to generate the page: 0.01052 seconds