Warehouse Attributes model

Posted by Orapps on Stack Overflow See other posts from Stack Overflow or by Orapps
Published on 2009-08-12T22:27:45Z Indexed on 2010/05/20 4:00 UTC
Read the original article Hit count: 195

Filed under:

i am giving a training project for building a schema the following is the question all i would like to ask you guys is i am not sure what attributes would come in the table please see the problem below...

create one new company and attach 10 attributes to the company. the company has two warehouses one in Torrance and another in Costa mesa. each warehouse should have 10 attributes. the company sells 100 products and services. each product and services should have 10 attributes. the company received orders. the orders should have HEADERS and Lines (am not sure what these are). each headers and lin should have 10 attributes. there should be a table for quantity on hand. the quantity on hand will increase once the warehouse receives good.

please i only want some hints or clues on what attributes would generally come in this highlighted tables. thanks for help in advance guys....

© Stack Overflow or respective owner

Related posts about oracle10g