Our company has its Departments And Services.

Now We are making it online.

Both have separate email list, phone numbers, and more.

Will I make one table and adds the field Type (Values: D or S).

Or make them separate.

Remember one thing If we merge them then Email And PhoneNumber Table will also me merge

other wise they will also separate.

What is better.

Hi,

I'm sure there's many different ways to do this and many different preferences. Personally, I would make a bit column to identify whether or not the info was for Departments. If bit is '1' then its Departments. If bit is '0' then its Services. If the company adds more departments later on then you can add another bit column for the new department.

Then you won't have to worry about merging data later on if that happens. It will all be in the same tables. And you won't have any problem separating the data if you have to.

Hope this helps.

Rstelma

Or you could create a separate table called DepartmentTypes with an Id and a Description. Then store a foreign key to the DepartmentTypes in your other tables.

Muhammad: care to respond to my personal message in reply to your? It looks like you're offended but I don't understand why... ;)

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004