On Tue, 5 Sep 2006 16:11:43 +0000 (UTC)
Tony Theodore <[EMAIL PROTECTED]> wrote:
> Enrico Morelli <morelli <at> cerm.unifi.it> writes:
>
>
> > gg | integer | not null
> > day | character varying(3) |
> > av1000 | character varying(50) |
> > av200 | character varying(50) |
> > av400 | character varying(50) |
> > av500 | character varying(50) |
> > av600 | character varying(50) |
> > av700 | character varying(50) |
> > av700b | character varying(50) |
> > av700wb | character varying(50) |
> > av800 | character varying(50) |
> > av900 | character varying(50) |
> > relaxometer | character varying(50) |
> > av1200 | character varying(50) |
> > av1300 | character varying(50) |
>
> Not directly related to this problem, but have you thought about
> normalizing the the table instead of altering it?
>
> Tony
>
Thanks Tony,
but I don't understand your suggestion, sorry. The
normalization is a process that eliminates redundancy, organizes
data efficiently, reduces the potential for anomalies during data
operations and improves data consistency (from wikipedia).
Do you see some anomalies or other strange things in my table?
How can I normalize the table instead of altering it to add a new
instrument to the existing table (I'm using postgre)?
--
-------------------------------------------------------------------
(o_
(o_ //\ Coltivate Linux che tanto Windows si pianta da solo.
(/)_ V_/_
+------------------------------------------------------------------+
| ENRICO MORELLI | email: [EMAIL PROTECTED] |
| * * * * | phone: +39 055 4574269 |
| University of Florence | fax : +39 055 4574253 |
| CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY |
+------------------------------------------------------------------+
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
