Re: Data modeling for a manufacturing model - student working on a school project. I need help.

De we get the grade if we give you the answer? Seriously though, from the questions you asked, you really have a pretty good understanding of the problem. Keep in mind that there are often several solutions, with advantages and disadvantages to each. Define the possible solutions, evaluate their pros and cons, and the best solution will become self-evident. For example, There is another way to look at the hard drives. Maybe there are different kinds of hard drives, defined by their intended purpose. How would you model that? Different tables, an identifying column? Just think it through, you'll get it...

"consultant76" <gguion_at_austin.rr.com> wrote in message news:f4eca69a.0111041218.5384f063_at_posting.google.com...
> I am a student at UT Austin and I have been assigned to a team
> project. Our assignment is to model a computer business that
> manufactures computers and sells them in the retail market along with
> other peripherials and software. Here is my question (I will use an
> illustration to detail):
>
> Lets say you order 10 harddrives from a supplier and our company has
> allocted 7 to be used in assembly of computers and the other 3 will be
> sold via the retail market. How is each item defined in the system?
> Do the 7 go into Raw Materials and the other 3 go directly into
> Finished Goods and skip the raw materials table or do they go into raw
> materials and just move directly to the finished goods? How is all of
> this defined?
>
> Here are the entities we have:
>
> RAWMATERIALS - components used in making a PRODUCT.
> FINISHEDGOODS - a PART that is ready to be shipped as a PRODUCT.
> PART - the type of physical item that goes into a PRODUCT.
> INVENTORYITEM - represents the physical occurence of one and only one
> PART that may be offered as a GOOD.
> GOOD - a subtype of a PRODUCT.
> PRODUCTS - which are inventory items ready to be sold.
>
> I got the above details from a book about data modeling, but I don't
> understand it all either nor do I know what I really need. Since this
> is the first db course I am taking the professor has dummied the
> project up so we only need to model this at a basic level so we do not
> need to get very complex with subassemblies etc.
>
> We really need your help.
>
> Thanks,
>
> Gary Guion
>
> gary.guion_at_bba00.bus.utexas.edu
Received on Mon Nov 05 2001 - 16:25:03 CET