-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: googlyboy4u
Message 2 in Discussion
One approach would be to define a new
table containing the fields User ID, Property ID and Priority Order (new field
defined to store priority order). Yes, you will have to store the preference for
each user. I am not sure if this is the best approach though. Experts, your
comments please ...
Regards,
Sachin
----- Original Message -----
From:
DotNetSaavy (Mr.BabuRaj)
To: BDOTNET
Sent: Thursday, September 11, 2003 6:24
PM
Subject: SQL Server Database Design
ISSUE
New Message on BDOTNET
SQL
Server Database Design ISSUE
Reply
Reply to Sender Recommend
Message 1 in
Discussion
From: DotNetSaavy (Mr.BabuRaj)
I have two tables as follows in SQL Server 7.0 (Note SQL
Server is not 2000)
One of the tables will have user
information like
Table Name :- User Information
UserId
Name
Region
******
****
******
Ind1
Babu
12
Ind2
Raj
3
Ind3
Dinesh
2
Ind4
Kumar
1
Table Name :- Property table
PropertyID
PropertyName
********** ************
1
Color
2 Height
3
Width
4
Volume
-
-
-
-
-
-
600
Weight
Now when the user enters the site all the 600 properties
are displayed in a tabular form.
The problem is each user will have his own preference on
the order of display of these 600 properties.
User A may want
the 600th property to be displayed first and then the
others,
User B may want the 4th property to be displayed
first and then the others.
In this kind of a scenario how
should I store the order preference of each user in another
table.Should I make use of a junction table or is there any
other approach.
Assume I have 1000 users ,for each user I should store the
preference.
Thanks
BABURAJ
View other groups in this
category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
