Re: Newbie question about db normalization theory: redundant keys OK?
Date: Sat, 15 Dec 2007 07:30:52 -0800 (PST)
On Dec 15, 4:56 am, "David Cressey" <cresse..._at_verizon.net> 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 Received on Sat Dec 15 2007 - 16:30:52 CET