由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - should all category/subcategory name be different in a database?
相关主题
database design issue免费送酒店入住 25000 SPG Points Bonus 赶快申请SPG 信用卡
请帮我看看,什么地方错了?better solution for cross table query in sql?
搞不定了Amex SPG卡白送25K points 可换500刀现金 最佳酒店卡
summary data by category in ArcGisAmex SPG卡白送25K points 可换500刀现金 最佳酒店卡
Help on Oracle QueryAmex SPG卡送25K points 白送500刀现金 最佳酒店卡
mysql 问题 (转载)Amex SPG卡送25K points 免费送500刀现金 最佳酒店卡
rsArray 为啥写不全? (转载)Amex SPG卡送25K points 白送500刀现金 最佳酒店卡
一个简单的ACCESS SQL 问题提供salesforce内推
相关话题的讨论汇总
话题: names话题: database话题: different话题: brand
进入Database版参与讨论
1 (共1页)
s****h
发帖数: 1329
1
consider desktop and laptop categories, using brand names for the
subcategories like HP, Compaq... then I'll have same subcategory names,
although under different categories.
I think all names should be different in a database, but on the website, it
looks better if we just use the brand names under each category, Like
Bestbuy, Circuitcity's websites. So does that mean they are using the brand
names as their subcategory names in the database as well?
I don't know anything about web developing,wo
a*******t
发帖数: 891
2
I don't think you are looking at this problem from the right angle
simply put, you should have a database with multiple tables, for example,
table_ComputerType
(computerType_ID, primary key
computerTypeName (desktop, laptop, tablet, handheld, etc))
table_Brand
(brand_ID, primary key
brandName (HP, Dell, etc))
table_Inventory
(inventory_ID, primary key
computerType_ID, forgien key
brand_ID, forgien key
Description ("due core 2 2.8GHz, 2GB ram, $1299!!!!!" etc))
if you really want a scable and mor

【在 s****h 的大作中提到】
: consider desktop and laptop categories, using brand names for the
: subcategories like HP, Compaq... then I'll have same subcategory names,
: although under different categories.
: I think all names should be different in a database, but on the website, it
: looks better if we just use the brand names under each category, Like
: Bestbuy, Circuitcity's websites. So does that mean they are using the brand
: names as their subcategory names in the database as well?
: I don't know anything about web developing,wo

1 (共1页)
进入Database版参与讨论
相关主题
提供salesforce内推Help on Oracle Query
Amex SPG卡送25K points 免费500刀现金mysql 问题 (转载)
Amex SPG卡送25K points 免费送500刀现金 最佳酒店卡rsArray 为啥写不全? (转载)
Amex SPG卡送25K points 免费送500刀现金 最佳酒店卡一个简单的ACCESS SQL 问题
database design issue免费送酒店入住 25000 SPG Points Bonus 赶快申请SPG 信用卡
请帮我看看,什么地方错了?better solution for cross table query in sql?
搞不定了Amex SPG卡白送25K points 可换500刀现金 最佳酒店卡
summary data by category in ArcGisAmex SPG卡白送25K points 可换500刀现金 最佳酒店卡
相关话题的讨论汇总
话题: names话题: database话题: different话题: brand