SQL Database Schema Design For Large 3 Billion Relationship Database.
- by K-Bell
Get your geek on. Can you solve this?
I am designing a products database for SQL Server 2008 R2 Ed. (not Enterprise Ed.) that will be used to store custom product configurations for over 30,000 distinct products. The database will have up to 500 users at a time.
Here is the design problem…
Each Product has a collection of Parts (up to 50 parts…