Kutty,
It sounds like the question is: How do I build a model?
If this is indeed the question, answering it is beyond the scope of
these newsgroups, which are meant for providing specific answers to
specific questions; on the contrary, your question is very broad and, in
my opinion, the subject of a class or, at least, some serious reading.
Do a Google search on "Entity Relationship Model" and "Relational
Database Design", you'll find lots of links for a (good) start.
HTH,
Nikos