By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,105 Members | 2,620 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,105 IT Pros & Developers. It's quick & easy.

Sql Server database creation Problem

P: 17
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
Apr 5 '08 #1
Share this Question
Share on Google+
2 Replies


100+
P: 142
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
Apr 7 '08 #2

ck9663
Expert 2.5K+
P: 2,878
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
Apr 7 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.