Groups > comp.databases.ms-sqlserver > #1680

Re: A question about relationship

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: A question about relationship
Date	2014-02-11 23:23 +0100
Organization	Erland Sommarskog
Message-ID	<XnsA2D1EDE93A554Yazorman@127.0.0.1> (permalink)
References	<ldan3d$f0i$1@dont-email.me> <XnsA2D0F0AEE3E6Yazorman@127.0.0.1> <lddcn4$i2b$1@dont-email.me> <XnsA2D1DEE31704BYazorman@127.0.0.1> <db324895-b223-441a-8a26-180da7b3981f@googlegroups.com>

Show all headers | View raw

 (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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

A question about relationship "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-10 15:18 +0100
  Re: A question about relationship Erland Sommarskog <esquel@sommarskog.se> - 2014-02-10 23:39 +0100
    Re: A question about relationship "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-11 15:39 +0100
      Re: A question about relationship Ross Presser <rpresser@gmail.com> - 2014-02-11 07:11 -0800
        Re: A question about relationship bradbury9 <ray.bradbury9@gmail.com> - 2014-02-11 08:43 -0800
          Re: A question about relationship Ross Presser <rpresser@gmail.com> - 2014-02-11 09:33 -0800
        Re: A question about relationship Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2014-02-11 18:01 +0100
      Re: A question about relationship Erland Sommarskog <esquel@sommarskog.se> - 2014-02-11 21:54 +0100
        Re: A question about relationship rja.carnegie@gmail.com - 2014-02-11 13:49 -0800
          Re: A question about relationship Erland Sommarskog <esquel@sommarskog.se> - 2014-02-11 23:23 +0100

csiph-web