Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!o42g2000hsc.googlegroups.com!not-for-mail From: raylopez99 Newsgroups: comp.databases.theory Subject: Re: Newbie question about db normalization theory: redundant keys OK? Date: Sat, 15 Dec 2007 07:30:52 -0800 (PST) Organization: http://groups.google.com Lines: 23 Message-ID: References: cev8j.6953$xd.6782@trndny03 <74f8b49b-95d3-4475-8d17-d156e41e2625@e25g2000prg.googlegroups.com> <692ee78d-c398-4cf2-b56f-7cd41db204da@d4g2000prg.googlegroups.com> NNTP-Posting-Host: 85.73.23.108 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1197732653 24981 127.0.0.1 (15 Dec 2007 15:30:53 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 15 Dec 2007 15:30:53 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: o42g2000hsc.googlegroups.com; posting-host=85.73.23.108; posting-account=fRZa_AkAAACE3nlFA9zM1Eq00OKq1Ycq User-Agent: G2/1.0 X-HTTP-UserAgent: Opera/9.24 (Windows NT 5.1; U; en),gzip(gfe),gzip(gfe) Xref: usenetserver.com comp.databases.theory:168178 X-Received-Date: Sat, 15 Dec 2007 10:30:53 EST (text.usenetserver.com) On Dec 15, 4:56 am, "David Cressey" wrote: > > I hinted at the answer above. Thank you very much David Cressey--your reply was very didactic for a newbie like me--you have no idea, even the smallest and most obvious hint for you is very powerful for somebody in my shoes. The part about having to code in constraints if you use GUIDs was very helpful; I got it. BTW the book by Louis Davidson (Apress) "Pro SQL Server 2005 Database Design and Optimization" is not so bad after all, he does have a chapter (that I missed the first time through) on 1NF...3NF and beyond, with the usual teaching examples of enrolling in classes and author/publisher/book. I'm also reading "Beginning C#2005 dB" by Karli Watson, and I see that if you want a cute GUI, you have to use a so-called DataSet type in DataGridView mode via C#/ADO.NET that is very cumbersome, perhaps best to stick to "console mode" (also covered) but that's a post for another forum, since I see there is a fundamental tension between the user interface designers and the database designers. RL