You're the master, I'm the apprentice
From: Dave <dave_at_dmcomm.com>
Date: Mon, 16 Sep 2002 01:16:13 -0600
Message-ID: <Cyfh9.43$2k1.38380640_at_news.incc.net>
Tools on hand: MS SQLSVR 2000, ColdFusion Hands on hand: Only 2
Skill: Novice
Problem: see below
I mean this process is over, the services are ordered...there's a work-order #, but there's
nothing to track, process is over.
Date: Mon, 16 Sep 2002 01:16:13 -0600
Message-ID: <Cyfh9.43$2k1.38380640_at_news.incc.net>
Tools on hand: MS SQLSVR 2000, ColdFusion Hands on hand: Only 2
Skill: Novice
Problem: see below
I have customers (CUSTOMER table) and they can choose 1 or all 3 of my
services (phone, cabletv, internet).
I'm not offering these services anymore, just want to store names,
addresses, and what they got.
It just seems like an awful waste of space if I have one CUSTOMER table
with columns for the up to 3 services they have already ordered. There'd be
a lot of
empty fields if they only ordered one service!
For only 3 products is it worth the space to have a PRODUCTS, ORDERS or even ORDER_LINE tables to converge all?
Normalization points to this, but I don't foresee doing any complex manipulation with this DB...
I mean this process is over, the services are ordered...there's a work-order #, but there's
nothing to track, process is over.
It was all done in person with pen and paper.
Thanks,
Dave
Received on Mon Sep 16 2002 - 09:16:13 CEST