Database Structure Opinions Please

I am at the planning stage of building a database that will have a fairly
large amount of different information. It is a DB for law firms, so it will
have all of their contact information including a county. Also an individual
lawyer will be listed. Add to that 2 description areas (one for firm, one
for lawyer), then there will be individual check boxes for areas of
practice, I am thinking about 10.

There will also be a need to store articles that will be written by these
attorneys.

I am thinking one main table with the firm info, a separate table for atty
info, third for areas of practice and fourth for articles?

I would enjoy hearing opinions on this.

--
Gary



__________ Information from ESET Smart Security, version of virus signature database 5868 (20110212) __________

The message was checked by ESET Smart Security.

http://www.eset.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org