1. Data comes from diff sources so I decided on having a combination of auto generated and composite primary keys throughout the database. I have been doing a lot of research from books and websites; and I am getting a mixed response on whether to use a surrogate key or a natural key. Could you please let me know If i am on the right path based on the attached er diagram.
2. Product details repeats in order, invoice and product master. I thought of just using the product master table for product details. But the business requires product details to repeat in purchase order and invoice for comparison purposes.
This rule is resulting in a lot of data redundancy. I have tried normalizing all the tables till the 2nd normal form, and I am not sure how further shd i normalize.
3. All the above data which we get just sits in the database; without any updates or changes in the data.
Please do bear with me; as I am a fresher and my questions may sound silly. Thanx in advance for the help.