Sql Server database creation Problem

[furqanms]

Hello Friends

I am developing a project in asp.net 2005 with c# and sqlsever 2005.In a project I have multiple companies in a group. As Below
[HTML]
<pre>

[Company Group : A] [Company Group : B]
[Company : 1] [Company: 2] [Company :1] [Company :2]

</pre>
[/HTML]
So I want to create database companywise under the group in sqlserver 2005.So how can I do this.

If anyone has any idea about this please help me it is urgent.

Thanking you

[balame2004]

Hi,

Try to create two tables.

1.CompanyGroups [CompanyGroupId,GroupName,Address,City,State,etc]
2.Companies[CompanyId,CompanyGroupId(References(FreignKey) CompanyGroupId of CompanyGroups table),CompanyName,Address,etc]

Regards,
Balaji U

[ck9663]

This would depend on the system that you are doing. If you want to create a database (not tables?) you can create it based on some form of naming convention payABytes could be a payrolls system for Group A for company Bytes, Inc.

-- CK