Re: Need help designing db

From: Steve (Steve_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 13:11:02 -0700

Sorry about that, I tried to submit it once and there was an error, so I tried a couple more times but every time it said there was an error. Little did I know that it went through every time it said there was an error.

Sorry again

"Rick B" wrote:

> Steve:
>
> One post please.
>
>
> "Steve" <Steve@discussions.microsoft.com> wrote in message
> news:FE70C62D-14B4-4EE2-945A-22A0F6EA94D8@microsoft.com...
> I am fairly new to designing db's and I did one db for my company for fun
> and they liked it so much they want another one. Problem is I am having
> trouble getting the idea down on paper so I can start. Here is the
> situation:
>
> This department issues their product to our other plants. The product are
> not marked by any type of serial number so they are just bulk issued. They
> may issue 100 one day and then only return 50 the next day. (very sporadic)
> Some items may never return, maybe 1% of total usage. So....
> First,
> they have 21 diffferent products but they are tricky because they are
> resuable items so they can be issued as either "brand new/refurbished" or
> "used". I also have to note whether some of either of those use any "new
> item".
> Second,
> after the other plants use them, they must return them in the system. The
> returns are placed into 5 categories - "Good for reuse", "Need to be
> refurbished for reason 1", "Need to be refurbished for reason 2", "Lost due
> to Reason 3", Lost due to Reason 4"
>
> I have played around with a couple of ideas but none of them really feel
> right to me. The employees are used to typing all the issue information
> into an excel spread*** that has the products down the side and the "Brand
> new" and "used" in the columns 2 and 3. So I was trying to keep it looking
> the same for them so it is not too confusing.
>
> After I gather the data, I need to give them a daily qty at the plants as
> well as end-of-month information regarding usage and time spent working on
> each product.
>
> Any help would be greatly appreciated
> your truly,
> "Staring at the computer"
> Steve
>
>
>

Quantcast