Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!iuvax!bsu-cs!mithomas From: mithomas@bsu-cs.bsu.edu (Michael Thomas Niehaus) Newsgroups: comp.databases Subject: Re: Do you normalize? Keywords: normalization Message-ID: <8298@bsu-cs.bsu.edu> Date: 20 Jul 89 00:10:16 GMT References: <242@6sigma.UUCP> <1581@cod.NOSC.MIL> Organization: CS Dept, Ball St U, Muncie, IN, USA Lines: 21 In article <1581@cod.NOSC.MIL>, dberg@cod.NOSC.MIL (David I. Berg) writes: > > > Do you normalize your databases? > ... > I usually normalize to 3NF, I do it by hand, and I use INFORMIX. I will clain to normalise to 3NF all the time as well, but sometimes it is not worth the trouble. Especially when having to use dBase. If I am using Oracle or some other SQL product that will do joins for me, 3NF is not a problem. I, too, do it by hand, but I do not claim to perform this normalization to perfection. (At least I don't have tables that have 128 fields in them.) -Michael -- Michael Niehaus UUCP: !{iuvax,pur-ee}!bsu-cs!mithomas Apple Student Rep ARPA: mithomas@bsu-cs.bsu.edu Ball State University AppleLink: ST0374 (from UUCP: st0374@applelink.apple.com)