Home -> Usenet -> comp.databases.oracle -> A data model for a school project - Model the inventory for computer manufacturing process

A data model for a school project - Model the inventory for computer manufacturing process

From: consultant76 <gguion_at_austin.rr.com>
Date: 4 Nov 2001 12:17:18 -0800
Message-ID: <f4eca69a.0111041217.727ec350_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 Sun Nov 04 2001 - 21:17:18 CET












Original text of this message