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.
The unregistered users will give all their data but they are not registered with our site.
The registered users will give data and become a partner with our site.
I have designed the table to store the data for both user types on a single user registration table. Now 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.