Re: Purchasing, selling and Stocking of products.
Peter Brawley Wrote:
-------------------------------------------------------
> ?! On the barcode example you gave, "1152019"
> would mean id=11, size=5, expiry_date=2019; string
> processing would be needed to extract the size
> element from stored barcode values for a query,
> and this would preclude index optimisation of that
> query clause.
I am thinking of not only storing "Barcode" value, but also will store the attributes, like that,
Barcode, Size, Expiry_date
---------------------------------
1152019, 5, 2019
> And naturally, vendor-specific
> barcodes will have errors,
Why will there be errors?
2- This link
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.html was very helpful, is it a Chapter from a book? If so, please provide me with a link for the whole book or it's name.
3- I read books before talking about "systems analysis and design" but all of them was just talks in theory, and I think(correct me if I am wrong), the database design should be implemented based on some scientific rules but also according to my thoughts to deal with the requirement, those thoughts that can conflict with the scientific rules, So to be good at database design, I should see practical cases and see how designers thought of implementing the scenarios and see demonstrations tell me why they did it like that.
Do you know of a way which can provide me with such thing?