Posted - 10/05/2013 : 08:51:36
i am newbie and designing a database in SQL Server Express edition.here i am facing a problem as follow
scenario:- 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= "220.127.116.11", Last IP= "18.104.22.168"
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 easily
i am facing the difficulties of creating such a database tables and relations
plz help me how to do this.