Re: Need help designing db
From: Steve (Steve_at_discussions.microsoft.com)
Date: 07/22/04
- Next message: Steve: "RE: !Re: Need help designing db"
- Previous message: Steve Schapel: "Re: single or multiple tables"
- In reply to: Rick B: "Re: Need help designing db"
- Next in thread: Steve P.: "Re: Need help designing db"
- Messages sorted by: [ date ] [ thread ]
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 spreadsheet 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
>
>
>
- Next message: Steve: "RE: !Re: Need help designing db"
- Previous message: Steve Schapel: "Re: single or multiple tables"
- In reply to: Rick B: "Re: Need help designing db"
- Next in thread: Steve P.: "Re: Need help designing db"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
