hey forum,
long time @ SP …a warm hello then…lol
All I’m tryin to design a yellow page directory…
but got some problem with database design. I have two type of audiences…
- Online Traffic (User Searching our yellow pages LIVE)
- Business to be registered
What i feel there must be these tables
- Business (Will contain all the information about business, and other identifiers)
- City (Which contain list of cities + states + countries)
- Categories
- User Reviews
- User Registration Table
- Business Rating Table
All looks great to me, but just one…3).
Categories, how to deal with this, when sub-categories come to existence…
thanks for your help in advance…