I am designing for an ecommerce application, I need to know how to implement the following task.
There are 2 options,
- Unregistered Users (Free Listing).
- Registered Users.
In this the unregistered users will give all their data but they are not registered with our site.
The registered users will give data and becomes partner with our site.
I have designed the table to store both the data on a single user registration table, but I need to separate both these users, so that I can handle them separately, How to do this? I am expecting some kind of reference / books on enterprise level database design strategies, so that I can learn and understand.
Thanks in advance.