You're the master, I'm the apprentice

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.

Now my 3 services have subsets, if I were to implement a "true" DBMS, would I have to create tables for each product's subsets? Size, color, etc... I'm not going to implement this, but if, is the above question's answer in the affirmative?

Thanks,
Dave Received on Mon Sep 16 2002 - 02:16:13 CDT