473,698 Members | 2,339 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

carrying normalization too far?

I'm wondering if I'm trying to normalize data way beyond what will prove
practical. For example, if I put People, Addreses, and Comms in 3 different
tables, with junction tables for People/Addresses and People/Comms, then
will the data entry form for new contacts have to be in form, subform,
subsub form and possibly more subs?

If my table structure is split so much that a common data entry form has
fields bound to 8 or 10 different tables, is this going to be a nightmare to
create and use? TIA
Nov 12 '05 #1
4 1787
fp
To make your design more flexible, use views (queries) that do your joins
for you. Then if you make a table change your views will still work.

As far as normalization, you do that first to lay out your data. After that,
you may need to de-normalize some aspects of your design for performance or
other reasons.

It sounds like you are on the right track.

--
*************** ***************
Fred Parker
Lynn Consulting Group, L.L.C.
http://www.lynnconsultinggroup.com
*************** ***************
Nov 12 '05 #2
"Catherine Jo Morgan" <cj******@hemc. net> wrote in message news:<19******* *************@h emc.net>...
I'm wondering if I'm trying to normalize data way beyond what will prove
practical. For example, if I put People, Addreses, and Comms in 3 different
tables, with junction tables for People/Addresses and People/Comms, then
will the data entry form for new contacts have to be in form, subform,
subsub form and possibly more subs?

If my table structure is split so much that a common data entry form has
fields bound to 8 or 10 different tables, is this going to be a nightmare to
create and use? TIA


If 3 tables is enough and you can query and get the information you
want, then that's enough. the real question now is, if you build your
database with 3 tables, can you summarize/search it the way you need
to? If so, then that's normalized enough. It's an impossible
question to answer without knowing what level of summary you're
looking for.
Nov 12 '05 #3
hhhmmmm
normalisation . . . say like homer simpson saying beer . . . .

part of normalisation is doing the maths on how much duplication of data
occurs versus the performance tradeoff. In its purest form there should be
NO duplication . . just pointers linking records. In reality thats hardly
ever the case. Consider the addresses / people . . how often do more then 1
person share an address. 1 in 100 . . 1 in 10 . . . 1in 5 . . the more
tables you have - the more processing you need to do to control the
structure . . so look for the Right level of comprimise . . It may mean you
must split the people/addresses even if a duplicate occurs 1 in a million .
.. or you can handle it a 1 in 10 . .Personally i start on the premise that
if a duplicate can occur . . then split it and work my way backwards
consolidating tables until I have a workable solution. . . And I was doing
this a years before the PC was introduced to the world . .but the basic
rules dont change. The interesting stuff is learning how to bend them . .
grin . .
cheers
paul g


"Pieter Linden" <pi********@hot mail.com> wrote in message
news:bf******** *************** *@posting.googl e.com...
"Catherine Jo Morgan" <cj******@hemc. net> wrote in message

news:<19******* *************@h emc.net>...
I'm wondering if I'm trying to normalize data way beyond what will prove
practical. For example, if I put People, Addreses, and Comms in 3 different tables, with junction tables for People/Addresses and People/Comms, then
will the data entry form for new contacts have to be in form, subform,
subsub form and possibly more subs?

If my table structure is split so much that a common data entry form has
fields bound to 8 or 10 different tables, is this going to be a nightmare to create and use? TIA


If 3 tables is enough and you can query and get the information you
want, then that's enough. the real question now is, if you build your
database with 3 tables, can you summarize/search it the way you need
to? If so, then that's normalized enough. It's an impossible
question to answer without knowing what level of summary you're
looking for.

Nov 12 '05 #4
On Sun, 30 Nov 2003 09:14:51 -0500, "Catherine Jo Morgan"
<cj******@hemc. net> wrote:
I'm wondering if I'm trying to normalize data way beyond what will prove
practical. For example, if I put People, Addreses, and Comms in 3 different
tables, with junction tables for People/Addresses and People/Comms, then
will the data entry form for new contacts have to be in form, subform,
subsub form and possibly more subs?
No. You *will* need some way to present the data from M:N
relationships to the user, but you don't have to use subforms to do
that. (And you probably shouldn't.)
If my table structure is split so much that a common data entry form has
fields bound to 8 or 10 different tables, is this going to be a nightmare to
create and use?


Well, if you're going to try to bind a form to a query with a dozen
joins in it, you're going to have a lot of trouble.

Instead, find a different way. Do some research on "unbound forms".

--
Mike Sherrill
Information Management Systems
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
6269
by: Ralph Freshour | last post by:
I was reading about PHP variable scoping - it doesn't seem to support carrying any variables from one web page to another - how is this usually done? I have a lot of php variables created on my home page that I need to make use of on other web pages - how can I do that? Thanks...
36
10093
by: Richard | last post by:
My employer currently pays me $1/hour when I carry a pager. I have to carry the pager every fourth week. The problem is that my employer insists that I be available when I'm carrying the pager. So, for $1/hr they expect me to remain within pager range, remain sober, and be available to come to work. That really sucks on weekends. No going to the beach (out of pager range) or out to a friend's cottage (out of pager range), etc. ...
3
3171
by: JoeB | last post by:
I found an interesting thread on this from Nov., 2000, but it didn't fully answer my question. I understand normalization, but am trying to find the line between good database design and personal preference. I'm wondering if I've created too many tables. Normalization as I understand it would be to create tables if a field can have more than one occurrance (for example, book titles by an author). But if a field will only have one value,...
2
1479
by: Kostas | last post by:
Hi all, I strived understanding the concepts of all normal forms up to the domain-key normal form but there are some issues I still am unsure of, and I will describe the first one in this post. (it looks so simple that there has to be an answer) Suppose a relation that holds information about Phone Numbers: PhoneNumber (PhoneID, ActualNumber, PhoneType, Comments)
7
2455
by: John Welch | last post by:
I have three tables and the way they are currently set up violates good normalization, but I'm having trouble figuring out a better way. Can someone suggest a more elegant solution? My tables are: tblCompanies: CompanyID - PK other fields like address, type of business, etc
20
6919
by: hippomedon | last post by:
Hello everyone, I'm looking for some advice on whether I should break the normalization rule. Normally, I would not consider it, but this seems to be a special case. I have created an "Outcomes Database" used to store response data from measures/ questionnaires for a longitudinal health study. It is essentially derived from Duane Hookom's Survey Database (thanks Duane!!!), with many modifications added to fit the needs of my lab.
36
2937
by: Shraddha | last post by:
What is mean by normalization of pointers...Where we use that?
1
2023
by: weird0 | last post by:
I know that is not the appropriate group for asking this question, but I do not know of any better forum. Can anyone plz explain clearly what normalization is? The first three normal forms upto 3NF and BCNF. I know the first one but the remaining ones are really confusing. The language changes dramatically into functional dependencies x---y, all that, and normalization, the real topic is lost in between. Decent explanation or good...
22
2449
by: sophia | last post by:
Dear all, can any one explain what is meant by pointer normalization given here:- http://c-faq.com/ansi/norml.html
0
8674
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8603
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9157
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9027
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8861
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6518
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4369
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2001
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.