>
> From: "Paul F" <[EMAIL PROTECTED]>
> Date: 2003/11/28 Fri PM 04:35:04 CST
> To: "'mysql users'" <[EMAIL PROTECTED]>
> Subject: RE: Please analyze my project table design
>
>
> Thanks guys. I thought that normalization would
very concerned with how I have setup the PK/FK/indices!
Thanks guys!
The repeated column names for example phone_number
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]
Sent: Friday, November 28, 2003 3:49 PM
To: mysql users
Cc: [EMAIL PROTECTED]
Subject: Re: Please analyze m
>
> From: David T-G <[EMAIL PROTECTED]>
> Date: 2003/11/28 Fri PM 03:49:17 CST
> To: mysql users <[EMAIL PROTECTED]>
> CC: [EMAIL PROTECTED]
> Subject: Re: Please analyze my project table design
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
...and then [EMAIL PROTECTED] said...
%
...
% I don't know of a DB theory rule that says it's a bad idea to have the same columns
in many tables, but it might make the design more compact to take the common stuff and
put it into one table.
Oh,
>
> From: "Paul Fine" <[EMAIL PROTECTED]>
> Date: 2003/11/28 Fri AM 11:14:25 CST
> To: <[EMAIL PROTECTED]>
> Subject: Please analyze my project table design
>
> Greetings, my "hands on" school project is a small real estate database.
>
> I am using MySQL 3.23 without InnoDB, but would like to m
