I planning to create tables which hold data related to my users. These tables contain the items that each user owns, and there is no exhaustive list of all the item. The number of items owned by a user might vary from 0 to 100. So the number of items owned by a user is not fixed. For example, A user "Sam" might have "iPod, MacBook, Car, House", while some other user "Dave" might have "Bike, Plane, iPhone, TV ...." etc. So what is the best schema for the tables? I came up with the following idea. Please suggest improvements if any:
I will have a table which holds data as follows:
User Item ========= ========= Sam iPhone Sam MacBook Sam Car Sam House Dave Bike Dave Plane Dave iPhone Dave TV . .