Thanks for the reply it is actually an assignment.
I will tell you what are the Requirements.
The store uses a manual accounting with books.They have one Stock or Inventory account and the other is sale account.
3.Half sets and so on like 30 more jewellery items.
If they want to record sale or purchase of an item like Sets it has the following titles.
3. Amount and so on.
What im confused is with wether i can do all that one database?
I have figured out another way. Is it fine?