What are the rules for making best data model?

[khadeer]

Hi all

Plz suggest me the best approches for data model?

How i can check that data is not have duplicate values?

How to link the tables in different scenarios like 2 r more transactions n 5 masters like this..... what r different scenarios n solutions for those?