I am creating an application using SharePoint List for storing the data. The data design would pretty much similar like if you are going to put it in a relational database, with items like many to many relationship, primary keys, foreign keys.
I would like to know what are the best practices?
Is it Possible to maintain the entity relationship data in lists ? How can the duplication be avoided?