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 |
|
inancgumus
Starting Member
40 Posts |
 Posted - 2002-06-13 : 06:11:49
|
| Hi,My DB Structure is like this:Prefixes are:------------------tb = TablePrd = ProductLoc = LocationCat = CategoryComp = CompanyDtl = DetailDesc = DescriptionTable and fields are:---------------------- tbProducts (iPrdID, iCatID, iCompID, iPrdPrice, iPrdDetailID)- tbPrdCats (iCatID, iParentCatID, iPrdDetailID)- tbLocations (iLocID, iParentLocID, sLocName)- tbCompanies (iCompID, iLocID, iDetailID)- tbBrands (iBrandID, iDetailID)- tbDetails (iDetailID, sDtlDesc, sDtlInfo, sDtlDetailedInfo)- tbProducts table contains product data, its category key, its company key, its price data, its detail key)- tbPrdCats table contains product category data and parent category data for tree like structure.- tbLocations table contains 'where is the company?' data.- tbCompanies table contains company data and its location.- tbBrands table contains brand information for a product with using tbDetails table's key.- tbDetails table contains template like information for other tables are using.****In this structure, my database design is consisting of many table which are have relationships with tbDetails table for describing their data.tbDetails table is like an information source table. Other tables are getting their informations from this table.Same field names in a table and in an other table is a relation.How the value of the design of my database? Is it ready for millions of records? (I'm thinking only db structure, please do not talk about the hardware specific issues)And my second question is that:-------------------------------If one of my customer is want to display 'which company is the most cheapest company in the los angeles that is selling scanners?'How can write a query for a state like this?Thank you so much!Best Regards.. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
|
|
Complex Query About Finding Cheapest Shops