David,
=I'm feeling a little 'at sea' here, because we had established that you
want to learn more about joining, yet
you recognise the word normalisation straight off. I don't want to
insult you by 'talking down'/teaching
grandma to suck eggs... Please be sure it is not another one of those
You wouldn't happen to have a spare ELH diagram (or two) lying around
that one could take a look at, would you?
Hah TIM now you've got me!
I 'do' diagrams. I don't 'do' neat! [no need to move over Matisse]
The longer answer is that I have diagrams coming out of my ears (well, computer), but
Olinux,
Haven't been following and not sure if this is what
you're after, but these are some great data models:
http://www.databaseanswers.com/data_models/index.htm
Thanks for this. I came across this site/these diagrams before, but thought them to be
too 'introductory' and
vague for use
Hi George,
=I'm feeling a little 'at sea' here, because we had established that you
want to learn more about joining, yet
you recognise the word normalisation straight off...
Feel free to realign my approach...
No need to feel at sea. After an earlier response from either you or Miles,
I
David,
=ex-Navy guys are always at sea - however they never let me near the
ships, but I guess that's another
story...
ex RAF myself (almost 30 years ago though), so I suppose I might be all 'up
in the air'?
level). Once again we draw boxes (I have some wonderful s/w for doing
these
=ex-Navy guys are always at sea - however they never let me near the
ships, but I guess that's another
story...
ex RAF myself (almost 30 years ago though), so I suppose I might be all 'up
in the air'?
=there's a bunch of fast-mover jockies and helo boys who never have to pay for their
David,
=there's a bunch of fast-mover jockies and helo boys who never have to pay
for their drinks when any of my guys
are around...
Air Traffic Control was my area, though we did have to put up with some of
your lot when Ark Royal was in dock as we were a Buccaneer base.
=Sorry,
** Reply to note from DL Neil [EMAIL PROTECTED] Thu, 10 Jan 2002
14:48:02 -
many people have a very shallow understanding of SQL - particularly
[he says generalising like crazy] people who 'fall into it' from
(say) PHP programming... This shallow understanding means that
'they' will
At 12:53 PM + 1/7/02, George Pitcher wrote:
One of the features of the FMPro solution is that when a user is looking at
a list of resources (in fact, university course packs) each row will display
the number of associated records from the 'books' database. Now which is the
best method to do
Hi Rick,
many people have a very shallow understanding of SQL - particularly
[he says generalising like crazy] people who 'fall into it' from
(say) PHP programming... This shallow understanding means that
'they' will tend to do too much in PHP (assuming they know it better)
in preference
David,
=Prevailing wisdom in system design suggests that the data should be
'designed' first, and 'code'/processing
only later (relational or structured design philosophy, even
object-oriented design). Accordingly I recommend
considering which parts of your current files should be converted
George,
=I was pleased to hear from Miles. There are likely to be as many suggestions for how
things should be done, as
there are developers. I'll be interested to hear from others - personally (cf on the
list) if the comments might
'interfere'/argue a case (and thus risk muddying your waters)
PROTECTED]]
Sent: Wednesday, January 09, 2002 7:23 AM
To: George Pitcher; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Concept help required
=The purpose of an ELH diagram is to take a piece of data
(in your case, because we are assuming/checking
normalisation, I'd 'cheat' and work at the table
Pitcher; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Concept help required
=The purpose of an ELH diagram is to take a piece
of data
(in your case, because we are assuming/checking
normalisation, I'd 'cheat' and work at the table
level -
rather than something more atomic like the
data-item
George,
=As a general comment, it is always dangerous to replicate when shifting
platforms, better to reverse engineer
and then implement anew and taking advantages of the strengths of the new
tools. This particularly when moving
into the relational field...
Perhaps the use of the word
when I get back in.
Regards
George
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 08, 2002 1:07 PM
Subject: Re: [PHP-DB] Concept help required
George,
=As a general comment, it is always dangerous
: Tuesday, January 08, 2002 1:07 PM
Subject: Re: [PHP-DB] Concept help required
George,
=As a general comment, it is always dangerous to replicate when
shifting
platforms, better to reverse engineer
and then implement anew and taking advantages of the strengths of the
new
tools
For DL Neill:
Like the 3 box approach. A very strong image for separating the
functionality. Why don't you write it up as an article for DevShed or
WebMonkey? If you look at the traffic on the list there are lots of people
who just see PHP pages as happening and have no clear understanding
George,
Suggestions interspersed below
Miles
At 12:53 PM 1/7/2002 +, George Pitcher wrote:
Hi all,
In trying to learn PHP (and MySQL), I am attempting to replicate a
database-web solution built previously using Filemaker Pro and Lasso (on
NT). I am currently working with PHP/MySQL on NT
.
If a single query is taking so long, what will 6 do to my database's overall
performance? Would indexing help?
George
- Original Message -
From: Miles Thompson [EMAIL PROTECTED]
To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, January 07, 2002 1:29 PM
Subject: Re: [PHP-DB
George,
In trying to learn PHP (and MySQL), I am attempting to replicate a
database-web solution built previously using Filemaker Pro and Lasso (on
NT). I am currently working with PHP/MySQL on NT and will be moving this to
Linux before the end of January.
=As a general comment, it is
DL Neil,
Thanks for your response.
=As a general comment, it is always dangerous to replicate when shifting
platforms, better to reverse engineer
and then implement anew and taking advantages of the strengths of the new
tools. This particularly when moving
into the relational field...
22 matches
Mail list logo