i have to store the data from the customer order-sheets.
in this business, they organize the garments(product)
according to the colour.then each color is divided
in to sizes like s,m,l,xl,xxl.
mens brief-bule-s-1000 nos.
mens brief-bule-m-1000 nos.
mens brief-bule-l-1000 nos.
mens brief-yellow-s-1000 nos.
mens brief-yellow-m-1000 nos.
mens brief-yellow-l-1000 nos.
i have to split the data into multiple tables to avoid the
redunduncy,and data repetetion.
i split the data into these tables.
the ordered_items table stores the relationship among the
above entities and the order_quantity.
because of the hierarchical nature ,i could not design the tables; to avoid multipe select statements and
update statements(using jdbc,sql) during edit and list oprations.
could you give a solution to design tables and the logic to get data using jdbc,sql.
i waits for your kind suggestion and advice.
thanking you sir.