Question about a specific Entity Model
Posted by: Eslam Elbyaly
Date: December 22, 2017 01:59AM

Hi,
I am developing a system for purchasing, storing, and selling products. it should be compatible with different industries like "Food and Beverage", "Apparel and footwear", "Pharmacies" among others.
Some industries might require storing attributes like (Expiry date, Lot no., weight, etc...) for some products and others might not. And may be there is an industry which require storing those information for some products and not for other products.

- What is the right way to define products? Should I only define the product (item_id, name), or define the product and the related attributes in a child table (item_id pk, name) (item_id fk, attribute_id)?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.