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: 233
        
oracle10g
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