Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.freenet.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: "Alan" <alan@erols.com>
Newsgroups: comp.databases,comp.databases.object,comp.databases.theory
Subject: Re: Demo: Modelling Cost of Travel Paths Between Towns
Date: Mon, 15 Nov 2004 09:46:08 -0500
Lines: 28
Message-ID: <2vrtpgF2lr0caU1@uni-berlin.de>
References: <4b45d3ad.0411071807.4cbd51f0@posting.google.com> <4b45d3ad.0411081928.6a6907a4@posting.google.com> <4b5394b2.0411101203.5d1ba318@posting.google.com> <4b45d3ad.0411112047.56e519d7@posting.google.com> <2vjto5F2kcdttU1@uni-berlin.de> <4b45d3ad.0411121454.4bce3508@posting.google.com> <_reld.307$2V4.227@trndny06> <4b45d3ad.0411131103.7bc5694b@posting.google.com> <qs1dp0h29i85cutpisoavdp0toj91kklvs@4ax.com> <4b45d3ad.0411132137.2a9f774@posting.google.com> <eoLld.9231$tI3.2924@trndny01> <4b45d3ad.0411141752.2459ac4c@posting.google.com>
X-Trace: news.uni-berlin.de xk9fn7u73NCALaL+VlwO4Qsf73HmeT3RPmv9VWIC+KfEQhPlDT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Xref: dp-news.maxwell.syr.edu comp.databases:41852 comp.databases.object:12814 comp.databases.theory:28214


"Neo" <neo55592@hotmail.com> wrote in message
news:4b45d3ad.0411141752.2459ac4c@posting.google.com...
> > > Yes, a separate table for states is the correct way to avoid redundant
> > > PA's (even if PA doesn't have any properties). Alan didn't provide
> > > such a schema thus he has redundant PA's.
> >
> > States do not need a seperate table because (at this point, anyway)
> > they have no properties.
>
> A separate table for states is need to avoid redundant PA's. Your
> current schema has redundant PAs. The first PA represent PA. The
> second PA also represents the same PA as the first. According to CJ
> Date, redundancy leads to update anomalies. Assuming no
> auto-sychronization, your db can be corrupted by modifying one of the
> PAs. Please reread chapter 10 and in particular pg 312 of "An Intro to
> Db Systems" 6th Ed.

YOU have absolutely NO IDEA what you are talking about. I have less and less
respect for you as time goes on. PA is not redundant. If the exact same row
(all attributes) were stored twice, there would be redundancy. According to
your MIS-interpretation, PA would be stored once in, say, a STATES table,
along with some state_id, say 31 for PA, and the number 31 would be stored
multiple times in the data tables to represent PA. But then 31 is redundant
by your bizzare thought process. Either that, or there can only be one row
for all towns in PA. You make no sense. Does not speak well for Xdb.