Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mkkb917
Starting Member
14 Posts |
 Posted - 2013-10-05 : 08:51:36
|
| siri am newbie and designing a database in SQL Server Express edition.here i am facing a problem as followscenario:- there are Entity ACCOUNT that will have some Attributes like registration date, name, address, and the IP address and there is another Entity ZONE that will have the attributes called ZoneName, FirstIP, LastIP. ZONE will be created by user like ZoneName="Block B", First IP= "192.111.0.1", Last IP= "192.111.255.255"now Problem is each Account is assigned a unique IP address from the drop down list of a Zone and when the account is being created on new registration form , the remaining IPs of the Zone will appear in the combo box list and user can select it easilyi am facing the difficulties of creating such a database tables and relations plz help me how to do this.thanks |
|
|
mkkb917
Starting Member
14 Posts |
Posted - 2013-10-05 : 08:52:47
|
| In ZONE table ZONENAME is PK and In ACCOUNT Table USERNAME is PK |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-07 : 06:11:12
|
| So you want entire IP addresses in range to be displayed in combo against each user?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
how tocreate this database