Iam working on software for jewelery store for their book keeping purpose.
The owner sells
Sets,half sets locket set,Rings,24kt bars and so on.
Each of the above categories have Several sub categories or rows.
Like Date ID maker Type Amount adn so on.
So he wants all these with also their SALE and PURCHASE category.
Iam confused to how structure the database Should i create several databases for each Sets,Half sets and under each of them two tables of SALE and PURCHASE and those tables will have rows like ID,Type etc?