HI Sudheer,
THIS DESIGN IS BASED ON MY MANY-TO-ONE DIRECTION PATTERN
OF DATABASE NORMALIZATION DESIGN... PLEASE MODIFY/CORRECT IT ACCORDING TO YOUR
TASTE. AS A JAVA DEVELOPER I'M USING HIBERNATE FOR MY CREATE-UPDATE-DELETE(CUD)
AND DIRECT JDBC FOR MY QUERIES(R).
YOU MAY VARY.
HERE, HOPE
Hi Sudheer,
First of all there a number of ways to design this database.
You will need to choose the one that you feel suites your needs best.
Here one possible design.
Because you have different type of users/accounts, it looks like
ACCOUNT_TYPE table is needed
ACCOUNT_TYPE table
Because you are a novice to data base design, you have fallen into a common
trap. If you think about an array, you don't want to store multiple users in
a row, you want to store them in a column. In other words, you want to have
one table that stores businesses (once per business, probably) and