I am working on a Inventory & Billing Management System. I am having some problem with the design of some tables. The problems are as follows
1. I have a product table. Where I am storing the product details, but the problem is that each product have an unique serial no, generated by the manufacturer. Now I want to store the serial number in my database. What should be my approach for this?
2. The second problem is with my billing section. I would like to save each and every bill generated from my system for future use. Now any bill may have a single item (single quantity)/ single item (multiple quantity)/ multiple items(single quantity)/multiple items (multiple quantity). Now I would like to have the serial number(s) also be included in the bill, for future reference. What would be the table structure for this?