|
 |
asp_databases thread: SV: Re: SV: very important
Message #1 by =?us-ascii?Q?Hakan_Frennesson?= <hakan@c...> on Sat, 16 Feb 2002 14:59:13 +0100
|
|
Hi!
If a subcat is related to a category you can do this:
tbl_category:
CatID, Catname
tbl_subcategory:
SubcatID, Subcatname, CatID
tbl_accessory:
AccID, AccName, SubcatID, Color, Weight, etc
Relate CatID in tbl_category with CatID in tbl_subcategory (one-to-many
relation)
and SubcatID in tbl_subcategory with SubcatID in tbl_accessory (one-to-many
relation)
I should really know more about what you want to achieve with your database
to design it properly, but my first solution is easiest and will probably do
the job for you.
The people that fill out the form, are they suppose to categorize and
subcategorize each item themselves?
Taking a lot for granted, I assume they fill in what category and
subcategory a certain item belong to together with all the information that
goes with each item.
Am I correct, or is the assumption totally wrong?
Hakan
-----Ursprungligt meddelande-----
Fran: arshad siddiqui [mailto:ash_arshad@y...]
Skickat: den 16 februari 2002 06:03
Till: ASP Databases
Amne: [asp_databases] Re: SV: very important
Hi Hakan,
Thanks for your help.
Sorry for the delay as I was indisposed.
I didnt got your first question please explain.
Subcategory should belong to some category.I think all
the three tables should be interlinked but the problem
is how?
second thing is if I interlink the tables and make
relation then how to Upload the things.
Thanks
Regards
--Arshad--
--- Hakan_Frennesson <hakan@c...> wrote:
> Hi!
>
> There are a few questions that need to be sorted
> out:
>
> First of all, to whom do I send the bill for doing
> the design?
> Two: Does a SubCategory have to belong to a
> Category?
>
> As far as I can see, you need the 3 tables, but with
> some changes:
>
> Category:
> CatID, Catname
>
>
> Subcategory:
> SubcatID, Subcatname
>
>
> Accessory:
> AccID, AccName, CatID, SubcatID, Color, Weight, etc
>
>
> Then in the form you only insert data to one table.
> Only in rare cases you
> want to insert data in more then one table. In that
> form you have two
> dropdown boxes showing the Catnames and Subcatnames
> respectively. When form
> data is submitted ie an accessory is added to the
> the table Accessory, you
> send the CatID and SubCatID along with the rest of
> information to the
> Accessory table.
>
> This is a straight forward and simple solution.
> However, if one subcategory
> has to belong to a Category then the solution is a
> little more advanced and
> I need an answer to my first question ;-)
>
> Hakan
>
>
>
>
> -----Ursprungligt meddelande-----
> Fran: arshad siddiqui [mailto:ash_arshad@y...]
> Skickat: den 14 februari 2002 09:55
> Till: ASP Databases
> Amne: [asp_databases] very important
>
>
> Hi,
> I wanna know how to design my database.
> I want to make a database called Ramy.mdb now in
> that
> there will be three tables:
> 1.Category
> 2.SubCategory
> 3.Accessory
> Now in Category there will be two columns named
> CategoryID(P.K) and Categoryname,In SubCategory
> there
> is confusion shall I put two columns SubCatId and
> SubCatName.Then join the two tables.
> Third table is Accessory here all the details will
> be
> there along with CategoryID and SubCatName.
>
> I want to make a system where I can upload into the
> database by putting all the values of
> category,subcategory and all the details of
> accessory
> from a single form.
> Please do suggest me about the database design.
> I will be really obliged by your help
> Thank you
> Regards
> --Arshad--
>
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE Valentine eCards with Yahoo! Greetings!
> http://greetings.yahoo.com
>
> $subst('Email.Unsub').
>
>
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
$subst('Email.Unsub').
Message #2 by arshad siddiqui <ash_arshad@y...> on Sat, 16 Feb 2002 21:08:35 -0800 (PST)
|
|
Hi,
Thanks for your invaluable suggestion.
Actually I want to display all the accessories related
to a particular category and subcategory.That is fist
of all the categories shuld be displayed and when you
click on one category all of its sub categories should
come then you can click on any of the subcategory to
get all the accessories.
I wanna make an admin page also so that in that I
enter the category,subcategory and all the details of
accessory and submit it.In that case you need not have
to make entry into the database manually.
You can get a beeter idea what I want to do by going
to the following URL:
http://store.summitracing.com
I think now you must get the idea about what exactly I
need to know.
Thanks again
Regards
--Arshad-
=====================================================
--- Hakan_Frennesson <hakan@c...> wrote:
> Hi!
>
> If a subcat is related to a category you can do
> this:
>
> tbl_category:
> CatID, Catname
>
> tbl_subcategory:
> SubcatID, Subcatname, CatID
>
> tbl_accessory:
> AccID, AccName, SubcatID, Color, Weight, etc
>
> Relate CatID in tbl_category with CatID in
> tbl_subcategory (one-to-many
> relation)
> and SubcatID in tbl_subcategory with SubcatID in
> tbl_accessory (one-to-many
> relation)
>
> I should really know more about what you want to
> achieve with your database
> to design it properly, but my first solution is
> easiest and will probably do
> the job for you.
>
> The people that fill out the form, are they suppose
> to categorize and
> subcategorize each item themselves?
>
> Taking a lot for granted, I assume they fill in what
> category and
> subcategory a certain item belong to together with
> all the information that
> goes with each item.
>
> Am I correct, or is the assumption totally wrong?
>
> Hakan
>
> -----Ursprungligt meddelande-----
> Fran: arshad siddiqui [mailto:ash_arshad@y...]
> Skickat: den 16 februari 2002 06:03
> Till: ASP Databases
> Amne: [asp_databases] Re: SV: very important
>
>
> Hi Hakan,
> Thanks for your help.
> Sorry for the delay as I was indisposed.
> I didnt got your first question please explain.
> Subcategory should belong to some category.I think
> all
> the three tables should be interlinked but the
> problem
> is how?
> second thing is if I interlink the tables and make
> relation then how to Upload the things.
> Thanks
> Regards
> --Arshad--
>
>
> --- Hakan_Frennesson <hakan@c...> wrote:
> > Hi!
> >
> > There are a few questions that need to be sorted
> > out:
> >
> > First of all, to whom do I send the bill for doing
> > the design?
> > Two: Does a SubCategory have to belong to a
> > Category?
> >
> > As far as I can see, you need the 3 tables, but
> with
> > some changes:
> >
> > Category:
> > CatID, Catname
> >
> >
> > Subcategory:
> > SubcatID, Subcatname
> >
> >
> > Accessory:
> > AccID, AccName, CatID, SubcatID, Color, Weight,
> etc
> >
> >
> > Then in the form you only insert data to one
> table.
> > Only in rare cases you
> > want to insert data in more then one table. In
> that
> > form you have two
> > dropdown boxes showing the Catnames and
> Subcatnames
> > respectively. When form
> > data is submitted ie an accessory is added to the
> > the table Accessory, you
> > send the CatID and SubCatID along with the rest of
> > information to the
> > Accessory table.
> >
> > This is a straight forward and simple solution.
> > However, if one subcategory
> > has to belong to a Category then the solution is a
> > little more advanced and
> > I need an answer to my first question ;-)
> >
> > Hakan
> >
> >
> >
> >
> > -----Ursprungligt meddelande-----
> > Fran: arshad siddiqui
> [mailto:ash_arshad@y...]
> > Skickat: den 14 februari 2002 09:55
> > Till: ASP Databases
> > Amne: [asp_databases] very important
> >
> >
> > Hi,
> > I wanna know how to design my database.
> > I want to make a database called Ramy.mdb now in
> > that
> > there will be three tables:
> > 1.Category
> > 2.SubCategory
> > 3.Accessory
> > Now in Category there will be two columns named
> > CategoryID(P.K) and Categoryname,In SubCategory
> > there
> > is confusion shall I put two columns SubCatId and
> > SubCatName.Then join the two tables.
> > Third table is Accessory here all the details will
> > be
> > there along with CategoryID and SubCatName.
> >
> > I want to make a system where I can upload into
> the
> > database by putting all the values of
> > category,subcategory and all the details of
> > accessory
> > from a single form.
> > Please do suggest me about the database design.
> > I will be really obliged by your help
> > Thank you
> > Regards
> > --Arshad--
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send FREE Valentine eCards with Yahoo! Greetings!
> > http://greetings.yahoo.com
> >
> > $subst('Email.Unsub').
> >
> >
> $subst('Email.Unsub').
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Sports - Coverage of the 2002 Olympic Games
> http://sports.yahoo.com
>
> $subst('Email.Unsub').
>
>
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
|
|
|
View Cart
