-
SQL View and Flexible DataBase Design
The major subject of our database is PRODUCT.
PRODUCT has hunderds unevenly distributed attributes known for us
and hunderds not yet defined.
The following shema has been proposed to solve problem of undefined attributes.
PRODUCT table
*ProductID
ProductAttributeID
ProductAttributeValue
PRODUCTATTRIBUTE table
*ProductAttributeID
ProductAttributeType
ProductAttributeDescription
Customer can easily define new attribute by adding new record to PRODUCTATTRIBUTE table.
QUESTION : How to build the VIEW where values from ProductAttributeDescription would be
the column names and ProductAttributeValue would be row value
ProductID | ProductAttributeDescription (1) | …………….. | ProductAttributeDescription (N)
1 ProductAttributeValue ProductAttributeValue
2 ProductAttributeValue
Any comments greatly appreciated
Thanx
Alex
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|