| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Large databases
CREATE TABLE PERSON (
PERSON_ID NUMBER, FNAME VARCHAR2(20), MNAME VARCHAR2(20), LNAME VARCHAR2(30), RACE_ID NUMBER(25), /*allows for proliferation of pc categories */ BIRTH_DATE DATE, AGE NUMBER(3), HANDEDNESS CHAR(1), SEX CHAR(1), HEIGHT NUMBER(3), WEIGHT NUMBER(3), WAIST NUMBER(2), INSEAM NUMBER(2), COLLAR NUMBER(2), ARM_LEN VARCHAR2(5), HAT_SIZE VARCHAR2(4), SHOE_SIZE VARCHAR2(5), EYE_COLOR_CD VARCHAR2(3), HAIR_COLOR_CD VARCHAR2(3), MARRIED CHAR(1), EDUCATION_CD NUMBER(1),
Now, that's over 20 and afaik normalized, no repeating groups, no dependency on non key atttibutes, just to point out that aribitrary numerical limits don't mean much if no business requirements are in view.
Allan
-----Original Message-----
Sent: Wednesday, April 16, 2003 2:53 PM
To: Multiple recipients of list ORACLE-L
> > Just a thought, but if you have more than 4 you're probably not
>normalized
> > very well.
>From: "Igor Neyman" <ineyman_at_perceptron.com>
>Is this an "n-th" rule of normalization? -:)
1st and 4th normal forms would apply here. Basically, if you have 20
columns in a table I doubt you're properly normalized, although you
could
easily still be messed up with less columns if you didn't design it
properly. Of course, if everything were designed well in the first
place
there would be near as much demand for DBAs, hehe.
Chris Berry
compjma_at_hotmail.com
Systems Administrator
JM Associates
"Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken." -- Duke Leto Atreides
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry INET: compjma_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ______________________________________________________________________________ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: anelson_at_midf.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Apr 16 2003 - 15:43:50 CDT
 |
 |