Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: A question about relationship Date: Tue, 11 Feb 2014 23:23:15 +0100 Organization: Erland Sommarskog Lines: 28 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx05.eternal-september.org; posting-host="fd3d6d0229f14a752f017d8f9903addd"; logging-data="4003"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/8K0ub5lU+G35Dg+8DzhRG" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:UDdnHyujbjlnpSNv2vwpGaZquf0= Xref: csiph.com comp.databases.ms-sqlserver:1680 (rja.carnegie@gmail.com) writes: > I don't remember if I ever worked in the Northwind database. > (My actual training was some of the authentic courses for > SQL Server 7.) So I don't know if some of its features are > included intentionally to attract criticism for extra credit > in class - you know, spot the little design mistakes. > That can be good practice for real work. Or if it's just > not particularly well done. As I understand it, Northwind comes from Acesss. 'nuff said. :-) > It bothers me a little that most database courses I've seen > are about developing yet another new customer and order database > for a business, when that's the last thing that the world needs - > unless you have an amazing new idea about how to do it. > Maybe that's what they're looking for? I think that an order database is an excellent choice for a database course, because most people can grasp the business rules fairly easily. One of the most difficult challenges in database design is to understand the problem domain. And when you are teaching the basics, you don't want the students to get lost in understanding how a more complicated scenario works. -- Erland Sommarskog, Stockholm, esquel@sommarskog.se